[sqlite] page_size: bug with PRAGMA or documentation?

Hey guys, The docs for PRAGMA page_size say that it is effective if issued "prior to the first CREATE statement". So imagine my surprise when I found page_size to be ineffective without ever issuing a CREATE statement! The sequence goes like so: $ rm /tmp/lol.db; sqlite3 /tmp/lol.db SQLite

Re: [sqlite] Convert mysql to sqlite

What OS are you using? There is a freeware utility here for Windows: http://sqlite2009pro.azurewebsites.net/ Thanks, Chris On Sat, Sep 10, 2016 at 10:24 PM, Scott Doctor wrote: > I have a database with a few tables and about 140MB of data in it that > exists as a MySQL

Re: [sqlite] page_size: bug with PRAGMA or documentation?

On 9/12/16, Rowan Worth wrote: > The docs for PRAGMA page_size say that it is effective if issued "prior to > the first CREATE statement". Fixed at https://www.sqlite.org/draft/pragma.html#pragma_page_size This will be pushed to the main website at the next release. -- D.

Re: [sqlite] page_size: bug with PRAGMA or documentation?

I guess that selecting from sqlite_master issues an implicit create, and querying/updateing something from the file header (i.e. several PRAGMAs) would also imply writing the first page of the file (with the current setting of page_size) too. -Ursprüngliche Nachricht- Von: sqlite-users

Re: [sqlite] Does sqlite3 have variables like Oracle?

On Sun, Sep 11, 2016 at 11:48 PM, mikeegg1 wrote: > I think Oracle (a long distant memory) has variables like @variable or > @@variable. Not really. Oracle SQL doesn't have variables per se. But APIs to interact with Oracle SQL (OCI, JDBC, ODBC, etc...) can *bind* and

Re: [sqlite] Does sqlite3 have variables like Oracle?

Sqlite doesn't have variable.  While last row id is available other ways, a trick to emulate a variable is to create a temp table with one field. You put the value in to the that field. You can then cross join with the rest of your table as need be, or do a sub-select to value a SET command.

Re: [sqlite] Result code 5 from sqlite3_prepare_v2() in WAL mode?

On 9/12/16, Eric Sink wrote: > OK, this seems like a simple thing, but I'm stuck and looking for > inspiration or clues. > > How can sqlite3_prepare_v2() return SQLITE_BUSY for a simple SELECT > statement when in WAL mode? > > Immediately prior, a sqlite3_exec("BEGIN

[sqlite] not sure

Hello friend, I'm not sure whether I should tell you that, please read it yourself See you around, ronny.dierckx ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] Result code 5 from sqlite3_prepare_v2() in WAL mode?

OK, this seems like a simple thing, but I'm stuck and looking for inspiration or clues. How can sqlite3_prepare_v2() return SQLITE_BUSY for a simple SELECT statement when in WAL mode? Immediately prior, a sqlite3_exec("BEGIN TRANSACTION") succeeded. The failing call is just

Re: [sqlite] Convert MySQL to sqlite

Funny, I was just doing the same thing. I have hacked together some Python code to convert the MySQL exports from the Workbench into SQLite format for import. It's not pretty, and is a work in progress, but you are welcome to it. Uncheck everything from the advanced tab and select Dump

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

I knew I had done this before. I don't know if this is still relevant. Tested in FF38. I'm old skool, don't use CSS all that much, and I don't even know if this is a CSS2 or 3 thing. I typically do back end code, I'm no where near a UI designer or artist. When I do have to make a web UI, I

Re: [sqlite] Does sqlite3 have variables like Oracle?

Duh. What a brilliant idea. Wish I had thought of it. :) Thanks. Mike > On Sep 12, 2016, at 08:02, David Bicking wrote: > > Sqlite doesn't have variable. While last row id is available other ways, a > trick to emulate a variable is to create a temp table with one field.

Re: [sqlite] Does sqlite3 have variables like Oracle?

Thanks. I didn't think of "CTEs" either. I need to read up on them. Mike > On Sep 12, 2016, at 08:49, Dominique Devienne wrote: > >> On Sun, Sep 11, 2016 at 11:48 PM, mikeegg1 wrote: >> >> I think Oracle (a long distant memory) has variables like