Re: [sqlite] List of latest changes in CVS
>Is there a way to see a list of the latest changes made in CVS? I think you're looking for a page called "timeline". Link is is in the right most column of navigation on every page of SQLite website. http://www.sqlite.org/cvstrac/timeline If you're interested only in CVS check-ins there are some options at the bottom of this page that can help you filter out only that. Nemanja
Re: [sqlite] Memory DB to disk DB
I gues you could attach in-memory db to a newly created disk db and then do something like CREATE TABLE newDiskTbl AS SELECT * FROM memoryTbl Take a look at http://www.sqlite.org/lang_createtable.html for more details Regards, chorlya On Fri, 18 Feb 2005 11:13:40 +1100, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > I have a situation where I start with an in-memory DB, then need to save the > entire thing to a new disk DB. Does anyone know the best way to do this? > Would I attach the memory DB to a newly created disk DB? Is this even > possible? I notice the COPY command is not supported in 3.x according to the > documentation on the website, so even if I could attach it I would still need > a > way to copy the tables. Any suggestions would be greatly appreciated. > > TIA > -brett > > > This message was sent using IMP, the Internet Messaging Program. > >
Re: [sqlite] Renaming existing tables using SQLite 3.0.7?
ALTER TABLE (you can only rename tables at the moment) is only available in 3.1.x and as you can tell from the version number/name it is still officially unstable. chorlya On Fri, 11 Feb 2005 14:36:38 -0700, Dave Furey <[EMAIL PROTECTED]> wrote: > Does the ALTER TABLE renaming work for version 3.0.7? I want to rename > existing tables, but I also don't want to use non-production ready libraries > in my application. Is the 3.1.0 ALPHA version the only version where you can > use ALTER TABLE for table renaming? > > If so, how stable is the 3.1.0 ALPHA version? > > Thanks, > > Dave > >
Re: [sqlite] Problems compiling php 5.0.3 with sqlite3
On Wed, 26 Jan 2005 00:21:52 +0100, José Miguel López Coronado <[EMAIL PROTECTED]> wrote: > Hello everybody. > I'm trying to compile php 5.0.3 using the > --with-sqlite=/usr/local/sqlite/lib option among some others and I > obtain the following error code: > checking whether to enable UTF-8 support in sqlite (default: > ISO-8859-1)... no > checking for sqlite support... yes > checking for sqlite_open in -lsqlite... no > configure: error: wrong sqlite lib version or lib not found > > Any idea why is this problem arising? Because PHP doesn't support SQLite3 yet. This is PHP related so you should post on some of the PHP lists to get more info on PHP-SQLite3 plans. -- chorlya
Re: [sqlite] V2.8 or V3.0 for embedded devices?
There are some changes in CVS that introduced a few SQLITE_OMIT_* macros that are supposed to exclude some features at compile time. Since you're on embedded system, I guess you'll find quite a few features that you can omit, hence reduce memory footprint. I don't think there's any documentation for those macros yet, but check out this timeline http://www.sqlite.org/cvstrac/timeline?d=30=2004-Dec-01=2==0=1=1 (search for SQLITE_OMIT) On Mon, 10 Jan 2005 12:02:07 +0100, Markus Oliver Junginger <[EMAIL PROTECTED]> wrote: > We are developing applications that also run on PocketPC devices; Sqlite > 2.8.x is used here as the database. > > For the next release of our software the question is if we should switch > to SQLite 3. What's the experts' recommendation? The main concern is > probably memory consumption, which should be as low as possible. > > Thank you, > Markus > >