Re: [sqlite] SQLite4 questions

2013-03-12 Thread Richard Hipp 
On Tue, Mar 12, 2013 at 1:57 PM, Warren Young  wrote:

> On 3/7/2013 16:14, Richard Hipp wrote:
>
>> On Thu, Mar 7, 2013 at 6:10 PM, Jeff Archer > **com 
>>
>>> wrote:
>>>
>>
>>  Will SQLite4 be capable of reading a SQLite3 database to facilitate
>>> upgrade?  (I'm guessing 'no')
>>>
>>>
>> No.
>>
>
> Is it expected to be language-compatible, at least, so you can slurp in a
> .dump file?
>

Yes, this should work:

sqlite3 old.db .dump | sqlite4 new.db



>
> I mean this question in the same sense that one always questions SQL
> compatibility: yes, there are standards, but only the naive believe all SQL
> implementations understand all SQL dialects.
>
>
> __**_
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite4 questions

2013-03-12 Thread Warren Young 

On 3/7/2013 16:14, Richard Hipp wrote:

On Thu, Mar 7, 2013 at 6:10 PM, Jeff Archer

Re: [sqlite] SQLite4 questions

2013-03-07 Thread Stephan Beal 
> > Will it be feasible to include the amalgamation of both SQLite3 and
SQLite4
> > into the same application to create an upgrade facility?
> >
>
> Yes.  The two share no symbols in common, so you should be able to link
> them both.  (This is something we need to test before the first release.)

This works (i use it) as long as both amalgamations are not compiled
together as 1 unit.

>
>
> >
> > Is there any ETA on  a complete and stable release of SQLite4?
> >
>
> No.
>
>
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite4 questions

2013-03-07 Thread Richard Hipp 
On Thu, Mar 7, 2013 at 6:10 PM, Jeff Archer  wrote:

> Will SQLite4 be capable of reading a SQLite3 database to facilitate
> upgrade?  (I'm guessing 'no')
>

No.


>
> I assume SQLite4 will be distributed in a familiar amalgamation format.
>

Yes.  You can already type "make sqlite4.c".  The amalgamation generated
that way is tested and does work.


> Will it be feasible to include the amalgamation of both SQLite3 and SQLite4
> into the same application to create an upgrade facility?
>

Yes.  The two share no symbols in common, so you should be able to link
them both.  (This is something we need to test before the first release.)


>
> Is there any ETA on  a complete and stable release of SQLite4?
>

No.


> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite4 questions

2013-03-07 Thread Jeff Archer 
Will SQLite4 be capable of reading a SQLite3 database to facilitate
upgrade?  (I'm guessing 'no')

I assume SQLite4 will be distributed in a familiar amalgamation format.
Will it be feasible to include the amalgamation of both SQLite3 and SQLite4
into the same application to create an upgrade facility?

Is there any ETA on  a complete and stable release of SQLite4?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users