[sqlite] Is SQLite a DBMS?

2013-09-01 Thread kimtiago
Hi, I need to know if SQLite is a DBMS and why. Please its urgent. -- View this message in context: http://sqlite.1065341.n5.nabble.com/Is-SQLite-a-DBMS-tp70868.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing

Re: [sqlite] Is SQLite a DBMS?

2013-09-01 Thread Stefan Keller
Hi, Wikipedia answers with yes and why (= because it's ACID and SQL compliant) within the first three sentences! http://en.wikipedia.org/wiki/SQLite Yours, S. 2013/9/1 kimtiago kimti...@gmail.com Hi, I need to know if SQLite is a DBMS and why. Please its urgent. -- View this message

Re: [sqlite] Is SQLite a DBMS?

2013-09-01 Thread Simon Slavin
On 1 Sep 2013, at 5:39am, kimtiago kimti...@gmail.com wrote: I need to know if SQLite is a DBMS and why. That's okay. Just have your teacher post here and we'll tell them directly. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Is SQLite a DBMS?

2013-09-01 Thread Paolo Bolzoni
Wait a second, this is a mailing list where you need to register to write. Isn't it? It means the OP actually registered but he did not try to seek for wikipedia sqlite in google? It is just me or it is quite weird? On Sun, Sep 1, 2013 at 12:23 PM, Simon Slavin slav...@bigfraud.org wrote: On

Re: [sqlite] Is SQLite a DBMS?

2013-09-01 Thread Kees Nuyt
tOn Sun, 1 Sep 2013 12:34:02 +0200, Paolo Bolzoni paolo.bolzoni.br...@gmail.com wrote: Wait a second, this is a mailing list where you need to register to write. Isn't it? Yes, but he appears to have posted from nabble. I guess nabble has a subscription. It means the OP actually registered

Re: [sqlite] to encrypt sqlite db

2013-09-01 Thread Ulrich Telle
Am 31.08.2013 22:01, schrieb Etienne: On Sat, 31 Aug 2013 17:17:23 +0200 Etienne etienne.sql...@mailnull.com wrote: On the other hand removing patterns definitely cannot hurt. Precisely. The very first bytes of SQLite files are, AFAIK, well known. That's what salt is for,

Re: [sqlite] to encrypt sqlite db

2013-09-01 Thread Mohit Sindhwani
On 31/8/2013 9:52 PM, dd wrote: Thank you for your quick response. I am looking for freeware. If freeware not available, I have to implement encryption support for sqlite on winrt. What is the procedure to implement encryption support on winrt? Thanks, dd Many others have replied with the

Re: [sqlite] to encrypt sqlite db

2013-09-01 Thread Clemens Ladisch
Ulrich Telle wrote: Am 31.08.2013 22:01, schrieb Etienne: I simply wanted to warn the OP that wxSQLite, while free, does NOT use salts: Well, that's not completely true. The encryption extension coming with wxSQLite3 uses a different IV (initial vector) for each database page. True is that

Re: [sqlite] to encrypt sqlite db

2013-09-01 Thread Etienne
On Sun, Sep 1, 2013, at 17:50, Clemens Ladisch wrote: Ulrich Telle wrote: Am 31.08.2013 22:01, schrieb Etienne: I simply wanted to warn the OP that wxSQLite, while free, does NOT use salts: Well, that's not completely true. The encryption extension coming with wxSQLite3 uses a

Re: [sqlite] to encrypt sqlite db

2013-09-01 Thread Paolo Bolzoni
Another weird sentence in the mailing list of probably most used DB that is really free. On Sun, Sep 1, 2013 at 6:10 PM, Etienne etienne.sql...@mailnull.com wrote: On Sun, Sep 1, 2013, at 17:50, Clemens Ladisch wrote: Ulrich Telle wrote: Am 31.08.2013 22:01, schrieb Etienne: I simply wanted

Re: [sqlite] to encrypt sqlite db

2013-09-01 Thread Etienne
wxSQLite (relevant part) and SEE are extensions to SQLite. wxSQLite is free, while SEE is definitively not. wxSQLite means pseudo encryption (as formerly discussed), while SEE is real encryption. What is weird??? Regards, Etienne - Original message - From: Paolo Bolzoni

[sqlite] help needed for major SQLite problem

2013-09-01 Thread C M
Keeping it simple: I have a Python application that uses SQLite, and I randomly get this error: SQL logic error or missing database I have no idea how to figure out what's wrong, and if I can't figure it out, it leaves a huge deal-breaking bug in my application, such that I'd have to abandon

Re: [sqlite] help needed for major SQLite problem

2013-09-01 Thread Richard Hipp
On Sun, Sep 1, 2013 at 1:12 PM, C M cmpyt...@gmail.com wrote: I have a Python application that uses SQLite, and I randomly get this error: SQL logic error or missing database I have no idea how to figure out what's wrong, A good starting place might be to tell us what the program is

Re: [sqlite] to encrypt sqlite db

2013-09-01 Thread Ulrich Telle
Am 01.09.2013 18:40, schrieb Etienne: wxSQLite is free, while SEE is definitively not. The original poster searched for a free encryption extension, of which there exist several: System.Data.SQLite (RC4), wxSQLite3 (AES-128 or AES-256), SQLCipher (AES-256 with nonce) to name a few.

Re: [sqlite] help needed for major SQLite problem

2013-09-01 Thread Simon Slavin
On 1 Sep 2013, at 6:38pm, Richard Hipp d...@sqlite.org wrote: A good starting place might be to tell us what the program is doing when the error comes back. As well as telling us the call that trieggers the error, please put logic into your program so that it not only checks the result code

Re: [sqlite] help needed for major SQLite problem

2013-09-01 Thread jose isaias cabrera
C M wrote... Keeping it simple: I have a Python application that uses SQLite, and I randomly get this error: SQL logic error or missing database Is the database in network drive or not in the same machine that is running the app? ___

Re: [sqlite] help needed for major SQLite problem

2013-09-01 Thread C M
On Sun, Sep 1, 2013 at 1:38 PM, Richard Hipp d...@sqlite.org wrote: On Sun, Sep 1, 2013 at 1:12 PM, C M cmpyt...@gmail.com wrote: I have a Python application that uses SQLite, and I randomly get this error: SQL logic error or missing database I have no idea how to figure out

Re: [sqlite] help needed for major SQLite problem

2013-09-01 Thread C M
On Sun, Sep 1, 2013 at 2:23 PM, Simon Slavin slav...@bigfraud.org wrote: On 1 Sep 2013, at 6:38pm, Richard Hipp d...@sqlite.org wrote: A good starting place might be to tell us what the program is doing when the error comes back. As well as telling us the call that trieggers the error,

Re: [sqlite] help needed for major SQLite problem

2013-09-01 Thread C M
On Sun, Sep 1, 2013 at 4:28 PM, jose isaias cabrera cabr...@wrc.xerox.comwrote: C M wrote... Keeping it simple: I have a Python application that uses SQLite, and I randomly get this error: SQL logic error or missing database Is the database in network drive or not in the same

Re: [sqlite] help needed for major SQLite problem

2013-09-01 Thread Richard Hipp
Does Python have an interface to the error and warning log mechanism of SQLite? (http://www.sqlite.org/errlog.html) Can you turn that on? It will probably give more details about what it happening. On Sun, Sep 1, 2013 at 5:32 PM, C M cmpyt...@gmail.com wrote: On Sun, Sep 1, 2013 at 1:38 PM,

Re: [sqlite] help needed for major SQLite problem

2013-09-01 Thread Simon Slavin
On 1 Sep 2013, at 10:34pm, C M cmpyt...@gmail.com wrote: Do you know how I can do that with Python? For example, I tried this: status = cursor.execute(some SQL statement here) print The status is: , status But it prints the cursor object: The status is sqlite3.Cursor object at

Re: [sqlite] help needed for major SQLite problem

2013-09-01 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/09/13 14:34, C M wrote: Do you know how I can do that with Python? For example, I tried this: status = cursor.execute(some SQL statement here) print The status is: , status But it prints the cursor object: The status is

Re: [sqlite] help needed for major SQLite problem

2013-09-01 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 He needs to give the exception traceback which will show what is happening at the time. A common mistake with newish Python programmers is to catch all exceptions, and then keep going which also hides the exception tracebacks. On 01/09/13 15:12,

[sqlite] Query problems

2013-09-01 Thread Joseph L. Casale
I have a query that is unbearable at scale, for example when s_table_a and s_table_b have 70k and 1.25M rows. SELECT s.id AS s_id ,s.lid AS s_lid ,sa.val AS s_sid ,d.id AS d_id ,d.lid AS d_lid FROM s_table_b sa JOIN d_table_b da ON ( da.key=sa.key

Re: [sqlite] Query problems

2013-09-01 Thread Igor Korot
Hi, Can you do DESCRIBE QUERY PLAN your_query and post results here? Also, what do you mean by unbearable at scale? Did you measure it? What is the result? Thank you. On Sun, Sep 1, 2013 at 6:03 PM, Joseph L. Casale jcas...@activenetwerx.comwrote: I have a query that is unbearable at scale,

Re: [sqlite] Query problems

2013-09-01 Thread Simon Slavin
On 2 Sep 2013, at 2:03am, Joseph L. Casale jcas...@activenetwerx.com wrote: I am using LIKE as the columns are indexed NOCASE and I need the comparison case insensitive. Have you tried using '=' ? Also if you declare the columns as COLLATE NOCASE in your table definition, then using '='

Re: [sqlite] Query problems

2013-09-01 Thread Joseph L. Casale
Hi, Can you do DESCRIBE QUERY PLAN your_query and post results here? Also, what do you mean by unbearable at scale? Did you measure it? What is the result? Thank you. It doesn't finish with maybe 4 or 5 hours run time. Sorry, do you mean explain query plan ...? 0 0 1

Re: [sqlite] Query problems

2013-09-01 Thread Joseph L. Casale
Have you tried using '=' ? Also if you declare the columns as COLLATE NOCASE in your table definition, then using '=' will definitely work the way you want it to. An example would be CREATE TABLE myTable (myName TEXT COLLATE NOCASE) Simon. I did and it excluded the comparisons whose

Re: [sqlite] Query problems

2013-09-01 Thread Keith Medcalf
I am using LIKE as the columns are indexed NOCASE and I need the comparison case insensitive. I suspect this is where is breaks down but I don't know enough sql to really appreciate the ways I could approach this better. LIKE is used when comparing strings with wildcards. For example, val

Re: [sqlite] Query problems

2013-09-01 Thread Igor Korot
Hi, Joseph, On Sun, Sep 1, 2013 at 6:21 PM, Joseph L. Casale jcas...@activenetwerx.comwrote: Hi, Can you do DESCRIBE QUERY PLAN your_query and post results here? Also, what do you mean by unbearable at scale? Did you measure it? What is the result? Thank you. It doesn't finish

Re: [sqlite] Query problems

2013-09-01 Thread Joseph L. Casale
LIKE is used when comparing strings with wildcards. For example, val LIKE 'abra%' (which will match 'abraCaDAbra' and 'abrakadee'. If there are no wildcards you should be using =, not LIKE. LIKE will/should always indicate that a table or index scan is required, perhaps of the whole

Re: [sqlite] Query problems

2013-09-01 Thread Joseph L. Casale
0 0 1 SCAN TABLE d_table_b AS da (~10 rows) Is this the index you referenced in you reply to Simon? Maybe you are using wrong index/column? I'll recheck, I am also reading up on indexes as they relate to optimizing queries. Could be I made a mistake. I had the same

Re: [sqlite] Query problems

2013-09-01 Thread Joseph L. Casale
Have you tried using '=' ? Also if you declare the columns as COLLATE NOCASE in your table definition, then using '=' will definitely work the way you want it to. An example would be CREATE TABLE myTable (myName TEXT COLLATE NOCASE) Simon, That took this query from not finishing in 5

Re: [sqlite] to encrypt sqlite db

2013-09-01 Thread Etienne
On Sun, Sep 1, 2013, at 19:59, Ulrich Telle wrote: Am 01.09.2013 18:40, schrieb Etienne: wxSQLite is free, while SEE is definitively not. The original poster searched for a free encryption extension, of which there exist several: System.Data.SQLite (RC4), wxSQLite3 (AES-128 or AES-256),

Re: [sqlite] to encrypt sqlite db

2013-09-01 Thread Ulrich Telle
Am 02.09.2013 06:11, schrieb Etienne: wxSQLite3 does implement AES in ECB mode Wrong. CBC mode is used. Regards, Ulrich ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users