Re: [sqlite] Best JDBC driver for SQLite?

2011-04-27 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/26/2011 10:56 PM, Paul Linehan wrote: two days ago - and haven't received a single reply. Is this not the correct forum for such a question? Can anybody even see this post? Yes and yes. http://www.catb.org/~esr/faqs/smart-questions.html

Re: [sqlite] Speeding up index insertion

2011-04-27 Thread Alexey Pechnikov
RAM drive or SSD can help you... -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Test Foreign Key Column

2011-04-27 Thread M.Ozeau
Thx a lot Jonathan, Pragma seems to be just the thing i was looking for ! Regards, MoZo 2011/4/26 Jonathan Allin jonat...@jonathanallin.com I had to use the pragmas: # foreign_key_list # foreign_keys But also the sqlite_master table includes the command used to create each table. Foreign

Re: [sqlite] Best JDBC driver for SQLite?

2011-04-27 Thread Paul Linehan
Hi, Thanks for your input. Yes and yes.  http://www.catb.org/~esr/faqs/smart-questions.html I followed the links on this page - http://sqlite.org/support.html and found this http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/ It did not have a search function - I assumed that

[sqlite] Understanding a non trivial query plan

2011-04-27 Thread Sam Carleton
I am trying to track down an issue that I MIGHT have with the following query. The explain query is a bit complex and I cannot tell if it is OK or if there are issues. Here it is: sqlite EXPLAIN QUERY PLAN ... SELECT DISTINCT f1.FolderId, f1.ImageId, ...(SELECT

Re: [sqlite] Segmentation fault when using triggers inside Freeswitch

2011-04-27 Thread Neven Boric
Richard Hipp escribió: On Tue, Apr 26, 2011 at 3:18 PM, Neven Boricnbo...@yx.cl wrote: Hi I'm using Freeswitch, which has an old version of SQLite embedded in its source code. I'm getting a segmentation fault whenever I do something that uses triggers. The segmentation fault occurs inside

Re: [sqlite] Best JDBC driver for SQLite?

2011-04-27 Thread Simon Slavin
On 27 Apr 2011, at 12:02pm, Paul Linehan wrote: Gigs - what I'm interested in is sharding and using SQLite instances as shards in a larger ensemble. Well now you've told us what you want out of it, we can comment usefully. You can handle your shards yourself, and you can implement sharding

Re: [sqlite] Best JDBC driver for SQLite?

2011-04-27 Thread Paul Linehan
Hi, Thanks for your reply. Gigs - what I'm interested in is sharding and using SQLite instances as shards in a larger ensemble. Well now you've told us what you want out of it, we can comment usefully. Oh, goody! You can handle your shards yourself, and you can implement sharding by

Re: [sqlite] Best JDBC driver for SQLite?

2011-04-27 Thread Simon Slavin
On 27 Apr 2011, at 1:24pm, Paul Linehan wrote: I know this - what I want to do is implement a sharding scheme myself with a queueing system and run it as a service on the different machines. These services will then communicate the result of any query back to the master server - web server -

Re: [sqlite] Best JDBC driver for SQLite?

2011-04-27 Thread Mike Hartshorn
Apologies for top-posting... I have used Xerial successfully for a number of small-medium sized projects http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC Contains precompiled libraries for win, linux and mac that are loaded automatically by JNI. It may still contain a pure java nestedvm

[sqlite] [ANN] ODB C++ ORM 1.4.0 released, adds support for Qt, inheritance

2011-04-27 Thread Boris Kolpackov
Hi, I am pleased to announce the release of ODB 1.4.0. ODB is an open-source object-relational mapping (ORM) system for C++. It allows you to persist C++ objects to a relational database without having to deal with tables, columns, or SQL and without manually writing any of the mapping code.

Re: [sqlite] Best JDBC driver for SQLite?

2011-04-27 Thread Jim Morris
I've just started using Xerial also for a small project and have not had any problems so far. I haven't used any other JDBC wrappers so have no comparison info. ___ sqlite-users mailing list sqlite-users@sqlite.org