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

2009-04-28 Thread liubin liu
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 inserting with

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

2009-04-28 Thread Sylvain Pointeau
.. 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 compile

[sqlite] passive DNS monitoring

2009-04-28 Thread Steve Friedman
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

[sqlite] Syntax for column names?

2009-04-28 Thread Jean-Denis Muys
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

Re: [sqlite] Syntax for column names?

2009-04-28 Thread P Kishor
On Tue, Apr 28, 2009 at 10:03 AM, Jean-Denis Muys jdm...@kleegroup.com 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 diagram.

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

2009-04-28 Thread Harald Nehring
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?

2009-04-28 Thread Igor Tandetnik
Jean-Denis Muys jdm...@kleegroup.com 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 quotes,

Re: [sqlite] Syntax for column names?

2009-04-28 Thread D. Richard Hipp
On Apr 28, 2009, at 11:38 AM, Igor Tandetnik wrote: Jean-Denis Muys jdm...@kleegroup.com 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

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

2009-04-28 Thread Matthew L. Creech
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 lines of

[sqlite] Merging two databases

2009-04-28 Thread Kristoffer Danielsson
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

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

2009-04-28 Thread stephen liu
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

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

2009-04-28 Thread Roger Binns
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 you

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

2009-04-28 Thread Virgilio Alexandre Fornazin
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

2009-04-28 Thread stephen liu
The mailing list strips out attachments. Please download from: http://spserver.googlecode.com/files/spmemvfs.tar.gz 2009/4/29 Virgilio Alexandre Fornazin virgilioforna...@gmail.com Where we can get the code ? http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2009-04-28 Thread stephen liu
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

2009-04-28 Thread stephen liu
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 stephen@gmail.com I want to save multipile sqlite database in one file. The backup