Re: [sqlite] 64-bit precompiled command-line shell binary for Windows 7

I haven't tested it (I only have a 32-bit system), but here you go. Just change the extension to .exe On Mon, Apr 30, 2012 at 4:28 PM, Udi Karni wrote: > Dear Sqlite development team, > > I'd like to add a vote for requesting a 64-bit precompiled command-line > shell binary

Re: [sqlite] 64-bit precompiled command-line shell binary for Windows 7

The list strips all attachments... you might want to PM it. On 30/04/2012 12:23 PM, Baruch Burstein wrote: I haven't tested it (I only have a 32-bit system), but here you go. Just change the extension to .exe On Mon, Apr 30, 2012 at 4:28 PM, Udi Karni wrote: Dear Sqlite

Re: [sqlite] SQLite 3.7.11 behavioral change from 3.7.10 with concurrency -- bug?? -- test case!

On 04/28/2012 09:36 AM, Richard Hipp wrote: On Sat, Apr 28, 2012 at 8:24 AM, Black, Michael (IS)

Re: [sqlite] SQLite 3.7.11 behavioral change from 3.7.10 with concurrency -- bug?? -- test case!

I agree (surprise!)people switch to WAL mode for concurrent read/write. I would've assumed a write rollback was non-intrusive into exisiting reads in all circumstances unless told otherwise. So some sort of cross-reference to shared cache causing potential problems under rollbacks would

[sqlite] SQLite, ACID & (f)sync();

Hi, On the web I read that SQLite is fully ACID complaint. So a query either totally fails or totally succeeds. Does that mean that I can also be totally sure that the changes are on the phsycical disk? Does SQLite e.g. do a fsync() or sync() after it executed the changes? Thanks Folkert van

Re: [sqlite] SQLite, ACID & (f)sync();

On May 1, 2012, at 4:15 PM, folkert wrote: > Does that mean that I can also be totally sure that the changes are on > the phsycical disk? Yes, to the extend that there is a physical disk. http://www.sqlite.org/transactional.html > Does SQLite e.g. do a fsync() or sync() after it > executed

Re: [sqlite] SQLite, ACID & (f)sync();

> > Does that mean that I can also be totally sure that the changes are on > > the phsycical disk? > Yes, to the extend that there is a physical disk. > http://www.sqlite.org/transactional.html Yes, ok clear. If the system underneath behaves "different" then, well, we're lost anyway. > > Does

Re: [sqlite] SQLite, ACID & (f)sync();

On 1 May 2012, at 3:30pm, folkert wrote: >>> Does that mean that I can also be totally sure that the changes are on >>> the phsycical disk? >> Yes, to the extend that there is a physical disk. >> http://www.sqlite.org/transactional.html > > Yes, ok clear. If the system

Re: [sqlite] SQLite, ACID & (f)sync();

On Tue, May 01, 2012 at 04:30:23PM +0200, folkert scratched on the wall: > I'm asking as I was looking at some application using SQLite which > executes an explicit sync() after each query it executes. I'm not a > database expert but I always thought that the whole idea behind > databases were

Re: [sqlite] User Defined Function using P/Invoke SQLite wrappers

Hi All, I have an assignment to do statistical processes in C#. I like SQLite stand-alone feature but I need to be able to do the assignment using something like SQL Server stored-procedure. I was wondering if someone could give me a simple straight forward example of creating user defined

Re: [sqlite] User Defined Function using P/Invoke SQLite wrappers

Rick Guizawa wrote: > > I was wondering if someone could give me a simple straight forward > example of creating user defined function in c# - sqlite application. > I have collected basic ( probably incomplete) P/Invoke SQLite wrapper > functions but I don't know how to include the user defined

Re: [sqlite] System.Data.SQLite and pooling problem

Hi Joe, I tried out the changes on the tkt-996d13cd87 branch and our application runs fine with pooling on, at least for the test case that I was using to reproduce it within our app. Thanks! On 30 April 2012 15:28, Joe Mistachkin wrote: > > Alexander Spence wrote: > > >

Re: [sqlite] System.Data.SQLite and pooling problem

Greg Carter wrote: > > I tried out the changes on the tkt-996d13cd87 branch and our application > runs fine with pooling on, at least for the test case that I was using to > reproduce it within our app. > Thanks! > Do you have a test case you would be willing to share? -- Joe Mistachkin

[sqlite] Fwd: Expression syntax

Thanks you Jay and other for the clarification. The fact that the table can only have one column is what was missing from my understanding of how this works. Jay, I think you just persuaded me to buy your book! Pete On Tue, May 1, 2012 at 9:00 AM, wrote: >

Re: [sqlite] System.Data.SQLite and pooling problem

I do not yet have one that reproduces the problem outside of our application. I will try and see if I can come up with one. On 1 May 2012 12:48, Joe Mistachkin wrote: > > Greg Carter wrote: > > > > I tried out the changes on the tkt-996d13cd87 branch and our application

Re: [sqlite] Using a select with 'where'

> >> delete from addressbook where absid=(select personnick from grouplinks > where > >> groupnick='27') > >> > >> The 'select personnick ...' can return zero, one, or many results, and > I'd > >> like to have the 'delete from ...' delete zero, one, or many rows from > the > >> addressbook table.

Re: [sqlite] Using a select with 'where'

You most certainly can do what you want...but your example makes no sense to me. Sound to me like "personnick" is text and absid is numeric -- they'll never match. You can do something like: delete from addressbook where absid in (select otherid from grouplinks where groupnick='27');

Re: [sqlite] Concurrency

On Mon, Apr 30, 2012 at 8:35 PM, Sean Cui wrote: > > Thanks very much for the replies. > > It'd be nice to have the online documentation of WAL mode updated to include > the clarification of readers' visibility on uncommitted data. > > I think lot of developers will have

[sqlite] is SQLite the right tool to analyze a 44GB file

I'm new to SQLite . not a programmer . not a DBA . just an end-user with no dev support for a pilot project (single user, no updates, just queries). I want to analyze the data contained in a 44GB csv file with 44M rows x 600 columns (fields all <15 char). Seems like a DBMS will allow me to

Re: [sqlite] is SQLite the right tool to analyze a 44GB file

If none of your fields contain a comma, you can just use the sqlite3 terminal to load a csv file. On Tue, May 1, 2012 at 11:06 PM, peter korinis wrote: > I'm new to SQLite . not a programmer . not a DBA . just an end-user with no > dev support for a pilot project (single

Re: [sqlite] is SQLite the right tool to analyze a 44GB file

You need to try and do an import from the shell. GUIs seem to have way too many limits. http://sqlite.org/download.html Don't do any indexes up frontdo them afterwords if they'll help your queries. Indexes will slow down your import notably. I don't think you're anywhere near the

Re: [sqlite] is SQLite the right tool to analyze a 44GB file

It is already wrapped in a transaction. I seem to remember seeing somewhere that the .import command doesn't understand escaping, e.g. "one","two,three" will get imported as "one" | "two | three" (the quotes are part of the data, and the second column was split into two by the comma)

Re: [sqlite] System.Data.SQLite and pooling problem

On 27 April, Greg Carter wrote: On 27 April 2012 11:39, Larry Brasfield wrote: [snip] > You "works as it should" is only assured (inasmuch as any > software can) when you use the .Net framework's assured disposition > mechanism ("using ..." and properly implemented IDispose) or effect the >

Re: [sqlite] 64-bit precompiled command-line shell binary for Windows 7

Thank you Mr. Burstein. This is great !!! Run times using memory for DB and Temp are much improved over SSD - let alone conventional disk, "out of memory" messages are gone, count (*) is sub-second. Time to go shopping for more RAM. Thanks again. On Mon, Apr 30, 2012 at 9:23 AM, Baruch

[sqlite] Bug: Memory leak using PRAGMA temp_store_directory

I reported this a while ago and forgot about this until today while I was doing some debugging and once again got the report of leaked memory. I'm using the c amalgamation code from 3.7.10 with VStudio 2010, and always start up my databases setting a temp directory to be used in the form: