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
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
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
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
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
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()
>
>
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
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.
>
> -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
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:
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
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:
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?
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
14 matches
Mail list logo