Re: [sqlite] Re: sqlite-users Digest 22 May 2004 05:23:11 -0000 Issue 115
Ulrik Petersen wrote: IANAL, but the way I understand it, you can't link against their libraries and still distribute your code under an Open Source license, or distribute your binaries under a license that requires that the software be offered at no charge. My understanding may be flawed, so read the EULA yourself before deciding whether the toolchain is for you. It looks like they only bar you from distributing their redistributables under the terms of a viral license. You'd still be free to compile, link, and distribute binaries of open source apps under other licenses. -- http://www.classic-games.com/ http://www.indie-games.com/ "Iraq may not be the war on terror itself, but it is critical to the outcome of the war on terror, and therefore any advance in Iraq is an advance forward in that..." -- John Kerry 12/15/03 "I took part in search and destroy missions, in the burning of villages." -- John Kerry 4/18/71 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Delete database
Hi, My application creates a temporary SQLite database that other applications can access while it is "alive". Unfortunately, after another application accesses the database, the original application cannot delete it. Also, if the original application accesses the dtabase in a subsequent session, it cannot delete it. I've tried closing the database from all applications, (before deleting) to no avail. What am I doing wrong? I wish to thank you in advance for your help! Sincerely, Ed Porter - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] syncronizing
nathanvi <[EMAIL PROTECTED]> writes: > In my office we have to share a databse (a list of addresses). > A lot of people has a notebook. > So my idea was: > - a file.sqlite on the server in which all people can add, delete, > select contacts > - when someone have to go away, he can copy this file on his notebook > and modify it when he is outside office > > The problem is when he return in office because i would like the copy > and the original in the server are syncronized... > Is it possible? > Is there an utility which does it? The "Familiar" (Linux on Handhelds) PIM suite uses sqlite as the underlying mechanism for storing the PIM data. They may have a mechanism worked out by now, for synchronization. See http://familiar.handhelds.org for more information. Derrell - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Re: sqlite-users Digest 22 May 2004 05:23:11 -0000 Issue 115
Hello all, Michael Roth wrote: > and I wrote: - Microsoft Visual C++ Toolkit 2003. Microsoft recently released their compiler and toolchain for free download: http://msdn.microsoft.com/visualc/vctoolkit2003/ Check the license! It is not really fair! Don't use this toolchain. Oops, I hadn't read the license (nor used the software). The licensing restrictions are rather agressive towards all Open Source software. Read especially section 3.2. The EULA is here: http://msdn.microsoft.com/visualc/vctoolkit2003/eula.aspx IANAL, but the way I understand it, you can't link against their libraries and still distribute your code under an Open Source license, or distribute your binaries under a license that requires that the software be offered at no charge. My understanding may be flawed, so read the EULA yourself before deciding whether the toolchain is for you. Sorry for suggesting Microsoft's "free" toolchain. I didn't know any better. Cheers, Ulrik - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] Version 3 design issue: Keep the COPY command?
D. Richard Hipp ([EMAIL PROTECTED]) wrote: > Here are the options: > (1) Extend the syntax of the COPY command to allow the user > to specify the text representation of the file being > imported. I would prefer this option. In addition it should be possible to remove the COPY-Command by a compiletime switch. Further more it would be helpful to have the possibility of asking in runtime whether the COPY-Command is supported. > (2) Always assume the import is coming from a UTF-8 file. > (3) Remove the COPY command all together. Hans-Jürgen - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] Version 3 design issue: Keep the COPY command?
D. Richard Hipp wrote: (3) Remove the COPY command all together. The third. Paolo - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] Version 3 design issue: Keep the COPY command?
At 12:38 PM -0500 5/22/04, Daniel Lee Kruse wrote: Frank Baumgart wrote: D. Richard Hipp wrote: (3) Remove the COPY command all together. For the reasons you gave below, esp. to keep the size down (on an embedded system) Frank Baumgart [snip] I second Frank's response. I third this. Get COPY out of the core, where it doesn't belong. Moreover, interacting with the file system at all for reasons other than the core and rollback files should simply not happen in the core. -- Darren Duncan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] syncronizing
On Sat, 2004-05-22 at 13:47, Puneet Kishor wrote: > On May 22, 2004, at 12:31 PM, nathanvi wrote: > > > In my office we have to share a databse (a list of addresses). > > A lot of people has a notebook. > > So my idea was: > > - a file.sqlite on the server in which all people can add, delete, > > select contacts > > - when someone have to go away, he can copy this file on his notebook > > and modify it when he is outside office > > > > The problem is when he return in office because i would like the copy > > and the original in the server are syncronized... > > Is it possible? > > Is there an utility which does it? > > I don't know of any utility that does synchronization, but I do know > that synchronization is not a simple problem. You have to make rules > for conflict-resolution when source and target are different, and just > looking at the modified date stamp might not be enough. For your > specific problem you might be better off with a tool suited for > something like this... Palm Desktop or other such address book type > programs come to mind. A database may not be the best tool for such a > thing. That said, of course, one could create a program that does such > a synchronization, but it may not be worth the trouble. > > Sorry for no encouraging answer vis a vis SQLite. I have a similar problem; for the synchronization step of my software, the database is dumped to a text format sorting on an object id and version column, and then I use diff to produce a patch that I then simply upload. I then use rsync to download updates. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] syncronizing
On May 22, 2004, at 1:17 PM, Mario Ruggier wrote: On May 22, 2004, at 7:47 PM, Puneet Kishor wrote: On May 22, 2004, at 12:31 PM, nathanvi wrote: In my office we have to share a databse (a list of addresses). A lot of people has a notebook. So my idea was: - a file.sqlite on the server in which all people can add, delete, select contacts - when someone have to go away, he can copy this file on his notebook and modify it when he is outside office The problem is when he return in office because i would like the copy and the original in the server are syncronized... Is it possible? Is there an utility which does it? I don't know of any utility that does synchronization, but I do know that synchronization is not a simple problem. You have to make rules for conflict-resolution when source and target are different, and just looking at the modified date stamp might not be enough. For your specific problem you might be better off with a tool suited for something like this... Palm Desktop or other such address book type programs come to mind. A database may not be the best tool for such a thing. That said, of course, one could create a program that does such a synchronization, but it may not be worth the trouble. Sorry for no encouraging answer vis a vis SQLite. Agree that syncing is not an easy problem... Apple iSync, on Mac Os X, can handle syncronizing .. yes, iSync can do it. I just wanted to stay platform neutral in my answer. The original poster might not have or want to use a Mac. Palm Desktop is free and does exist on both Macs and Windows, but afaik not on (Li|U)n(u|i)x or other OSes. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] syncronizing
On May 22, 2004, at 7:47 PM, Puneet Kishor wrote: On May 22, 2004, at 12:31 PM, nathanvi wrote: In my office we have to share a databse (a list of addresses). A lot of people has a notebook. So my idea was: - a file.sqlite on the server in which all people can add, delete, select contacts - when someone have to go away, he can copy this file on his notebook and modify it when he is outside office The problem is when he return in office because i would like the copy and the original in the server are syncronized... Is it possible? Is there an utility which does it? I don't know of any utility that does synchronization, but I do know that synchronization is not a simple problem. You have to make rules for conflict-resolution when source and target are different, and just looking at the modified date stamp might not be enough. For your specific problem you might be better off with a tool suited for something like this... Palm Desktop or other such address book type programs come to mind. A database may not be the best tool for such a thing. That said, of course, one could create a program that does such a synchronization, but it may not be worth the trouble. Sorry for no encouraging answer vis a vis SQLite. Agree that syncing is not an easy problem... Apple iSync, on Mac Os X, can handle syncronizing the Address Book between different machines, as well as different devices. I use it to manage the same list of addresses on my desktop (used by Mail and other applications) and my Treo palm os pda phone. Pretty nice... - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] syncronizing
On May 22, 2004, at 12:31 PM, nathanvi wrote: In my office we have to share a databse (a list of addresses). A lot of people has a notebook. So my idea was: - a file.sqlite on the server in which all people can add, delete, select contacts - when someone have to go away, he can copy this file on his notebook and modify it when he is outside office The problem is when he return in office because i would like the copy and the original in the server are syncronized... Is it possible? Is there an utility which does it? I don't know of any utility that does synchronization, but I do know that synchronization is not a simple problem. You have to make rules for conflict-resolution when source and target are different, and just looking at the modified date stamp might not be enough. For your specific problem you might be better off with a tool suited for something like this... Palm Desktop or other such address book type programs come to mind. A database may not be the best tool for such a thing. That said, of course, one could create a program that does such a synchronization, but it may not be worth the trouble. Sorry for no encouraging answer vis a vis SQLite. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] Version 3 design issue: Keep the COPY command?
Frank Baumgart wrote: D. Richard Hipp wrote: (3) Remove the COPY command all together. For the reasons you gave below, esp. to keep the size down (on an embedded system) Frank Baumgart [snip] I second Frank's response. -- Daniel Lee Kruse - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] syncronizing
In my office we have to share a databse (a list of addresses). A lot of people has a notebook. So my idea was: - a file.sqlite on the server in which all people can add, delete, select contacts - when someone have to go away, he can copy this file on his notebook and modify it when he is outside office The problem is when he return in office because i would like the copy and the original in the server are syncronized... Is it possible? Is there an utility which does it? Thanks, nathanvi PS Sorry for my english :-( -- ** The UNIX Guru's view of sex: unzip; strip; touch; finger; mount; fsck; more; yes; umount; sleep ** L'unica accelerazione possibile per windows: (9.81 m/s2) pgpsfqSvx1dWN.pgp Description: PGP signature
Re: [sqlite] Version 3 design issue: Keep the COPY command?
D. Richard Hipp wrote: (3) Remove the COPY command all together. For the reasons you gave below, esp. to keep the size down (on an embedded system) Frank Baumgart - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Version 3 design issue: Keep the COPY command?
Version 3.0 of SQLite will support unicode in three different representations: UTF-8, UTF-16LE, and UTF-16BE. So the question has come up about what encoding(s) should the COPY command support. The COPY command, you will recall, is a non-standard command in SQLite that is modeled after the same command in PostgreSQL. The SQLite version is more limited than the PostgreSQL version. COPY in SQLite allows you to quickly copy import amounts of data from a text file into an internal table. The original PostgreSQL version allows import and export. Here are the options: (1) Extend the syntax of the COPY command to allow the user to specify the text representation of the file being imported. (2) Always assume the import is coming from a UTF-8 file. (3) Remove the COPY command all together. Right now, we are leaning toward option (3) - delete the COPY command. If you think that is the wrong approach, this is your opportunity to speak up. Reasons to remove the COPY command: * It is not standard SQL. * You can accomplish the same thing just as quickly using BEGIN, a precompiled INSERT statement executing multiple times with different bindings each time, and a COMMIT. * Removing COPY makes SQLite simpler and smaller and we very must want to keep SQLite simple and small. * The equivalent functionality can be moved into the shell. Instead of a COPY command in SQL, you can have a ".copy" shell command. And the new ".copy" shell command (actually, it will probably have a different name) can support formats other than the PostgreSQL format. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] Two Table Sort Question
On May 22, 2004, at 2:25 AM, Darren Duncan wrote: At 10:23 PM -0700 5/21/04, Sanford Selznick wrote: I have Table1: data1 data2 data3 nameID -> id of record in Table2 I have Table2 id name1 name2 I'd like to select all records from table 1, and have them sorted by name1. What's the best way to do this? Try this: SELECT t1.* FROM Table1 t1 INNER JOIN Table2 t2 ON t2.id = t1.nameID ORDER BY t2.name1 Does that work for you? However, the above solution does not output the column you are sorting by, so what practical good does this sorting do you? Also, all records in data1 which have the same nameID value will be unsorted within themselves, if that matters. -- Darren Duncan so, why not do SELECT t1.data1, t1.data2, t1.data3, t1.nameID, t2.name1 FROM Table1 t1 INNER JOIN (or possibly LEFT JOIN depending on the constraint) Table2 t2 ON t1.nameID = t2.id ORDER BY t2.name1, t1.(any other field), etc. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] Two Table Sort Question
At 10:23 PM -0700 5/21/04, Sanford Selznick wrote: I have Table1: data1 data2 data3 nameID -> id of record in Table2 I have Table2 id name1 name2 I'd like to select all records from table 1, and have them sorted by name1. What's the best way to do this? Try this: SELECT t1.* FROM Table1 t1 INNER JOIN Table2 t2 ON t2.id = t1.nameID ORDER BY t2.name1 Does that work for you? However, the above solution does not output the column you are sorting by, so what practical good does this sorting do you? Also, all records in data1 which have the same nameID value will be unsorted within themselves, if that matters. -- Darren Duncan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]