Re: [sqlite] Simple web query tool

2017-02-04 5:54 GMT+01:00 Lindsay Lawrence : > > "Sqlite just does it's thing with a minimum amount of fuss and minimal > impact on system resources, can't rave enough" > > Yes! A while back, when I first tried what I outlined it worked so well I > took it a step further. > > With nodejs async io,

[sqlite] sqlite3.def mismatch for Windows x86 and x64 dll

Hi dear sqlite developers, In the downlaod page for "Precompiled Binaries for Windows", the sqlite3.def EXPORTS for x86 and x64 dll are not the same, x64 dll have 4 more export functions: - sqlite3_data_directory - sqlite3_fts5_may_be_corrupt - sqlite3_temp_directory - sqlite3_version I assum

Re: [sqlite] Multiple sessions, page sizes and cache

Hi Richard, I got side-tracked with other work, but am coming back to this now. On Sun, Jan 15, 2017 at 5:50 PM, Richard Hipp wrote: > On 1/15/17, Kim Gräsman wrote: >> >> 1) If I configure a global SQLite heap with SQLITE_CONFIG_HEAP, won't >> I just trade malloc heap fragmentation for SQLite

Re: [sqlite] Retrieve INTEGER PRIMARY KEY

When I enter last_insert_rowid(), the compiler complains. I think last_insert_rowid() is SQLite3. Is there an equivalent for System.Data.SQLite? On Fri, Feb 3, 2017 at 8:40 AM, Chris Locke wrote: > Last_insert_rowid() > > https://www.sqlite.org/c3ref/last_insert_rowid.html > > On Fri, Feb 3,

[sqlite] New pre-release snapshot with performance enhancements

There is a new pre-release snapshot of SQLite up at https://www.sqlite.org/download.html Change notes can be seen at https://www.sqlite.org/draft/releaselog/3_17_0.html The performance enhancements in the R-Tree extension are of particular significance. If you are able to test out this pre-relea

[sqlite] SQL Optimisation

Hi I have a database which describes the various phases of a product lifecycle - one table per phase, one row per product. This is accessed by an application (developed in Gambas3) which displays the entire lifecycle of each product in a grid - left to right. Each phase also has its own mainte

Re: [sqlite] Retrieve INTEGER PRIMARY KEY

Am Sat, 4 Feb 2017 09:04:58 -0600 schrieb Clyde Eisenbeis: > When I enter last_insert_rowid(), the compiler complains. I think > last_insert_rowid() is SQLite3. > > Is there an equivalent for System.Data.SQLite? I don't know, but you can use the SQL function of the same name: https://www.sqlite

Re: [sqlite] SQL Optimisation

On 4 Feb 2017, at 3:31pm, Nigel Verity wrote: > My question regards the SQL I've used to populate the grid. I'm no SQL guru, > so joining all the tables together in a single view using multiple nested > left joins is probably beyond my comfort level. You don’t have to nest the joins. You can

[sqlite] SQLite3 Pros / Cons

I'm new to SQLite ... started using it a few months ago. I was unaware of SQLite3 until I joined the SQLite mailing list. What are the pros / cons of SQLite3? If I switched from "using System.Data.SQLite" to SQLite3, are all of the functions in a .dll I could download and use? __

Re: [sqlite] SQLite3 Pros / Cons

On 4 Feb 2017, at 7:57pm, Clyde Eisenbeis wrote: > I'm new to SQLite ... started using it a few months ago. I was > unaware of SQLite3 until I joined the SQLite mailing list. > > What are the pros / cons of SQLite3? You might find this useful: Pay special

Re: [sqlite] SQLite3 Pros / Cons

Clyde Eisenbeis wrote: > What are the pros / cons of SQLite3? http://www.sqlite.org/whentouse.html > If I switched from "using System.Data.SQLite" to SQLite3, are all of > the functions in a .dll I could download and use? http://www.sqlite.org/howtocompile.html http://www.sqlite.org/download.htm

Re: [sqlite] SQLite3 Pros / Cons

> -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On > Behalf Of Clyde Eisenbeis > Sent: Saturday, February 04, 2017 2:58 PM > To: SQLite mailing list > Subject: [sqlite] SQLite3 Pros / Cons > > I'm new to SQLite ... started using it a few mont

Re: [sqlite] SQLite3 Pros / Cons

On Feb 4, 2017, at 12:47 PM, Drago, William @ CSG - NARDA-MITEQ wrote: >> -Original Message- >> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On >> Behalf Of Clyde Eisenbeis >> Sent: Saturday, February 04, 2017 2:58 PM >> To: SQLite mailing list >> Subject: [s

Re: [sqlite] SQLite3 Pros / Cons

Random Coder wrote: > > And in case it's not obvious: System.Data.Sqlite _is_ sqlite3 > To clarify and expand upon the above reply: System.Data.SQLite is an ADO.NET based managed wrapper around the SQLite. It includes the SQLite core library, compiled with a few extra options and loadable exte