[sqlite] Sqlite3 handler uses

What is the best practice to use sqlite3 handler in multithread environment.[I am using on Linux] · Open sqlite3 database file once & use the same sqlite3 handler in all the thread for any operation on sqlite3 database file. or · Open & close all the time for each operation on

Re: [sqlite] DELETE & INSERT vs. REPLACE

On May 29, 2014 4:59 PM, "J Decker" wrote: > If you have constraints between your tables (like cascade on delete) then > deleting a guitar entry would remove its related entirs in other tables > referencing that same ID. That's what deferred foreign key constraints are for,

Re: [sqlite] SELECTing WHERE calculation > 0

Hi Jose: In SQL, aggregate function cannot be used in the WHERE clause. Use the HAVING clause instead. Try this: SELECT cust, ProjID, proj, A_No, bdate, CASE Xtra4 WHEN 'y' THEN vEmail ELSE 'noemail' END, sum(ProjFund), sum(ProjFund)-sum(CASE

Re: [sqlite] SELECTing WHERE calculation > 0

Do you want a HAVING clause? On Thu, May 29, 2014 at 5:14 PM, jose isaias cabrera wrote: > > Greetings! > > I have this select, > > SELECT cust, > ProjID, > proj, > A_No, > bdate, > CASE Xtra4 WHEN 'y' THEN vEmail ELSE 'noemail' END, >

[sqlite] SELECTing WHERE calculation > 0

Greetings! I have this select, SELECT cust, ProjID, proj, A_No, bdate, CASE Xtra4 WHEN 'y' THEN vEmail ELSE 'noemail' END, sum(ProjFund), sum(ProjFund)-sum(CASE Xtra4 WHEN 'y' THEN invoice ELSE 0 END), sum(CASE Xtra4 WHEN 'y' THEN invoice ELSE 0

Re: [sqlite] DELETE & INSERT vs. REPLACE

> > > Can someone tell me what an appropriate use for REPLACE is? > > Replace might be used if you had a user_permission_info table, and were editing things about the user like maybe lastname/staffID ... password... but then with replace you MUST reference all unique keys...but basicallly the user

Re: [sqlite] New DLLs and sources. Was: SQLite version 3.8.5 beta

Hi all, It was posted earlier that : This time I build the 32-bit DLL using mingw instead of MSVC. (MSVC was still used for the 64-bit DLL.) So perhaps it will work correctly on WinXP. Please let me know one way or the other. Thanks. I see that the 64-bit MSVC DLL has the correct version

Re: [sqlite] Release date of Windows Phone 8.1 SQLite

I believe the SQLitePCL also needs to be updated for "wpa" version right now it just works with Windows Phone Silverlight 8.1. Cheers Ryan -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Venkatesh Sent: Thursday, May 22,

Re: [sqlite] DELETE & INSERT vs. REPLACE

I tend to use an UPDATE ... WHERE EXISTS ...; followed by an INSERT ... WHERE NOT EXISTS ...;, which gives me insert or update semantics. Nico -- ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Joining different databases

Thanks, I figured that would be the answer, but was hoping that I was missing something obvious. David From: Igor Tandetnik To: sqlite-users@sqlite.org Sent: Thursday, May 29, 2014 11:58 AM Subject: Re: [sqlite] Joining different

Re: [sqlite] Joining different databases

On 5/29/2014 10:42 AM, David Bicking wrote: How complicated is the join? Could you show a hypothetical SQL statement you would have used had both tables been in the same database? Not complicated: Select b.id, b.name, b.otherfields from a inner join b on a.id = b.id where a.name<>b.name or

Re: [sqlite] DELETE & INSERT vs. REPLACE

I second "Petite Abeille", the merge into (SQL 2003) would be more than useful. REPLACE should be avoided. On Wed, May 28, 2014 at 5:08 PM, Simon Slavin wrote: > > On 28 May 2014, at 3:55pm, Drago, William @ MWG - NARDAEAST > wrote: > > > Can

Re: [sqlite] Creating a 'SQL text' Backup of a SQlite database with the mere sqlite.dll tool (and a Python 3)

Op 29 mei 2014, om 15:38 heeft Domingo Alvarez Duarte het volgende geschreven: On Thu, May 29, 2014 at 2:25 PM, E.Pasma wrote: Op 29 mei 2014, om 11:59 heeft big stone het volgende geschreven: Hello, I would like to save my sqlite ':memory:' database into a sql

Re: [sqlite] Creating a 'SQL text' Backup of a SQlite database with the mere sqlite.dll tool (and a Python 3)

Hi Domingo, I don't know what this API is and if it's usable from standard Python. As I wanted also to backup my internal Python Procedures, I just finished my first attempt. I don't know if I did it in the right order. ==> Casual testers are welcome. screenshot

Re: [sqlite] Joining different databases

From: Igor Tandetnik To: sqlite-users@sqlite.org Sent: Thursday, May 29, 2014 10:34 AM Subject: Re: [sqlite] Joining different databases On 5/29/2014 10:26 AM, David Bicking wrote: >> I have a somewhat large table in an sqlite

Re: [sqlite] Joining different databases

On 5/29/2014 10:26 AM, David Bicking wrote: I have a somewhat large table in an sqlite database and another large table on an MS SQL Server database (on a slow network). I want to query both tables in a join. How complicated is the join? Could you show a hypothetical SQL statement you

Re: [sqlite] sqlite4 Windows build

On Thu, May 29, 2014 at 4:22 PM, jose isaias cabrera wrote: > http://www.sqlite.org/draft/howtocompile.html#dll > > The "draft" page above will be promoted to the official website at the > next release. > Caveat: those instructions are for sqlite3 and may not apply for

[sqlite] Joining different databases

I have a somewhat large table in an sqlite database and another large table on an MS SQL Server database (on a slow network).  I want to query both tables in a join. The join is likely to produce from zero to a dozen rows. First thought was to copy the data from the SQL Server table to the

Re: [sqlite] sqlite4 Windows build

"Mickey" wrote... Hello, I've been tasked with integrating SQLite4 LSM for testing purposes into our project. I compiled the SQlite .a file under Ubuntu but I also need to create a Windows static library. Can someone please provide me some instruction on creating the Windows Static Library?

Re: [sqlite] Creating a 'SQL text' Backup of a SQlite database with the mere sqlite.dll tool (and a Python 3)

I'm seeing this thread for a while and don't remember anyone mentioning the sqlite3_backup_* api functions, isn't that what are you looking for ? Cheers ! On Thu, May 29, 2014 at 2:25 PM, E.Pasma wrote: > Op 29 mei 2014, om 11:59 heeft big stone het volgende geschreven: >

Re: [sqlite] Creating a 'SQL text' Backup of a SQlite database with the mere sqlite.dll tool (and a Python 3)

Op 29 mei 2014, om 11:59 heeft big stone het volgende geschreven: Hello, I would like to save my sqlite ':memory:' database into a sql command text file. With sqlite.dll, what is the procedure/algorithm ? Is it already explained somewhere on Internet ? At first look, I may imagine that I

Re: [sqlite] Creating a 'SQL text' Backup of a SQlite database with the mere sqlite.dll tool (and a Python 3)

Hi Simon, For structure, all is in "select sql from master_sqlite", the big subtility is to play them in a pertinent order. For the data themselves, it is already done in the source sqlite.exe for the ".dump" function, so I have just to digg . Apparently , it's in shell.c around line 1275 .

Re: [sqlite] fsync of directories on AIX

When there is no file (zPath) Linux: fsync(fd) Result: 0 AIX: fsync(fd) result: -1 need file check if( fsync(fd) ) if( osAccess(zPath, 0) == 0 && fsync(fd) ) But I'm not certainty -- View this message in context:

Re: [sqlite] New DLLs and sources. Was: SQLite version 3.8.5 beta

Out of curiosity, I wrote a loadable module to benchmark sqlite3 in a 32 million iterations loop doing nothing to gauge its performance. There is no I/O from querying any tables. The rows are artificially created from incrementing an integer counter. 32 million rows is about the normal size

[sqlite] sqlite4 Windows build

Hello, I've been tasked with integrating SQLite4 LSM for testing purposes into our project. I compiled the SQlite .a file under Ubuntu but I also need to create a Windows static library. Can someone please provide me some instruction on creating the Windows Static Library? Thank you. -- View

Re: [sqlite] Creating a 'SQL text' Backup of a SQlite database with the mere sqlite.dll tool (and a Python 3)

I agree with Simon, there is no direct way to export your data as SQL commands. But there are a few things you can do; 1> Code it out yourself, but you'll need to be aware of how you're dealing with the order you need 2> As you're making changes to the database, write out the

Re: [sqlite] Creating a 'SQL text' Backup of a SQlite database with the mere sqlite.dll tool (and a Python 3)

On 29 May 2014, at 10:59am, big stone wrote: > I would like to save my sqlite ':memory:' database into a sql command text > file. There are no functions built into SQLite which turn schema or data into SQL commands. The Shell Tool can do it, but the code which does it

[sqlite] Creating a 'SQL text' Backup of a SQlite database with the mere sqlite.dll tool (and a Python 3)

Hello, I would like to save my sqlite ':memory:' database into a sql command text file. With sqlite.dll, what is the procedure/algorithm ? Is it already explained somewhere on Internet ? At first look, I may imagine that I need to : - create tables in a certain order (keeping the comments for

Re: [sqlite] Comments loss in sqlite_master table

The parallel usage would be a bonus if sqlite with threads could in the future be instructed to use more available cores on the system. On Thu, May 29, 2014 at 10:46 AM, big stone wrote: > Hi Domingo, > > Oracle is doing also this sort of things with there / * parallel */

Re: [sqlite] Comments loss in sqlite_master table

Hi Domingo, Oracle is doing also this sort of things with there / * parallel */ comment keyword. For example : http://docs.oracle.com/cd/E11882_01/server.112/e25523/parallel002.htm#i1006328 ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] New DLLs and sources. Was: SQLite version 3.8.5 beta

On Wed, May 28, 2014 at 9:43 PM, Richard Hipp wrote: > On Wed, May 28, 2014 at 1:20 PM, jose isaias cabrera > wrote: > > > > > 3. Is there a spot anywhere that has clear steps on creating the Sqlite3 > > DLL? > > > >

Re: [sqlite] New DLLs and sources. Was: SQLite version 3.8.5 beta

On Wed, May 28, 2014 at 8:09 PM, Richard Hipp wrote: > On Wed, May 28, 2014 at 12:56 PM, jose isaias cabrera < > cabr...@wrc.xerox.com > > wrote: > > > > > Just noticed something... It may be nothing, but the MinGW built DLL has > > a size of 645KB while the MSVC built one has

Re: [sqlite] Comments loss in sqlite_master table

Hi Dan, You're right : situation is much better than what I thought. I ddid a more complete check, switching from sqlite.exe 3.8.3 to sqlite.dll 3.8.4.3 create /*this */ -- really table /* is */ toty( -- for /* truly */ x --educative ) /*purpose */ -- and comment hunting ; select sql from

Re: [sqlite] Comments loss in sqlite_master table

Here is a link to a document describing the "COMMENT" syntax http://docs.oracle.com/cd/B12037_01/server.101/b10759/statements_4009.htm#i2119719 On Thu, May 29, 2014 at 10:34 AM, Domingo Alvarez Duarte wrote: > Hello all ! > > Now that we are talking about comments in sql

Re: [sqlite] Comments loss in sqlite_master table

Hello all ! Now that we are talking about comments in sql statements why not extend sqlite to accept the "COMMENTS" keyword for fields and tables and then we will have a standard way to store extra information about our sql schema. Cheers ! On Thu, May 29, 2014 at 10:10 AM, Luuk

Re: [sqlite] New DLLs and sources. Was: SQLite version 3.8.5 beta

On Thu, May 29, 2014 at 3:55 AM, RSmith wrote: > > On 2014/05/28 20:26, Warren Young wrote: > >> On 5/28/2014 11:20, jose isaias cabrera wrote: >> >>> >>> I would rather have the speed >>> then the size. >>> >> >> > Rather speed than size is an Engineering decision which is

Re: [sqlite] Comments loss in sqlite_master table

On 29-5-2014 11:00, Dan Kennedy wrote: On 05/29/2014 03:42 PM, big stone wrote: Hello, I miss the functionnality of some other sql motors that keep the comments inside an object definition, like a table. This sounds quite illogical, as : - Newlines and spaces are kept, (if not around

Re: [sqlite] Comments loss in sqlite_master table

On 05/29/2014 03:42 PM, big stone wrote: Hello, I miss the functionnality of some other sql motors that keep the comments inside an object definition, like a table. Example : (with sqlite.exe 3.8.3) create table /* This table has an educative purpose */ toto(x); create table /* This table has

Re: [sqlite] Comments loss in sqlite_master table

On Thu, May 29, 2014 at 10:48 AM, Luuk wrote: > According to this: > http://www.sqlite.org/lang_createtable.html > > The comment is not part of the 'full statement'. According to the grammar charts, comments can't appear at all. Comments being allowed to appear is

Re: [sqlite] Comments loss in sqlite_master table

Hi Luuk, You're right : there is also a problem of consistency with documentation . Neither the spaces around 'x' in 'toty( x )' are in the documentation,but SQLite kept those useless spaces anyway. ___ sqlite-users mailing list

Re: [sqlite] Comments loss in sqlite_master table

On 29-5-2014 10:42, big stone wrote: Hello, I miss the functionnality of some other sql motors that keep the comments inside an object definition, like a table. Example : (with sqlite.exe 3.8.3) create table /* This table has an educative purpose */ toto(x); create table /* This table has an

[sqlite] Comments loss in sqlite_master table

Hello, I miss the functionnality of some other sql motors that keep the comments inside an object definition, like a table. Example : (with sqlite.exe 3.8.3) create table /* This table has an educative purpose */ toto(x); create table /* This table has an educative purpose */