Re: [sqlite] A memvfs for loading/saving database from buffer

I try to implement One SQLite Database Per User. http://stackoverflow.com/questions/128919/extreme-sharding-one-sqlite-database-per-user Extreme Sharding: One SQLite Database Per User 2009/4/29 stephen liu > > I want to save multipile sqlite database in one file. > The

Re: [sqlite] A memvfs for loading/saving database from buffer

I want to save multipile sqlite database in one file. The backup api is not fix for this requirement. I want to save sqlite database as a entry of the dbm. For example, the user's addressbook save in a sqlite database, and the buffer of the database may be store in a dbm. 2009/4/29 Roger Binns

Re: [sqlite] A memvfs for loading/saving database from buffer

The mailing list strips out attachments. Please download from: http://spserver.googlecode.com/files/spmemvfs.tar.gz 2009/4/29 Virgilio Alexandre Fornazin > Where we can get the code ? > >

Re: [sqlite] A memvfs for loading/saving database from buffer

Where we can get the code ? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of stephen liu Sent: terça-feira, 28 de abril de 2009 22:24 To: sqlite-users@sqlite.org Subject: [sqlite] A memvfs for loading/saving database from

Re: [sqlite] A memvfs for loading/saving database from buffer

stephen liu wrote: > The attachment is a memvfs implementation for sqlite. The mailing list strips out attachments. > With the memvfs, we can loading/saving sqlite database from buffer. Even simpler, you can use sqlite3_backup API to copy from a disk to :memory: and the reverse direction when

[sqlite] A memvfs for loading/saving database from buffer

Hi, The attachment is a memvfs implementation for sqlite. With the memvfs, we can loading/saving sqlite database from buffer. There also includes a demo to show how to use it. Cheers, Stephen Liu ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Merging two databases

Consider this simple database: CREATE TABLE T1 (TestID INTEGER PRIMARY KEY, X INTEGER NOT NULL, Y NOT NULL, Z NOT NULL, UNIQUE(X, Y)); CREATE TABLE T2 (TestID INTEGER NOT NULL, X2 INTEGER NOT NULL, Y2 NOT NULL, Z2 NOT NULL); What would be the most efficient way of copying all T1

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

On Tue, Apr 28, 2009 at 3:25 AM, liubin liu <7101...@sina.com> wrote: > > Thanks! > > It sounds pretty good. But I don't understand it exactly. Could you write > down the sample codes? > Please see the documentation here: http://sqlite.org/c3ref/funclist.html You'll have something along the

Re: [sqlite] Syntax for column names?

On Apr 28, 2009, at 11:38 AM, Igor Tandetnik wrote: > Jean-Denis Muys wrote: >> My create table statement (program-generated from a text file) below >> yields a syntax error. > > Column names should be valid identifiers (a sequence of digits, > letters > and underscores

Re: [sqlite] Syntax for column names?

Jean-Denis Muys wrote: > My create table statement (program-generated from a text file) below > yields a syntax error. Column names should be valid identifiers (a sequence of digits, letters and underscores that doesn't begin with a digit), or else enclosed in double

Re: [sqlite] How do you guys use sqlite from C++?

Just stumbled over SOCI (http://soci.sourceforge.net/ [http://soci.sourceforge.net/]) in my search for an easy to use C++ interface to relational DBs. Scales from simple scalar queries to OR mapping and STL/Boost integration. Supports SQLite as backend. Haven't tested it yet, but the concept

Re: [sqlite] Syntax for column names?

On Tue, Apr 28, 2009 at 10:03 AM, Jean-Denis Muys wrote: > Hello, > > My create table statement (program-generated from a text file) below yields > a syntax error. > > I went to SQL syntax diagrams, and as far as I could see, the "table-name" > box is not detailed in its own

[sqlite] Syntax for column names?

Hello, My create table statement (program-generated from a text file) below yields a syntax error. I went to SQL syntax diagrams, and as far as I could see, the "table-name" box is not detailed in its own diagram. I suspect SQLite doesn't like column names with two periods. It this it? Here is

[sqlite] passive DNS monitoring

This article http://isc.sans.org/diary.html?storyid=6271 mentions a presentation on passive DNS monitoring that will be given at http://www.sans.org/sansfire09/night.php in Baltimore. What do you think? Steve ___ sqlite-users mailing list

Re: [sqlite] Using SQLite3 on On-Time RTOS ...

.. or you can pay for a support ? On Mon, Apr 27, 2009 at 3:31 PM, Virgilio Alexandre Fornazin < virgilioforna...@gmail.com> wrote: > Maybe RTOS kernel does not implement Wide-Char functions... > > Windows VFS must guard them with a SQLITE_WINDOWS_NO_UNICODE > macro or something like that at

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

Thanks! It sounds pretty good. But I don't understand it exactly. Could you write down the sample codes? Matthew L. Creech wrote: > > On Mon, Apr 27, 2009 at 10:25 PM, liubin liu <7101...@sina.com> wrote: >> >> thanks >> >> I'm not sure of the real reason. >> It's true that the speed of