Re: [sqlite] New

On Fri, 28 Feb 2014 18:54:34 -0600, Ashleigh wrote: > I'm trying to view files from my iphone backup I'm not > sure which program it is it says sqlite it is a black box > like the windows command That would be the sqlite command line tool, sqlite3.exe . If you start a

Re: [sqlite] New

On 1 Mar 2014, at 12:54am, Ashleigh wrote: > I'm trying to view files from my iphone backup I'm not sure which program it > is it says sqlite it is a black box like the windows command Sorry, your question is about the program you're using and not about SQLite.

Re: [sqlite] Transactions

On 2/28/2014 5:48 PM, L. Wood wrote: Is this legal? 1) Create "INSERT" prepared statement with parameters. 2) Create a second non-parameter "BEGIN TRANSACTION" prepared statement, execute it with _step(), and finalize it. 3) Attach values to the parameters of the first "INSERT" prepared

Re: [sqlite] New

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 28/02/14 16:54, Ashleigh wrote: > I'm trying to view files from my iphone backup I'm not sure which > program it is it says sqlite it is a black box like the windows command > If any one knows a better way to read and understand the files I would >

Re: [sqlite] New

I'm trying to view files from my iphone backup I'm not sure which program it is it says sqlite it is a black box like the windows command If any one knows a better way to read and understand the files I would greatly appreciate it I think the file ext. is a plist. Live, love & laugh. On Feb

[sqlite] Transactions

Is this legal? 1) Create "INSERT" prepared statement with parameters. 2) Create a second non-parameter "BEGIN TRANSACTION" prepared statement, execute it with _step(), and finalize it. 3) Attach values to the parameters of the first "INSERT" prepared statement, _step() it, _reset() it. Repeat

Re: [sqlite] Why SQLITE_FLOAT instead of SQLITE_REAL?

On Fri, Feb 28, 2014 at 4:36 PM, L. Wood wrote: > SQLite has the REAL data type: > > https://www.sqlite.org/datatype3.html > > Then why do we have SQLITE_FLOAT instead of SQLITE_REAL? All the other > data types (INTEGER, BLOB, TEXT, NULL) match with the SQLITE_ constants. > >

[sqlite] Why SQLITE_FLOAT instead of SQLITE_REAL?

SQLite has the REAL data type: https://www.sqlite.org/datatype3.html Then why do we have SQLITE_FLOAT instead of SQLITE_REAL? All the other data types (INTEGER, BLOB, TEXT, NULL) match with the SQLITE_ constants. Is this just a historical quirk that stuck, or something else?

[sqlite] Virtual Table "Functions"

Can someone tell me how the statement below works? > From Eleytherios Stamatogiannakis : > create table newtable as select * from READCOMPRESSEDFILE('ctable.rc'); I'm using virtual tables extensively in my application, to expose runtime C++ objects, and I'm declaring them as shown in

Re: [sqlite] Recommended way to delete rows

On 28 Feb 2014, at 5:18pm, L. Wood wrote: > If I do this, would you expect _step() for the "BEGIN TRANSACTION" query and > _step() for each "DELETE" query to be very fast, but the _step() for the "END > TRANSACTION" query to take most (99%) of the time? > > Would you expect

Re: [sqlite] Recommended way to delete rows

Yes. On Fri, Feb 28, 2014 at 12:18 PM, L. Wood wrote: > > I expect #2 to work best. Make sure to enclose the whole thing in an > > explicit transaction (or at least, run large batches within explicit > > transactions; one implicit transaction per deleted row will be slow as >

Re: [sqlite] Recommended way to delete rows

> I expect #2 to work best. Make sure to enclose the whole thing in an > explicit transaction (or at least, run large batches within explicit > transactions; one implicit transaction per deleted row will be slow as > molasses). If I do this, would you expect _step() for the "BEGIN TRANSACTION"

Re: [sqlite] New

On 2014/02/28 17:13, Ashleigh wrote: Nothing will load in SQLite just the command box Not sure if this is a prophecy, a problem, a proposition or a premonition, but I am pretty confident that it isn't an SQLite process problem. Might you give us some more information please? What command

[sqlite] Virtual table API performance

Hello, First of all, i would like to say that, IMHO, SQLite's overall design and code quality is top notch. Having said that, SQLite's virtual table API, while beautifully designed, it is not very efficient. We have been hitting our heads for the last few years, on the virtual table API, to

Re: [sqlite] Recommended way to delete rows

On 2/28/2014 9:59 AM, L. Wood wrote: * Prepare query containing single ID with _prepare(). Execute it with _step(). Repeat for each ID. * Call _prepare() with a query with single parameter for the ID. _bind(), _step(), and _reset() - repeat for each ID. * Call _prepare() with a query

Re: [sqlite] New

Ashleigh wrote: > Nothing will load in SQLite just the command box I guess you clicked on "sqlite3.exe"? What exactly are you trying to do? Regards, Clemens ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] System.Data.SQLite fails to load

Thanks for the reply. Everything seems to be working fine, the only thing is I don't see SQLite in VEE's drop down box for "Available .NET Assemblies." I'm not sure where that list comes from, and I thought that even though SQLite is working, that I might not have installed it properly with

Re: [sqlite] Recommended way to delete rows

Stephan Beal wrote: > On Fri, Feb 28, 2014 at 3:59 PM, L. Wood wrote: >> I can think of three ways: >> * Call _prepare() with a query with single parameter for the ID. >> _bind(), _step(), and _reset() - repeat for each ID. This is the obvious method to use. >> Are there

Re: [sqlite] System.Data.SQLite fails to load

Drago, William @ MWG - NARDAEAST wrote: > > I solved this problem by deploying the "System.Data.SQLite.dll" mixed-mode assembly to > the GAC. I know this is not recommended, but it's the only thing that works. > It should be OK, the mixed-mode assembly is designed for these types of cases, when

Re: [sqlite] Recommended way to delete rows

On Fri, Feb 28, 2014 at 3:59 PM, L. Wood wrote: > I can think of three ways: > Which way do you recommend? Are there other ways? > i don't know that this would be better, but it's a different way: collect the list into a temp table with one field (the to-delete id), then do a

[sqlite] New

Nothing will load in SQLite just the command box Live, love & laugh. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite fails to load

I solved this problem by deploying the "System.Data.SQLite.dll" mixed-mode assembly to the GAC. I know this is not recommended, but it's the only thing that works. My question now is, I used gacutil.exe instead of the installer that comes with SQLite. Was that a mistake? Should I have used the

[sqlite] Recommended way to delete rows

If I already have a collection of row IDs of rows I wish to delete from a table, what is a recommended/fast way to delete them from the table? The collection is just a set/array of integers, not necessarily contiguous. I can think of three ways: * Prepare query containing single ID with

Re: [sqlite] Error: datatype mismatch

On Fri, Feb 28, 2014 at 8:00 AM, Dominique Devienne wrote: > Ran into this [datatype mismatch] error, which surprised me since I > thought SQLite's > dynamic typing allowed any value type to be stored in any column. > The exception to that rule is an INTEGER PRIMARY KEY

Re: [sqlite] Why does type affinity declared on a foreign key column affect join speed?

On Fri, Feb 28, 2014 at 6:38 AM, Bruce Sutherland wrote: > We are tracking manufactured components with an alphanumeric serial number, > which gives us a natural key. Naturally we set type affinity TEXT on the key > column. There are many tables linked

[sqlite] Error: datatype mismatch

Ran into this error, which surprised me since I thought SQLite's dynamic typing allowed any value type to be stored in any column. Either the PK or the FK seem to have some influence (with pragma foreign_keys on or off), which I didn't expect, since the entered FK value does match the parent row's

[sqlite] Why does type affinity declared on a foreign key column affect join speed?

We are tracking manufactured components with an alphanumeric serial number, which gives us a natural key. Naturally we set type affinity TEXT on the key column. There are many tables linked through foreign key relationships on this serial number. On one table, the type affinity of the serial

Re: [sqlite] 'Select' queries via pdo_sqlite are slow

On 28 Feb 2014, at 9:48am, pihu...@free.fr wrote: > I did a fourth one with a '+' sign before the "NomJob = 'NSAVBASE'" clause > :[snip] > This one is way quicker (0.055 second instead of 2.235 seconds in my latest > test). That is a good experiment. Unfortunately it depends on you knowing

Re: [sqlite] 'Select' queries via pdo_sqlite are slow

Thanks Simon for your reply. An ANALYZE; in the SQLite shell tool did nothing performance-wise. Here are the EXPLAIN QUERY PLAN results : sqlite> EXPLAIN QUERY PLAN select DateMonteeAuPlan, Debut, Fin, Statut from ReportJobs where NomJob = 'NSAVBASE' and NomChaine like 'DCLC257%' limit 20;