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