Re: [sqlite] multiple connection to the same DB

Hi I'll try to give you more details We were all on Ubuntu, each colleague on a different computer with the sqlite command line tool i've created a db with $ cd  ... sothat i'was located on a server directory shared with my colleagues with the same permissions $ sqlite3 birth.sqlite  

Re: [sqlite] multiple connection to the same DB

On Sun, 22 Sep 2013 08:28:39 +0100 (BST), olivier Ménard wrote: >Hi > >I'll try to give you more details >We were all on Ubuntu, each colleague on a different computer > >with the sqlite command line tool i've created a db with > >$ cd  ... sothat i'was located on a

Re: [sqlite] multiple connection to the same DB

We were far from a high concurrency use of sqlite, only 15 members, and using only a single line insert. So i thought it should be ok. I'll continue to use sqlite but as the only administrator of the DB : I'll try to give the permissions rw-r--r-- to my file, and hope it'll works. De : Kees

Re: [sqlite] a tool that allows you to graphically change sqlite schema

I like SQLite Expert too. Very nice tool, you don't have to run Firefox to use it, and the personal edition is free. I've gotten a lot of good use out of it. Windows only is the one drawback. -Bill On 9/18/2013 5:09 AM, jcd wrote: Is there a tool that allows you to graphically change

Re: [sqlite] multiple connection to the same DB

On 22 Sep 2013, at 12:30pm, olivier Ménard wrote: > We were far from a high concurrency use of sqlite, only 15 members, and using > only a single line insert. So i thought it should be ok. > I'll continue to use sqlite but as the only administrator of the DB : > I'll try to

[sqlite] Fwd: Having trouble using sqlite to handle query that contains Chinese characters

> Subject: Having trouble using sqlite to handle query that contains Chinese > characters > > Dear Sir: > > I was working on a windows 8 app, which involve using SQLite database. I > downloaded .dll from your website. I have some trouble when using sqlite to > handle query that contains

Re: [sqlite] List record from one table and all matching in another

On Sat, 21 Sep 2013 15:06:14 +0100 Simon Slavin wrote: > > If I "SELECT * FROM Groceries" to list all records, how do I > > arrange a query to list each record in the groceries table with all > > matching history items under each record. > > You do it with two queries, not

Re: [sqlite] Regression: Query takes 10x longer when using version 3.8.x

On Sat, 21 Sep 2013 00:28:15 +0100 Simon Slavin wrote: > Your extremely long SELECT with its sixteen COALESCEs and eight LEFT > OUTER JOINs suggests that you have a schema which doesn't really suit > the 'shape' of your data. Another hint pointing in the same > direction

Re: [sqlite] List record from one table and all matching in another

On 22 Sep 2013, at 4:06pm, James K. Lowden wrote: > The right answer is to join the tables in a single query and -- as you > suggest --use application logic detect when a "new" item needs a new > header. Agreed. So to summarise for the OP, the best solution is a

Re: [sqlite] multiple connection to the same DB

The os in use is Linux Ubuntu, so i suppose the protocol NFS too. If i have well understood : in theory, multiple access should work with sqlite, but in practice, it doesn't because of the os : the mechanism of locking doesn't work ? I supose it won't change anything but Is it possible to

Re: [sqlite] multiple connection to the same DB

My track record of giving helpful advice here is not great, but this does not sound like an NFS problem to me. Your example made it look like everyone is logging into the server, and running the SQLite executable located there, rather than running an executable located on their own machine

Re: [sqlite] multiple connection to the same DB

On 22 Sep 2013, at 4:50pm, Gerry Snyder wrote: > If I am right, then something else is happening, such as somehow using > different files, or something else deleting or otherwise modifying the file > between accesses. Worth testing. Have one user create an entry in

Re: [sqlite] WAL files and PERL question

John Carey wrote: [Lot's of stuff, in multiple, apparently redundant threads, cut as irrelevant.] If I go into the firefox add on and run a checkpoint , the 2 new invoices get flushed from the WL to the db file and then my program sees them what am I doing wrong where my script is only

Re: [sqlite] WAL files and PERL question

Larry Brasfield wrote: > If I go into the firefox add on and run a checkpoint , the 2 new invoices > get flushed from the WL to the db file and then my program sees them > what am I doing wrong where my script is only looking at the db file and not > the WAL file? An explanation would be that

Re: [sqlite] INSERT INTO ???

I'll try. Thanks. This seems just what I need. Bertwim On 09/21/2013 06:12 AM, Bernhard Amann wrote: INSERT INTO SELECT * FROM ; However, this only works if already exists, which is actually quite cumbersome.. Is there a way to make the new table 'on the fly"? create table newtable as

[sqlite] Compare and INSERT INTO syntax issue

I am trying to grab the value of custom5 % and compare it to skipcount and then if it is a higher value write it to skipcount, but something is wrong with my syntax, can anyone help? INSERT OR REPLACE INTO SONGS (skipcount) Values SELECT substr( custom5, 1, 4) FROM SONGS WHERE custom5 >

Re: [sqlite] Compare Similar Cells

On 9/22/2013 10:41 PM, Kristopher Roy wrote: I have a table of songs, several have similar titles I can't find where to get started. I tried this but its not right. Select SongTitle, COUNT(SongTitle) AS LIKE_COUNT FROM Songs What do you mean by "similar titles"? Show a representative sample of

Re: [sqlite] Compare Similar Cells

Lets say one songtitle is "Happy Day" and another one "12 - Happy Day" On Sun, Sep 22, 2013 at 8:28 PM, Igor Tandetnik wrote: > On 9/22/2013 10:41 PM, Kristopher Roy wrote: > >> I have a table of songs, several have similar titles I can't find where to >> get started. I