he Linux package nor 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
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
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
ng setups, 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
o fix any 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
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 enough,
tually
being used.
jonathon
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 wrote:
>
> On Mar 4, 2009, at 4:41 AM, Jonathon wrote:
>
> >
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
Hello All,
I have a simple query that seems to be going very very very slow. I am not
sure why sqlite is behaving this way, which is why I decided to burden you
guys with my question. My guess is that the query optimizer might not be
able to decipher what exactly I want to do, and thus computes
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
t
Awesome. Thanks for the quick reply Deech :)
J
On Mon, Jan 5, 2009 at 2:34 PM, aditya siram wrote:
> Open the sqlite database using:
> > sqlite3 database.sqlite
> >> .mode csv
> >> .output yourfilename
> >> your-sql -query
>
> -deech
>
>
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
__
0 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:
>
> > Hello all,
> >
> > I have a
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 greate
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-u
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 full-tex
eems as if this problem should have 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
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 seve
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,
'helloThisIsATes
?
* 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
jon
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
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, Mer
23 matches
Mail list logo