Re: [sqlite] Encoding Question

This is base64. Christian ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite profiler

> Maybe, what is it? http://en.wikipedia.org/wiki/Profiling_(computer_programming) Cheers, Christian ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

AW: [sqlite] Transaction journal corrupted by antivirus

> The problem is my application is used by thousand of customers. > I cannot ask them to tweak their antivirus. Why don't you encrypt the message content before storing? Christian - To unsubscribe, send email to [EMAIL

AW: [sqlite] Still getting "Insertion failed because database isfull." errors

> the database residing on removable media. When the system returns, the > "pointer" to the media is not guaranteed to work again. In other words, The file handle remains perfectly valid when the media has not been removed or changed. Besides, I've observed that sometimes the media is not

AW: [sqlite] Still getting "Insertion failed because database is full." errors

Hello Joel! We were faced with similar problems in the field, too. Those were more general ones with PCMCIA/CF/SD cards. The reason was that the mobile devices (different device types with Windows CE 4.1 and 5.0) doesn't handle the access to removable media gracefully when the device is going to

AW: [sqlite] Obtaining randomness on win32

> randomness as you need. But I do not know how to do this on > win32 and wince. The current implementation seeds the random As Michael already suggested, you should use the CryptoAPI (CryptAquireContext, CryptGenRandom). This API is supported by all 32 bit desktop versions and by Windows CE

AW: [sqlite] Bad performance with large joins?

> >> > Have you tried creating indexes on your rows. > >> > [..] > >> > I suggest you add indexes on text_val > >> > >> Yes. I use > >> > >> create index text_val_idx on geodb_textdata(text_val); > >> > > > > This index seems pretty useless. You're querying against > > geodb_textdata.loc_id and

AW: [sqlite] Bad performance with large joins?

> > Have you tried creating indexes on your rows. > > [..] > > I suggest you add indexes on text_val > > Yes. I use > > create index text_val_idx on geodb_textdata(text_val); > This index seems pretty useless. You're querying against geodb_textdata.loc_id and geodb_textdata.text_type. So you

AW: [sqlite] Views over multiple tables and conditional selection (ticket #1134)

> Us an "AS" clause on each result column of the view in order to > assign the specific name you want to that column. That works. Many thanks! Regards, Christian

[sqlite] Views over multiple tables and conditional selection (ticket #1134)

Hello! We're getting a "no such column" SQL error executing conditional select statements using this view: CREATE VIEW ENTF as select ENTF1.new_key, ENTF1.tp_id_start, ENTF1.tp_id_ziel, ENTF2.weg_id, ENTF2.weg_rel_nr from ENTF1, ENTF2 where ENTF1.keyentf2 = ENTF2.keyentf2; These are the tables

AW: [sqlite] bug in ORDER BY ?

Does "select * from mactor order by id desc limit 1" and "select * from mactor order by id limit 1" not work? Greetings, Christian

[sqlite] index not used?

Hello, I've a pretty big table (between 800.000 and 900.000 rows) with the following schema: create table relations (rel_id_from integer, rel_id_to integer, id_old integer, id_new integer, valid_from integer, valid_to integer); create index idx_relations_idx0 on relations (valid_from,