Gee...
I started out in late 80's as a Dbase III+ coder.
Then it was the defacto DBMS on the PC.
Wonder if it still relevant in any serious application in these days.
regards
Nataraj
On Mon, Sep 2, 2013 at 11:58 AM, Darren Duncan wrote:
> I don't think that being ACID and SQL compliant is the d
Hi, C M,
Im Auftrag von C M
> On Sun, Sep 1, 2013 at 4:28 PM, jose isaias cabrera
> wrote:
> > "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 datab
I don't think that being ACID and SQL compliant is the definition of a DBMS, far
from it. While it is true that typically anything which is ACID and SQL
compliant is a DBMS, lots of things can be a DBMS without being either ACID or
SQL compliant. See dBASE for example. -- Darren Duncan
On 20
Hi,
Im Auftrag von Tiago Rodrigues
[...]
> It's not that "everyone in Windows programming expects everything to be a
> DLL"; this is an overgeneralisation. After all, Java isn't exactly Windows-
> only code and we're not dealing with Win32, but with IBM zOS.
> However, think a bit on the problem
Hi,
Im Auftrag von uncle.f
> Hello all,
>
> I have a process that runs 24/7 and permanently inserts data into an SQLite
> database:
>
> 1) Create new database at midnight, keep it open for writing for the next
> 24 hours
> 2) There are no deletions and not even reads during the database creatio
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
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-
> 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
> > 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 t
> 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
>
Hi, Joseph,
On Sun, Sep 1, 2013 at 6:21 PM, Joseph L. Casale
wrote:
> > Hi,
> > Can you do "DESCRIBE QUERY PLAN " 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
> 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 compariso
> 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, va
> Hi,
> Can you do "DESCRIBE QUERY PLAN " 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
On 2 Sep 2013, at 2:03am, Joseph L. Casale 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 '=' will definitely work the wa
Hi,
Can you do "DESCRIBE QUERY PLAN " 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
wrote:
> I have a query that is unbearable at scale, for example when
> s_table_a and
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
-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, Rich
-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
On 1 Sep 2013, at 10:34pm, 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
Does the cursor object have propert
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 wrote:
> On Sun, Sep 1, 2013 at 1:38 PM, Richard Hipp wro
On Sun, Sep 1, 2013 at 4:28 PM, jose isaias cabrera
wrote:
>
> "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 machi
On Sun, Sep 1, 2013 at 2:23 PM, Simon Slavin wrote:
>
> On 1 Sep 2013, at 6:38pm, Richard Hipp 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
On Sun, Sep 1, 2013 at 1:38 PM, Richard Hipp wrote:
> On Sun, Sep 1, 2013 at 1:12 PM, C M 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,
> >
>
>
"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?
___
sqli
On 1 Sep 2013, at 6:38pm, Richard Hipp 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 of the call th
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.
Dependin
On Sun, Sep 1, 2013 at 1:12 PM, C M 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 doing when
th
Am 01.09.2013 17:50, schrieb Clemens Ladisch:
Without a random IV/nonce, every page is guaranteed to encrypt to the
same data if the contents and the key have not changed. Thus, wxSQLite3
gives an attacker the ability to determine whether any particular page
has changed, by comparing the old and
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 S
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
To: Gener
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 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 to warn the OP th
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
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
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 co
Am 31.08.2013 22:01, schrieb Etienne:
On Sat, 31 Aug 2013 17:17:23 +0200
Etienne 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, no?
"nonce", "IV",
tOn Sun, 1 Sep 2013 12:34:02 +0200, Paolo Bolzoni
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
Probably not
> but he d
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 wrote:
>
> On 1 Sep 2013, at 5:39
On 1 Sep 2013, at 5:39am, kimtiago 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
http://sqlite.org:8080/c
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
> Hi,
>
> I need to know if SQLite is a DBMS and why.
>
> Please its urgent.
>
>
>
> --
> View this message in conte
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 l
41 matches
Mail list logo