[sqlite] Weird FTS bugs (wrong, missing and false positive results)

2015-07-06 Thread Dan Kennedy
On 07/06/2015 07:23 PM, shuricksoft at ukr.net wrote: > > --- ? --- > ?? : "Dan Kennedy" > : 2 2015, 14:26:05 > > >> On 07/02/2015 09:24 PM, Kevin Benson wrote: >>> FTFY, you're welcome ;-) >> Now *MAYBE* someone can read it and possibly reply. >>> -- >>>

[sqlite] Unicode support in SQLite

2015-07-06 Thread Aleksey Tulinov
Hello, I'm glad to announce that nunicode SQLite extension was updated to support Unicode 8.0. This extension support the following encodings: UTF-8, UTF-16, UTF-16LE, UTF-16BE and only 230Kb in size (approximately). This extension provides the following Unicode-aware components: - upper(X) -

[sqlite] Weird FTS bugs (wrong, missing and false positive results)

2015-07-06 Thread shuricks...@ukr.net
Sorry, tried to make the reply from another message and the original text, but it failed to be placed in the thread I wanted. Sorry about that, already e-mailed to the admin. --- ? --- ?? : shuricksoft at ukr.net : 6 2015, 15:23:05 > > > ---

[sqlite] Weird FTS bugs (wrong, missing and false positive results)

2015-07-06 Thread shuricks...@ukr.net
--- ? --- ?? : "Dan Kennedy" : 2 2015, 14:26:05 > On 07/02/2015 09:24 PM, Kevin Benson wrote: >> FTFY, you're welcome ;-) > Now *MAYBE* someone can read it and possibly reply. >> >> -- >> -- >>-- >> --???-- >> K e V i N >> > > >

[sqlite] convert a PostgreSQL to sqlite

2015-07-06 Thread da...@dandymadeproductions.com
c.buhtz wrote: > Is there a way (free, open source, Ubuntu) to convert a > PostgreSQL-database with data in it to a sqlite database? Hello, 1. Download the free open source Java application MyJSQLView. http://myjsqlview.com/download.html 2. Insure the PostgreSQL JDBC driver is installed in

[sqlite] SIGSEGV rolling back in-memory DB‏‎

2015-07-06 Thread Brian Soby
Related to this bug: https://code.djangoproject.com/ticket/24080 I can reliably duplicate on Ubuntu 14.04 (package details at bottom) but I can't seem to create a stripped codebase to repro the issue. GDB stacktrace and package details are below. This only appears to happen for in-memory

[sqlite] Slow real world performance - Any suggestions please (warning long)

2015-07-06 Thread Drago, William @ CSG - NARDA-MITEQ
Keith & Simon, Excellent explanations. Thank you. -- Bill Drago Staff Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788 631-272-5947 / William.Drago at L-3COM.com > -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- > users-bounces at

[sqlite] Likelihood() in Left Join affecting results

2015-07-06 Thread Zsbán Ambrus
On Thu, Jun 18, 2015 at 4:34 PM, Richard Hipp wrote: > Thanks for the bug report. The problem is now fixed on trunk. > > On 6/18/15, Jean Chevalier wrote: >> The likelihood() function, which should help select a query plan but >> otherwise be logic-neutral, nevertheless seems to affect results

[sqlite] Slow real world performance - Any suggestions please (warning long)

2015-07-06 Thread Rob Willett
James, I didn?t say it explicitly but we did understand where the speed up came from. As you say, changing the collation was the key element in this. This speedup also meant that the a dirty, nasty, vile hack (and thats the nicest thing we can say about it and its our code) so-called

[sqlite] convert a PostgreSQL to sqlite

2015-07-06 Thread Eduardo Morras
On Sun, 5 Jul 2015 14:44:00 +0200 wrote: > Is there a way (free, open source, Ubuntu) to convert a > PostgreSQL-database with data in it to a sqlite database? Check VirtualPG virtual table extension, https://www.gaia-gis.it/fossil/virtualpg/index It permits create and fill a virtual table in

[sqlite] Weird FTS bugs (wrong, missing and false positive results)

2015-07-06 Thread Kevin Benson
On Mon, Jul 6, 2015 at 8:23 AM, wrote: > > > --- ? --- > ?? : "Dan Kennedy" > : 2 2015, 14:26:05 > > > > On 07/02/2015 09:24 PM, Kevin Benson wrote: > >> FTFY, you're welcome ;-) > > Now *MAYBE* someone can read it and possibly reply. > >> > > *SNIP* > > >

[sqlite] convert a PostgreSQL to sqlite

2015-07-06 Thread c.bu...@posteo.jp
On 2015-07-05 17:40 Jim Callahan wrote: > Are you using an PostgreSQL add-ins such as "PostGIS" or an object > relational mapper? I know nothing about GIS. I access the db with SQLAlchemy in Python3.

[sqlite] Likelihood() in Left Join affecting results

2015-07-06 Thread Richard Hipp
On 7/6/15, Zsb?n Ambrus wrote: > On Thu, Jun 18, 2015 at 4:34 PM, Richard Hipp wrote: >> Thanks for the bug report. The problem is now fixed on trunk. >> >> On 6/18/15, Jean Chevalier wrote: >>> The likelihood() function, which should help select a query plan but >>> otherwise be

[sqlite] error during bind

2015-07-06 Thread Kumar Suraj
Thanks a lot .. this helped.. On Fri, Jul 3, 2015 at 10:16 PM, Simon Slavin wrote: > > On 3 Jul 2015, at 5:16pm, Kumar Suraj wrote: > > > So whats the solution here. I am giving 4 statements because i need > insert > > to be transactional. Some other process could be inserting in the same db >