[sqlite] Invalid Pointer error when opening database

2009-01-13 Thread Alois Komenda
Hello, I get an Invalid Pointer error when opening my database with sqlite3_open_v2(): *** glibc detected *** bin/freeswitch: free(): invalid pointer: 0x08108190 *** === Backtrace: = /lib/tls/i686/cmov/libc.so.6[0xb7bc9d65] /lib/tls/i686/cmov/libc.so.6(cfree+0x90)[0xb7bcd800]

Re: [sqlite] SQLite version 3.6.8

2009-01-13 Thread P Kishor
On Mon, Jan 12, 2009 at 10:41 PM, Jim Dodgen wrote: > I am having better luck with the amalgamation that has been created by > Audrey Tang. > My production is still on 3.4 and testing on 3.6 with the amalgamation has > been promising DBD::SQLite::Amalgamation is "nothing but a

Re: [sqlite] SQLite version 3.6.8

2009-01-13 Thread Ribeiro, Glauber
Yes, the amalgamation driver is the better way to do this. It has been working for me, for several SQLite updates. g -Original Message- From: Jim Dodgen [mailto:j...@dodgen.us] Sent: Monday, January 12, 2009 10:42 PM To: General Discussion of SQLite Database Subject: Re: [sqlite]

Re: [sqlite] Upgrade sqlite 3.3.4 to sqlite 3.6.7

2009-01-13 Thread Griggs, Donald
Subject: [sqlite] Upgrade sqlite 3.3.4 to sqlite 3.6.7 Hi, I consider upgrade sqlite 3.3.4 to sqlite 3.6.7. So, I wonder there is any change (or problem) of file format. === Upgrading from version 2 to version 3 (understandably) required a dump and restore, but

[sqlite] Assigning REGEX from javascript

2009-01-13 Thread Noah Hart
BACKGROUND: Firefox includes SQLite version 3.5.9, it also allows extensions, which are written in javascript and can call the embedded SQLite engine. As expected, executing the following SQL statement 'SELECT "TEXT" REGEX "T*";' gives an error, since there is no REGEX function included.

[sqlite] A question about dates

2009-01-13 Thread Carlos Suarez
Hi, I need to know how I can split a date field with a slash in -, being straight I need to convert the the date format /mm/dd to -mm-dd or something alike because flex builder date format is with slash but sqlite operation results are return with (-) in example:

Re: [sqlite] A question about dates

2009-01-13 Thread Igor Tandetnik
Carlos Suarez wrote: > I need to know how I can split a date field with a slash in -, being > straight I need to convert the the date format > /mm/dd to -mm-dd replace('/mm/dd', '/', '-') http://sqlite.org/lang_corefunc.html Igor Tandetnik

Re: [sqlite] Upgrade sqlite 3.3.4 to sqlite 3.6.7

2009-01-13 Thread Edward J. Yoon
Thanks for your helpful information! On Wed, Jan 14, 2009 at 12:48 AM, Griggs, Donald wrote: > Subject: [sqlite] Upgrade sqlite 3.3.4 to sqlite 3.6.7 > > Hi, > > I consider upgrade sqlite 3.3.4 to sqlite 3.6.7. So, I wonder there is > any change (or problem) of file

[sqlite] SQLite Encryption Extension (SEE) memory usage and performance

2009-01-13 Thread Ulric Auger
I started to use SEE and I was surprise to notice that the file size of my encrypted database is the same has the un-encrypted database, how come? It seems too good to be true, I was sure that the encrypted database would have been bigger. Also, I timed some query (insert and select) and

Re: [sqlite] SQLite Encryption Extension (SEE) memory usage and performance

2009-01-13 Thread D. Richard Hipp
On Jan 13, 2009, at 9:29 PM, Ulric Auger wrote: > I started to use SEE and I was surprise to notice that the file size > of my > encrypted database is the same has the un-encrypted database, how > come? > > It seems too good to be true, I was sure that the encrypted database > would > have

[sqlite] Opportunity for SQLite Lectures in Prague and/or Wroclaw

2009-01-13 Thread D. Richard Hipp
I will be traveling in Prague, Czech Republic and Wroclaw, Poland in early March and would welcome the opportunity to speak about SQLite (or any other topic) to university classes, user groups, or over coffee with a handful of local SQLite users. If you are an SQLite user who lives in or

[sqlite] request to become co-maintainer of DBD::SQLite

2009-01-13 Thread Darren Duncan
Hello Matt Sergeant, I would like to request your permission or blessing to become an official co-maintainer of the DBD::SQLite module, which is the defacto standard binding for SQLite to Perl. (Also CC'd are some other concerned parties as FYI; my apologies if I've written too many people.

[sqlite] SQLite version 3.6.9

2009-01-13 Thread D. Richard Hipp
Internal stress testing revealed an obscure bug in the SQLite query optimizer of version 3.6.8. Since that release has only been out for two days, and since the fix is simple, we thought it best to go ahead and do another release that patches the problem. SQLite version 3.6.9 is now