Re: [sqlite] Best practices for dealing with password protected database

Hello Bernd! I have a very limited knowledge about such matters, but it seems to me there is a caveat in the whole area of using encrypted data on a end-user pc; For your .NET application to use the, DB it must first decrypt it; That means, storing the plain version in ram; A memory dump will

Re: [sqlite] C API docs

hi Perhaps it widely popular doxygen, although its just a guess Eugene 2011/10/24 Baruch Burstein > How are the C API documents auto-generated? Which tool is used? > I see that they are all in the comments in the code, but couldn't find a > tool in the source that is used

Re: [sqlite] database like ms northwind

As i understand it, Northwind is simply an example of Ms access (populated db). So, if you need an example of access, buy access and you get Northwind; If, on the other hand, you dont buy it, you cant use access at all (unless by broking the law); If you are looking for something like Northwind

Re: [sqlite] How about a proper forum rather than an e-mail list

People might think that nothing will change if we move to a forum; Yet there is a great difference between a letter (though its email, not paper) and a forum post; Letters are usually more formal, more tidy, without spam and trolling; A forum post and a forum itself is completely different

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

Mailing list is the one true way; Look what IT forums turn into eventually... The only way to maintain high level of responsibility and seriousness of discussion is, alas, a mailing list 2011/10/18 John Drescher > My biggest reason for wanting a mailing list versus a forum

Re: [sqlite] max id mystery

Hello, thanks for many corrections and suggestions; I am new to php, so i was under the impression it had sqlite3 (now i see why i cant edit my db from sqlite3 shell); i understand that my approach is not right ( is shouldn't emulate primary key again) the problem is (at least i think it is) in

[sqlite] max id mystery

Hello dear comrades! I hope together we will be able to shed some light on a rather mysterious occurrences which are plaguing me for the past few days; I have an sqlite3 db that stores user-accounts (each user has an id); When a new user wants to add his account to db, he sends all his data

Re: [sqlite] storing big numbers into NUMERIC, DECIMAL columns

Hi I find the discussion very interesting. Apart from billing/accounting every good (scientific) application soones or later is bound to requare multiprecision library. The best way, as was stated above, would be to use blobs, as it would allow to dispance with all in/out converting (in case of

Re: [sqlite] SQLlite3 error

Hi In the old day, people used to bring up a debugger and find what function was misbehaving at this particular offset. As to the cause of the error, it can be a version-mismatch perhaps? Eugene 2011/3/19 > Hey fellows, > I m new to sql3 users list and i m

Re: [sqlite] strange UB detected

Thanks! I forgot about C array numeration... Sorry for being an arse. Eugene 2011/3/13 Drake Wilson <dr...@begriffli.ch> > Quoth Eugene N <neverov.biks.0...@gmail.com>, on 2011-03-13 18:14:49 > +0200: > > uchar* pblah[1]; > > > > pblah[0] = (uchar*)m

[sqlite] strange UB detected

Hi I detected a strange "feature" of sqlite3. Somebody called it Pointer Liberation army strike. uchar* pblah[1]; pblah[0] = (uchar*)malloc(10); pblah[1] = (uchar*)malloc(10); // notice the order sqlite3* db; // this call magically kills pblah[1] by making it 0x0 int ret =

Re: [sqlite] Fwd: database collision detection

Thank you all, Learning is such a joy when people are helpful :) Eugene 2011/3/11 Teg > Hello Eugene, > > How about initally attempting the fetch and if that fails, do the > insert? Since the results of a duplicate means you want the two > additional blobs anyway. > > Select so

[sqlite] Fwd: database collision detection

Hello I am just beginning my thorn-ridden way up the steep slope with SQLite and C++ to keep me company. And i am stuck at one point, so if you could help me to continue it would be awsome. I have a database contaning a table with a layout like this: NAME PART1 PART2 blobblob