Re: [sqlite] SQLite3 Pros / Cons

2017-02-04 Thread Random Coder
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

Re: [sqlite] SQLite3 Pros / Cons

2017-02-04 Thread Joe Mistachkin
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

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

2017-02-04 Thread Kim Gräsman
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

[sqlite] SQL Optimisation

2017-02-04 Thread Nigel Verity
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

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

2017-02-04 Thread Rengui Xie
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

Re: [sqlite] Retrieve INTEGER PRIMARY KEY

2017-02-04 Thread 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? On Fri, Feb 3, 2017 at 8:40 AM, Chris Locke wrote: > Last_insert_rowid() > >

[sqlite] New pre-release snapshot with performance enhancements

2017-02-04 Thread Richard Hipp
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

Re: [sqlite] Simple web query tool

2017-02-04 Thread Cecil Westerhof
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. >

Re: [sqlite] SQLite3 Pros / Cons

2017-02-04 Thread Drago, William @ CSG - NARDA-MITEQ
> -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

Re: [sqlite] Retrieve INTEGER PRIMARY KEY

2017-02-04 Thread Wolfgang Enzinger
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:

Re: [sqlite] SQL Optimisation

2017-02-04 Thread Simon Slavin
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

Re: [sqlite] SQLite3 Pros / Cons

2017-02-04 Thread Simon Slavin
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:

[sqlite] SQLite3 Pros / Cons

2017-02-04 Thread Clyde Eisenbeis
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

2017-02-04 Thread Clemens Ladisch
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