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 http://sqlite.org:8080/cgi-bin/mailm

[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. Maj

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 transla

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 serv

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 b

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] 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 Boric 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 SQLite code (

[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, ...>(SELE

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 th

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 > 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 fields will have a R