Re: [sqlite] Announcement of Copy - A cross platform syncing app, that uses SQLite as its backend

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/03/13 12:27, Jason Dictos wrote: > Overall SQLite has been the perfect solution to our situation. Thanks for the details. What programming language do you use? (Dropbox uses Python.) > Early on we figured out quite quickly not leverage the

Re: [sqlite] Is there a way to create a foreign key in existing table?

On Fri, 1 Mar 2013 20:08:55 -0500 Stephen Chrzanowski wrote: > > I can't think of any reason a foreign key constraint would impact > > the cost of joins in any query. The cost is entirely at update time > > (when you have to enforce the constraint). > > > > Wouldn't you

Re: [sqlite] Is there a way to create a foreign key in existing table?

On Fri, Mar 1, 2013 at 11:48 AM, Ryan Johnson wrote: > > On 01/03/2013 11:10 AM, Stephen Chrzanowski wrote: > >> ***I'm waiting for the repair man to show up to fix my waterheater... >> so... >> I'm bored. This is going to be to the point at the beginning, but get >>

Re: [sqlite] [SQLite.ADO.Net] Upgrading XP to SQLite version?

On Fri, 01 Mar 2013 18:08:43 +0100, Bernd Lehmkuhl wrote: >I asked Joe Mistachkin a while back the same. Here's what he replied: > >Am 21.09.2012 00:35, schrieb Joe Mistachkin: >> Bernd wrote: >>> >>> Could you elaborate on why I should avoid doing as I do at the moment? >>> >> >>

Re: [sqlite] update the same record in multiple segments at once

Thank you both! 2013/3/1 Hick Gunter > If you MUST do this in a SQL Statement you might give this a try: > > Write a virtual table module "SPLIT" with three fields (element, > delimiter, record) that will return the parts of a string from SQL like > > SELECT element FROM SPLIT

Re: [sqlite] Is there a way to create a foreign key in existing table?

Ryan, On Fri, Mar 1, 2013 at 12:48 PM, Ryan Johnson wrote: > On 01/03/2013 2:23 PM, Igor Korot wrote: >> >> Hi, guys, >> >> On Fri, Mar 1, 2013 at 8:48 AM, Ryan Johnson >> wrote: >>> >>> On 01/03/2013 11:10 AM, Stephen Chrzanowski wrote:

Re: [sqlite] Is there a way to create a foreign key in existing table?

On 01/03/2013 2:23 PM, Igor Korot wrote: Hi, guys, On Fri, Mar 1, 2013 at 8:48 AM, Ryan Johnson wrote: On 01/03/2013 11:10 AM, Stephen Chrzanowski wrote: ***I'm waiting for the repair man to show up to fix my waterheater... so... I'm bored. This is going to be to

Re: [sqlite] Announcement of Copy - A cross platform syncing app, that uses SQLite as its backend

Overall SQLite has been the perfect solution to our situation. We needed some relation but nothing too heavy weight to store our meta data about files and shares. Early on we figured out quite quickly not leverage the read/write locking models of SQLite (SQLITE_BUSY hell) but instead use a

Re: [sqlite] Is there a way to create a foreign key in existing table?

Hi, guys, On Fri, Mar 1, 2013 at 8:48 AM, Ryan Johnson wrote: > > On 01/03/2013 11:10 AM, Stephen Chrzanowski wrote: >> >> ***I'm waiting for the repair man to show up to fix my waterheater... >> so... >> I'm bored. This is going to be to the point at the beginning,

Re: [sqlite] Announcement of Copy - A cross platform syncing app, that uses SQLite as its backend

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/03/13 09:56, Jason Dictos wrote: > This app we wrote couldn't have happened without SQLite, I would be interested in hearing about the experience with SQLite, especially anything relevant to other developers. One of your competitors is Dropbox

[sqlite] Announcement of Copy - A cross platform syncing app, that uses SQLite as its backend

Hi All, I just wanted to let you all in on a deal we are offering to everyone on this mailing list, regarding Copy a new syncing app we have deployed here at barracuda networks (www.copy.com). This app we wrote couldn't have happened without SQLite, both on

Re: [sqlite] [SQLite.ADO.Net] Upgrading XP to SQLite version?

Am 27.02.2013 15:28, schrieb Gilles Ganault: On Tue, 26 Feb 2013 19:45:27 -0500, Kevin Benson wrote: Right, but while the first DLL will be found since it's now part of the project (Project > Add Reference), the wiki doesn't say that this doesn't take care of the

Re: [sqlite] insert / replace into joined tables.

Igor, Simon, Clemens. Thanks for your advice here. Different ways to address the problem, the easiest being to remove the brackets from the select statement ( I had tried without the values keyword before, but not without the brackets). Why I didn't try this is beyond me although I probably did

Re: [sqlite] Is there a way to create a foreign key in existing table?

On 01/03/2013 11:10 AM, Stephen Chrzanowski wrote: ***I'm waiting for the repair man to show up to fix my waterheater... so... I'm bored. This is going to be to the point at the beginning, but get wordy and technical near the end. ;) Super over kill. ahem Nice explanation... just a

Re: [sqlite] Is there a way to create a foreign key in existing table?

***I'm waiting for the repair man to show up to fix my waterheater... so... I'm bored. This is going to be to the point at the beginning, but get wordy and technical near the end. ;) Super over kill. ahem To better answer your question "...is it better to...", it entirely depends on the

Re: [sqlite] insert / replace into joined tables.

On 3/1/2013 8:29 AM, chas cartmel wrote: The working MS Access SQL : UPDATE aircraft INNER JOIN datatemp ON aircraft.ModeS = datatemp.newModeS SET aircraft.Registration = [datatemp.newregistration] WHERE (((aircraft.Registration)=".NO-REG") AND ((datatemp.newRegistration)<>".NO-REG" And

Re: [sqlite] insert / replace into joined tables.

On 1 March 2013 13:29, chas cartmel wrote: > Hi guys/gals. > > First post to this group. > > I have a problem which can be solved in Access/ SQL Server but not seemingly > in SQLite. I am trying to update a value in a table from another identical > table where that value has

Re: [sqlite] insert / replace into joined tables.

chas cartmel wrote: > I have tried the "REPLACE INTO aircraft [values] (select combined > columns here ... from aircraft,datanew where ModeS = newModeS and > registration = ".NO-REG" and newregistration is not null); " as suggested > elsewhere on this forum. > > I keep getting an 'error

Re: [sqlite] update the same record in multiple segments at once

If you MUST do this in a SQL Statement you might give this a try: Write a virtual table module "SPLIT" with three fields (element, delimiter, record) that will return the parts of a string from SQL like SELECT element FROM SPLIT WHERE delimiter = ' ' and record = ; CREATE VIRTUAL TABLE split

Re: [sqlite] Run sqlite from a batch file

Hi Rick, Welcome to the group! I get the feeling that you hijacked an earlier thread given the long bodies of text I removed from the email. Anyway, it's great to see a clear detailed email with the stuff you tried. The first thing I would check for is if sqlite3 is on the path of the

Re: [sqlite] .dump - what isn't preserved?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/03/13 04:24, Dave McKee wrote: > What else isn't losslessly maintained in a dump -> load cycle? Various database settings and any strings with nuls in them. Also the sqlite shell expects to be loaded into a clean database. For example it

[sqlite] insert / replace into joined tables.

Hi guys/gals. First post to this group. I have a problem which can be solved in Access/ SQL Server but not seemingly in SQLite. I am trying to update a value in a table from another identical table where that value has been updated elsewhere. Do not want to delete insert and the original entry

[sqlite] Run sqlite from a batch file

Hi All, I am trying to execute MS DOS batch file from C# code using system.diagnostics to run a sequence of sqlite3 commands to output query results in a '.csv' file. MyBatch.bat contains... sqlite3 mydb.db < a.txt echo "test" > c:\test.txt a.txt contains... .mode csv .separator , .output

Re: [sqlite] "SQLite" Pronunciation

On Wed, 27 Feb 2013 18:28:03 -0500 f...@cetussoft.com wrote: > OK, how does one pronounce "SQLite"? "see-kwel-lite"? "ess-kyoo-lite"? > "ess-kyoo-ell-lite"? "see-kwel-ite"? "ess-kyoo-ell-ite"? Or...? I was going to answer S-Q-L-lite because it's definitely "S-Q-L", but I admit to saying

Re: [sqlite] .dump - what isn't preserved?

On 1 Mar 2013, at 12:24pm, Dave McKee wrote: > I'm considering working with a dump of the SQL database, and I'm anxious to > make sure that nothing gets lost in the transformation. I assume you're talking about the '.dump' function of the shell tool, which creates a

[sqlite] .dump - what isn't preserved?

I'm considering working with a dump of the SQL database, and I'm anxious to make sure that nothing gets lost in the transformation. I'm aware that the database will effectively be vacuumed and that rowids won't be preserved. I'm happy about the first and can live with the second. What else isn't

Re: [sqlite] Is there a way to create a foreign key in existing table?

Dan, On Fri, Mar 1, 2013 at 1:12 AM, Dan Kennedy wrote: > On 03/01/2013 03:24 PM, Igor Korot wrote: >> >> Hi, >> Will foreign key creation give me the speed increase? >> Or I need more an index? > > > Foreign keys only ever slow things down (more stuff to check each > time

Re: [sqlite] Is there a way to create a foreign key in existing table?

On 03/01/2013 03:24 PM, Igor Korot wrote: Hi, Will foreign key creation give me the speed increase? Or I need more an index? Foreign keys only ever slow things down (more stuff to check each time a row is inserted/updated/deleted). Indexes sometimes speed up queries. Dan. Thank you. On

Re: [sqlite] Is there a way to create a foreign key in existing table?

Hi, Will foreign key creation give me the speed increase? Or I need more an index? Thank you. On Tue, Jan 1, 2013 at 10:01 AM, Peter Haworth wrote: > And remembering that you will lose any indexes or triggers defined for the > table by doing this. > > There are plenty of third