Re: [sqlite] TCL loadable extensions

В сообщении от Thursday 10 July 2008 20:15:06 Lauri Ojansivu написал(а): > If you mean making extensions with C, look at the wiki.tcl.tk : > http://wiki.tcl.tk/_search?_charset_=UTF-8=extension > > If you mean additional commands or fuctions for SQLite with Tcl, look > at TkSQLite: >

Re: [sqlite] Periodical dump of in-memory database into a disk file

You can try to help your issue by running "PRAGMA synchronous = OFF;" after you open your connection. Cheers, Shawn Wilsher Mozilla Developer On Thu, Jul 10, 2008 at 3:04 PM, X Wang <[EMAIL PROTECTED]> wrote: > Hi, I have a sqlite in-memory databse that I want to periodically dump to a > disk

[sqlite] Periodical dump of in-memory database into a disk file

Hi, I have a sqlite in-memory databse that I want to periodically dump to a disk file (so I can look into its contents at runtime). Currently I "ATTACH" an extern file. Periodically I export everything from in-memory databse into the attached extern file and do a final COMMIT. However, this

Re: [sqlite] In-memory database (:memory:) shared between mutlipe threads in same process?

[EMAIL PROTECTED] wrote: > if( (flags BTREE_PRIVATE)==0 //FIXME-XXX originally this is > isMemdb==0 isMemdb==1 > (db-flags SQLITE_Vtab)==0 > zFilename zFilename[0]) // FIXME-XXX > originally this is strcmp(zFulPathname, )if( > 0==strcmp(,

Re: [sqlite] TCL loadable extensions

If you mean making extensions with C, look at the wiki.tcl.tk : http://wiki.tcl.tk/_search?_charset_=UTF-8=extension If you mean additional commands or fuctions for SQLite with Tcl, look at TkSQLite: http://reddog.s35.xrea.com/wiki/TkSQLite.html - Lauri 2008/7/10 Alexey Pechnikov <[EMAIL

Re: [sqlite] code formatting in list messages

I think it's a problem with [EMAIL PROTECTED]'s e-mail client. All the messages from him have this problem and it looks like only messages from him have this problem. I see other messages in the list with C code and no escaping. Looking at the raw message I received via the sqlite mailing list

[sqlite] code formatting in list messages

[EMAIL PROTECTED] wrote: > > actually after a quick and dirty hack in btree.cs sqlite3BtreeOpen() > things _seem_ to work correctly. Of course this is not in any way how it > should be done, but I didnt see a quick way to give in-memory databases > a name so that can be used in the search for

Re: [sqlite] Fw: SQL error: database is locked

On Jul 10, 2008, at 9:28 AM, Shain Lee wrote: > Don't we have a solution for following problem ? > > > > > - Forwarded Message > From: Shain Lee <[EMAIL PROTECTED]> > To: sqlite-users@sqlite.org > Sent: Thursday, 10 July, 2008 10:18:07 AM > Subject: SQL error: database is locked > > >

[sqlite] Fw: SQL error: database is locked

Don't we have a solution for following problem ? - Forwarded Message From: Shain Lee <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Thursday, 10 July, 2008 10:18:07 AM Subject: SQL error: database is locked Hi I am using sqlite in Fedora 9. Database created and done every

Re: [sqlite] Aliasing and columns names

On Jul 10, 2008, at 7:57 AM, Evgeni Alesinskyy wrote: > Hi all, > > I develop application in C# that has to run with MySQL and SQLite. > At some point I need to join 2 tables and bind them resp. dataset > containing the union to ListBox. > > To do this I use aliasing for table names. My

[sqlite] Aliasing and columns names

Hi all, I develop application in C# that has to run with MySQL and SQLite. At some point I need to join 2 tables and bind them resp. dataset containing the union to ListBox. To do this I use aliasing for table names. My SQL-statement looks like this: SELECT distinct(m.name), wp.MaterialSN from

[sqlite] TCL loadable extensions

Hello! How can I make tcl lodable extensions? It's possibly on pythone and how about other languages? Best regards, Alexey. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] In-memory database (:memory:) shared between mutlipe threads in same process?

hi, actually after a quick and dirty hack in btree.cs sqlite3BtreeOpen() things _seem_ to work correctly. Of course this is not in any way how it should be done, but I didnt see a quick way to give in-memory databases a name so that can be used in the search for existing in-memory databases.

[sqlite] Question: In-memory database (:memory:) shared between mutlipe threads in same process?

hi, I did some tests with the in-memory database and didnt find any way to use the in-memory database from multiple db handles in the same process. Having this capability would enable a multithreaded application to have e.g. multiple read transactions (each with its own db handle) to run in

[sqlite] multithreaded app and reload from disk for second db handle?

hi, Just to let you know. I did some more tests, skimmed through the source code. Here a quick description of how it works: (1) If shared cache is disabled, each call to sqlite3_open() will result in a db handle with its own btree and page cache. If the page cache is not shared, each db