[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. -- Best Regards, Edward J. Yoon @ NHN, corp. edwardy...@apache.org http://blog.udanax.org ___ sqlite-users mailing list

[sqlite] Cross compilation

Hello all How can i cross compile tcl and sqlite for arm and ppc Tahnks in advance Chandru K ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.6.8

I have contacted both flavors' authors about the update, even offering to co-maintain the binding experimentally if necessary, so we'll see what happens. Part of the outstanding issue is that according to some users I trust DBD::SQLite 1.14 introduced significant bugs that weren't in 1.13,

Re: [sqlite] SQLite version 3.6.8

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 On Mon, Jan 12, 2009 at 8:14 PM, Darren Duncan wrote: > Jim Dodgen wrote: > > Please post back

Re: [sqlite] SQLite version 3.6.8

Jim Dodgen wrote: > Please post back with success/failure of the Perl bindings. Yes, about that ... it seems the bindings have gotten stale and have some outstanding issues ... I'm hoping that someone will step up and maintain them ... I currently lack the C experience to do it easily myself if

Re: [sqlite] Is this legal SQL?

"Mike McGonagle" wrote in message news:370dda580901121949u3d2bf52ai87bfd7102cd7...@mail.gmail.com > Thanks for the advice, everyone was a help in this... > > On Mon, Jan 12, 2009 at 6:41 PM, Igor Tandetnik > Why do you want to > create a bunch of identical tables in the first >>

Re: [sqlite] Is this legal SQL?

Thanks for the advice, everyone was a help in this... On Mon, Jan 12, 2009 at 6:41 PM, Igor Tandetnik > Why do you want to create a bunch of identical tables in the first > place? What are you trying to achieve? I am working with Multimedia stuff, and each table, while holding the same fields,

Re: [sqlite] SQLite version 3.6.8

Please post back with success/failure of the Perl bindings. Thanks Jim On Mon, Jan 12, 2009 at 3:32 PM, Darren Duncan wrote: > D. Richard Hipp wrote: > > SQLite version 3.6.8 adds support for nested transactions > > This is *excellent* news! > > Thank you so much for

Re: [sqlite] Is this legal SQL?

Mike McGonagle wrote: > I want to be able to create some tables dynamically (same structure, > different name), and I thought this might work... > > CREATE TABLE ?1 (x double, y double); Parameters can only appear where a literal could legally appear. Why do you want to create

Re: [sqlite] Is this legal SQL?

You should use sprintf(buf, "CREATE TABLE %s(x double, y double)", tableName); then use prepare and execute using from that string. - Original Message - From: "Mike McGonagle" To: "General Discussion of SQLite Database" Sent: Tuesday,

Re: [sqlite] SQLite version 3.6.8

D. Richard Hipp wrote: > SQLite version 3.6.8 adds support for nested transactions This is *excellent* news! Thank you so much for implementing nested transactions in SQLite! As far as I was concerned, and AFAIK had argued in the past, that was the single most important piece of missing

Re: [sqlite] Is this legal SQL?

You can only bind data elemeents. If you want to chjange table names you have to recompile the SQL (think about it). Mike McGonagle wrote: > Hello all, > > I am working on connecting SQLite up to another programming language, > and had a question about how SQLite (or SQL in general) would

Re: [sqlite] Hi, a question from Colombia

Brazil, but living in the Chicago area of the USA since 1991. -Original Message- From: MikeW [mailto:mw_p...@yahoo.co.uk] Sent: Monday, January 12, 2009 6:35 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Hi, a question from Colombia Ribeiro, Glauber writes:

[sqlite] Is this legal SQL?

Hello all, I am working on connecting SQLite up to another programming language, and had a question about how SQLite (or SQL in general) would handle this... I want to be able to create some tables dynamically (same structure, different name), and I thought this might work... CREATE TABLE ?1 (x

Re: [sqlite] Number precision

On Jan 12, 2009, at 11:10 AM, vlema...@ausy.org wrote: > Hello, > > As described in SQL syntax > (http://www.sqlite.org/syntaxdiagrams.html#type-name) a column type > may be > declared like this : > int(x) > or float(x, y) > ... > > what does x and y means ? max number of digits ? max value ?

[sqlite] Number precision

Hello, As described in SQL syntax (http://www.sqlite.org/syntaxdiagrams.html#type-name) a column type may be declared like this : int(x) or float(x, y) ... what does x and y means ? max number of digits ? max value ? max bytes encoding ? ... a subsidiary question is : how to specify a precision

[sqlite] SQLite version 3.6.8

Version 3.6.8 of SQLite is now available on the website: http://www.sqlite.org/ SQLite version 3.6.8 adds support for nested transactions and improved optimization of WHERE clauses with OR-connected terms. There is also a new compile-time option that changes the way full-text search

Re: [sqlite] Testing SQLite on embedded platform with no Tcl

On Jan 12, 2009, at 10:53 AM, John Efstathiades wrote: > Hello, > > I am looking into porting the latest SQLite to an embedded platform > running > a commercial real-time operating system. I'd like to use as much of > the > existing regression test code as possible to ensure the port is >

Re: [sqlite] Testing SQLite on embedded platform with no Tcl

John Efstathiades schrieb: > Hello, > > I am looking into porting the latest SQLite to an embedded platform running > a commercial real-time operating system. I'd like to use as much of the > existing regression test code as possible to ensure the port is correct but > unfortunately the target

[sqlite] Testing SQLite on embedded platform with no Tcl

Hello, I am looking into porting the latest SQLite to an embedded platform running a commercial real-time operating system. I'd like to use as much of the existing regression test code as possible to ensure the port is correct but unfortunately the target environment does not have Tcl. The host

Re: [sqlite] week number - feature request - extend strftime for ISO week?

PooLpi writes: > > Thanks MikeW, > > Is there a way to do strftime %W with another function. > It don't seems to be possible with datetime. > > Thanks > > PooLpi The Linux 'date' command does support %G/%g/%V referring to ISO week num, which suggests an extension feature for ISO

Re: [sqlite] .dump and transactions

On Monday, 12. January 2009 13:52:47 P Kishor wrote: > > Here's a short example to reproduce the problem: > > > > sqlite3 test.db > > create table test (name varchar(16)); > > begin transaction; > > insert into test values ('test'); > > did you forget to COMMIT here? Thanks for your reply. In

Re: [sqlite] .dump and transactions

On Mon, Jan 12, 2009 at 4:30 AM, Thomas Jarosch wrote: > On Friday, 9. January 2009 10:34:32 Thomas Jarosch wrote: >> I run a small script every night via cron to backup a database >> using the ".dump" statement. SQlite version is 3.6.6.2 on Linux. >> >> Normally

Re: [sqlite] Hi, a question from Colombia

Ribeiro, Glauber writes: > > Carlos, > > If you don't mind, I'll answer through the list, because there are > people there who know much more than I do. > > > glauber > Hey, glauber, you didn't say which country you were from ! ;-) MikeW (UK)

Re: [sqlite] .dump and transactions

On Friday, 9. January 2009 10:34:32 Thomas Jarosch wrote: > I run a small script every night via cron to backup a database > using the ".dump" statement. SQlite version is 3.6.6.2 on Linux. > > Normally this script works fine and from time to time > I get a backup file that looks like this: >

Re: [sqlite] Memory loss with sqlite3_bind - issue resolved

Hi Jay, Thanks for your response and it is the cache as you say. After ~ 150 inserts memory stabilises thereafter. This equates approx to the 2000 cache pages. Thanks again. John D. > Using SQLite3 3.5.9, I am seeing a consistent rise in memory with each > > call to sqlite3_step(). >>

Re: [sqlite] Question about concurrency

On Jan 11, 2009, at 3:37 AM, Lawrence Gold wrote: > This question may sound a bit daft, but I'll ask anyway: If I use > SQLite > in the default SQLITE_CONFIG_SERIALIZED threading mode and share a > connection among threads, does that connection support multiple > simultaneous reads, or will