[sqlite] System.Data.SQLite.Core and Core-Linux version Mismatch [nuget]

install a previous version of SQLite.Core. What is the suggested path forward? -- Jonathon K. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Many ML emails going to GMail's SPAM

tes 100% of the spam out there. Unfortunately, it also eliminates at least 70% of the legitimate email out there. jonathon signature.asc Description: OpenPGP digital signature ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org h

Re: [sqlite] Typical suffixes of sqlite database files

n 3 and 5 suffixes for the SQLite databases that they utilize. Use the magic number. Much more reliable, easier to maintain, and less chance of a false positive. jonathon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org h

Re: [sqlite] Whish List for 2015

ps, will be migrated to SQLite 3.x. jonathon ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] New kids on block the SQLite Master Suite.

resulting issues.) jonathon signature.asc Description: OpenPGP digital signature ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Strategies for protecting sql queries

Hello, I am using a sqlite database to store/retrieve sensitive information. I am currently encrypting the database to secure the actual data, but I am still concerned about my actual sql statements. The sql statements themselves are left in plaintext in memory so if someone was ambitious

Re: [sqlite] Sqlite and OpenOffice

y being used. jonathon ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug in SQLITE? "Joins + Order By" Changing row count!?!

for now, I am just leaving my original query inside the subquery to fix it. However, I wouldn't mind posting some debugging information if it will help fix the bug. Thanks, J On Tue, Mar 3, 2009 at 8:23 PM, Dan <danielk1...@gmail.com> wrote: > > On Mar 4, 2009, at 4:41 AM, Jo

[sqlite] Bug in SQLITE? "Joins + Order By" Changing row count!?!

Hello, I am executing a query such as: 1. SELECT * FROM tableA a INNER JOIN tableB b INNER JOIN tableC c INNER JOIN tableD d LEFT JOIN tableE ON a.b_id = b.id AND a.c_id = c.id AND a.d_id = d.id AND c.e_id = e.id; 2. 3. CREATE TABLE tableA ( 4. id INTEGER NOT NULL

Re: [sqlite] Exporting database to CSV file

Thanks for the replies... Actually, it seems my requirements have changed.. Is there a way to do this entirely through php? I would like to make a query on a table and write the results to a csv file so that the user can have the option of downloading it. Has anyone ever done something similar

Re: [sqlite] Exporting database to CSV file

; > -deech > > On Mon, Jan 5, 2009 at 4:21 PM, Jonathon <thejunk...@gmail.com> wrote: > > > Hello all, > > > > I am interested in exporting a particular table to a CSV file. I've > > browsed > > google for a bit, but all I could find is third part

[sqlite] Exporting database to CSV file

Hello all, I am interested in exporting a particular table to a CSV file. I've browsed google for a bit, but all I could find is third party programs. I was hoping this functionality was provided in sqlite and that it was super duper fast :) Thanks! J

Re: [sqlite] Creating Histogram fast and efficiently :)

gt; sqlite> select case when val < 10 then 1 when val >=10 and val < 20 > then 2 else 3 end as bin, >...> count(1) as c >...> from numbers group by bin; > 1|2 > 2|4 > 3|3 > > > On Dec 31, 2008, at 6:16 AM, Jonathon wrote: > > > Hel

[sqlite] Creating Histogram fast and efficiently :)

Hello all, I have a column of numbers in a table, and I was wondering if it is possible to create a histogram out of it fast and efficiently? For example, assuming the data in the column is: 1, 5, 10, 12, 12, 15, 20, 20, 20.. I would like to return: 'less than 10' --> 2 'less than 20 and

[sqlite] Convert integer IP address to string IP address in Sqlite

Hello all, I was just curious if there is a way to convert an integer representation of an IP address that I store in my DB, to it's string equivalent (xxx.xxx.xxx.xxx)? I would also need to convert it to host-byte order as well. Thanks, J ___

[sqlite] Seeking documentation on writing own Tokenizer

Hello all, I am interested in writing my own tokenizer for sqlite3. I've gone through Google, as well as the sqlite documentation and unfortunately, I haven't found anything helpful. I am interested in writing my own tokenizer so that I could perform "partial string" matches in sqlite's

Re: [sqlite] Quick FTS3 question: partial matches

already been solved for me, and I really don't want to reinvent the wheel if it already has been done :) Thanks, Jon On Thu, Oct 9, 2008 at 9:51 PM, Jonathon <[EMAIL PROTECTED]> wrote: > Thanks for the reply. I was just curious if anyone has found a viable > workaround for this i

Re: [sqlite] Quick FTS3 question: partial matches

Thanks for the reply. I was just curious if anyone has found a viable workaround for this issue? Using the dreaded "Like" is a bit too slow for what I need. Jon On Thu, Oct 9, 2008 at 8:50 PM, Alexandre Courbot <[EMAIL PROTECTED]> wrote: > > I would like to look up partial strings across

[sqlite] Quick FTS3 question: partial matches

Hello all, I've looked through the archived mailing list and although I am sure my question is common, for some reason, I couldn't find an answer. I would like to look up partial strings across several columns using FTS3 and MATCH. For example, if I have a column that has data,

Re: [sqlite] How does SQLite store data?

? * only returns the first 80 characters in the field? * stores and returns the entire string? My impression was that it did that third option. [And that it didn't care what the data in that field was. It is up to the client program to verify the data.] xan jonathon

Re: [sqlite] Release / development timeline

ate for upgrades? Something like Version 3.0.9 beta 10 November Version 3.0.9 final 20 November Version 3.0.10 beta 1 December Version 3.0.10 final 15 December xan jonathon -- How to have Hittite, Alibata, Orkhon, Ogham, Manchu, Meroïtic, Pahawh Hmong, Tengwar, Tsalagi, Han

[sqlite] Release / development timeline

All: I've hunted around on sqlite.org, and the mailing list archives, [and googled] for a timeline of when the next version9s) of SqLite will be released. Does such a critter exist, and if so, where can I find it? xan jonathon -- How to have Hittite, Alibata, Orkhon, Ogham, Manchu, Meroïtic