Re: [sqlite] Apple announces new File System with better ACID support

> On 13 Jun 2016, at 10:13pm, Richard Hipp wrote: > > The rename-is-atomic assumption is so > wide-spread in the Linux world, that the linux kernel was modified to > make renames closer to being atomic on common filesystems such as > EXT4.

Re: [sqlite] Managing SQLite indices.

On 14 Jun 2016, at 12:27am, Smith, Randall wrote: > the info from EXPLAIN QUERY PLAN and from reading the query itself don't > always lead to an obvious statement of what indices are needed. I don't think this can be done well by software. Of course, I haven't tried

[sqlite] Managing SQLite indices.

I'm developing a medium-sized SQLite-based app (maybe 50 tables, 400 query, insert, and update routines). As we all know, having the right set of table indices is vital for getting decent performance from SQL. However, I'm getting to the point on this project where this is getting to be very

Re: [sqlite] Apple announces new File System with better ACID support

On 13 Jun 2016, at 10:13pm, Richard Hipp wrote: > On 6/13/16, Simon Slavin wrote: > >> The relevance to this list is mostly in the last item above: atomic >> safe-save primitives. > > The documentation indicates that safe-save only does file rename >

Re: [sqlite] Apple announces new File System with better ACID support

On 6/13/16, Simon Slavin wrote: > > The relevance to this list is mostly in the last item above: atomic > safe-save primitives. The documentation indicates that safe-save only does file rename operations atomically. This of no help in making SQLite transactions atomic.

[sqlite] Apple announces new File System with better ACID support

Please excuse my arguably off-topic posting, but Apple users should greet this with merriment. One of the lower-profile things announced at Apple's current WWDC conference is a replacement for HFS+ (introduced in 1998), tuned to the demands of the modern age:

Re: [sqlite] SQLite in Android N

On 6/13/16, Eric Sink wrote: > "Richard (et al), you no doubt have some contact with the Android folks at > Google. Do you have any information you can share about these issues?" > > I don't think I've seen any reply to this question. It was a yes/no > question, so I

Re: [sqlite] SQLite in Android N

"Richard (et al), you no doubt have some contact with the Android folks at Google. Do you have any information you can share about these issues?" I don't think I've seen any reply to this question. It was a yes/no question, so I *could* interpret radio silence as "no". :-) But I think I'll

Re: [sqlite] Trouble coding conditional UNIQUE

Wow! Thanks for the quick reply and link to documentation. When I searched on line for conditional unique constraint I found all sorts of complicated examples that sent me off in the wrong direction. Thank you! -- Bill Drago Staff Engineer L3 Narda-MITEQ 435 Moreland Road Hauppauge, NY 11788

Re: [sqlite] Trouble coding conditional UNIQUE

CREATE UNIQUE INDEX bcuif0e ON (b,c) WHERE e = 0; Assuming you're not using a pre-WHERE clause on Indexes version of SQLite.   Since unique constraints and unique indexes are functionally identical. Peter On Monday, June 13, 2016 12:11 PM, "Drago, William @ CSG - NARDA-MITEQ"

Re: [sqlite] Trouble coding conditional UNIQUE

Apologies Bill, I hit send before linking the actual documentation, here goes: https://www.sqlite.org/partialindex.html See especially section 2.1 Good luck! Ryan On 2016/06/13 9:16 PM, R Smith wrote: On 2016/06/13 9:11 PM, Drago, William @ CSG - NARDA-MITEQ wrote: All, I am having

Re: [sqlite] Trouble coding conditional UNIQUE

On 2016/06/13 9:11 PM, Drago, William @ CSG - NARDA-MITEQ wrote: All, I am having trouble figuring out how to implement a conditional UNIQUE constraint. Assume the following table: CREATE TABLE myTable ( A INTEGER PRIMARY KEY, B TEXT NOT NULL COLLATE NOCASE, C TEXT NOT NULL COLLATE NOCASE,

[sqlite] Trouble coding conditional UNIQUE

All, I am having trouble figuring out how to implement a conditional UNIQUE constraint. Assume the following table: CREATE TABLE myTable ( A INTEGER PRIMARY KEY, B TEXT NOT NULL COLLATE NOCASE, C TEXT NOT NULL COLLATE NOCASE, D TEXT NOT NULL COLLATE NOCASE, E INTEGER, F TEXT COLLATE NOCASE, G

Re: [sqlite] Update DataGrid and Save to database

Most people seem to prefer black these days, but white is cooler. Reflects, rather than absorbs, heat. Of course, if you live up north that might be a bad thing. Here in the south, all is well... On Mon, Jun 13, 2016 at 9:31 AM, Chris Locke wrote: > Great analogy.

Re: [sqlite] Update DataGrid and Save to database

Great analogy. PS: What colour seat covers should I be using if I have a Ford? On Mon, Jun 13, 2016 at 2:11 PM, jumper wrote: > Thank you for the advice/information. I just solved the issue about a > minute ago. How can I stop getting new replies? > > > On 6/13/2016 8:08 AM,

Re: [sqlite] I solved the problem with gridview and database

On 13 Jun 2016 at 14:15, jumper wrote: > Can someone please tell me how to stop the previous post so everyone > doesn't see it anymore? > thank you > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org >

Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

What's the programming language used in the application? I use Freepascal / Lazarus as a programming language and my own sqlite wrapper written in Freepascal as well. I will add the sqlite3_extended_errcode + sqlite3_errstr to the wrapper lib in order to get extended error infos and will

Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

On 2016/06/13 3:41 PM, Luc DAVID wrote: Thanks Ryan and Oliver for your answers You are too fast for me, I didn't have the time to answer the first posts... @Ryan > There is no safe way to do what you need. Networked file systems do not > play nice with file-locking. SQLite is suitable for

Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

> Le 13 juin 2016 à 15:41, Luc DAVID a écrit : > > The worst case is when you get a "Database is locked" message which mean you > have to kill all the application processes in order to unlock the db (unless > another means exists ?) You shouldn't get any such with

Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

Thanks Ryan and Oliver for your answers You are too fast for me, I didn't have the time to answer the first posts... @Ryan > There is no safe way to do what you need. Networked file systems do not > play nice with file-locking. SQLite is suitable for localized storage, > not

Re: [sqlite] I solved the problem with gridview and database

On Mon, Jun 13, 2016 at 8:15 AM, jumper wrote: > Can someone please tell me how to stop the previous post so everyone > doesn't see it anymore? > thank you > > ​This is a e-mail based forum. Your request is the equivalent of asking the post office to "undeliver" an already

Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

On 2016/06/13 3:12 PM, Olivier Mascia wrote: Le 13 juin 2016 à 15:02, R Smith a écrit : The application will be used by ± 10 users via RDP TSE clients. Hi Luc, There is no safe way to do what you need. Networked file systems do not play nice with file-locking. SQLite

Re: [sqlite] I solved the problem with gridview and database

You cannot remove a post once it is posted. If you would like to unsubscribe so YOU do not see these replies anymore, you can do so by simply following the links at the bottom of every message. On 2016/06/13 3:15 PM, jumper wrote: Can someone please tell me how to stop the previous post so

[sqlite] I solved the problem with gridview and database

Can someone please tell me how to stop the previous post so everyone doesn't see it anymore? thank you ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

> Le 13 juin 2016 à 15:02, R Smith a écrit : > >> The application will be used by ± 10 users via RDP TSE clients. >> > Hi Luc, > There is no safe way to do what you need. Networked file systems do not play > nice with file-locking. SQLite is suitable for localized storage,

Re: [sqlite] Update DataGrid and Save to database

On 2016/06/13 3:09 PM, jumper wrote: I just solved it only seconds ago. Can't believe it after all this time. How do I stop getting messages now that I have it working? Have you read this e-mail all the way to the bottom? :) ___ sqlite-users

Re: [sqlite] Update DataGrid and Save to database

Thank you for the advice/information. I just solved the issue about a minute ago. How can I stop getting new replies? On 6/13/2016 8:08 AM, R Smith wrote: On 2016/06/13 2:48 PM, jumper wrote: New to SQLite and DataGrids. I need to know how to get an adapter, table and dataset when app

Re: [sqlite] Update DataGrid and Save to database

I just solved it only seconds ago. Can't believe it after all this time. How do I stop getting messages now that I have it working? thank you so much. On 6/13/2016 8:04 AM, Chris Brody wrote: I wonder if the answers following link could help you:

Re: [sqlite] Update DataGrid and Save to database

On 2016/06/13 2:48 PM, jumper wrote: New to SQLite and DataGrids. I need to know how to get an adapter, table and dataset when app first comes up. Then when someone updates the DataGrid I need to save the changes to the database. I've been working on this for days and can't do it. Could

Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

> Le 13 juin 2016 à 14:20, Luc DAVID a écrit : > > Hello, > > I'm planning to install an application using sqlite on a windows 2003 > server. > > The application exe + sqlite dll + database will be installed in the same > server directory. Best would be to compile

Re: [sqlite] Update DataGrid and Save to database

I wonder if the answers following link could help you: http://stackoverflow.com/questions/19617368/sqlite-database-and-datagrid I found this by a quick Google search. For the future please explain the context, show that you have done some basic research, show what you have found, and show

Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

On 2016/06/13 2:20 PM, Luc DAVID wrote: Hello, I'm planning to install an application using sqlite on a windows 2003 server. The application exe + sqlite dll + database will be installed in the same server directory. The application will be used by ± 10 users via RDP TSE clients. I need to

[sqlite] Update DataGrid and Save to database

New to SQLite and DataGrids. I need to know how to get an adapter, table and dataset when app first comes up. Then when someone updates the DataGrid I need to save the changes to the database. I've been working on this for days and can't do it. Could someone please post the code for how to do

Re: [sqlite] Setting a "profile" callback cause empty result

On 6/13/16, Eric Boudaillier wrote: > Using the Tcl interface with the "profile" callback set, "onecolumn" and > "exists" returns empty result. Tnx for the bug report. Fixed by https://www.sqlite.org/src/info/d362ba157f993fc7 > > In the code, in

[sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

Hello, I'm planning to install an application using sqlite on a windows 2003 server. The application exe + sqlite dll + database will be installed in the same server directory. The application will be used by ± 10 users via RDP TSE clients. I need to take care of possible database locks

[sqlite] Setting a "profile" callback cause empty result

Using the Tcl interface with the "profile" callback set, "onecolumn" and "exists" returns empty result. In the code, in DB_EXISTS/DB_ONECOLUMN branch, Tcl_SetObjResult() is called before dbEvalFinalize(), inlike in the DB_EVAL branch. The profile callback is probably called inside