Again a disclaimer: I use SQlite often e.g. for continuous testing and
in Desktop Apps. - and I like it as it is except for it's homepage
declaration and (more formally) for it kind of weak typing (meaning
'weak' compared to the information schema).
Weak typing in databases assigns the house keepi
Hello there,
I hope this isn't going to too wide a dist-list. If it is, let me apologise
now. Sorry ;-)
I needed to write a read-only viewer for SQLite. It's intention is to allow my
"power users" to see the various tables, triggers and views but not be able to
do anything with them. I know th
Am 11.02.2011 22:55, schrieb Paul Moore:
> paul@paul-suse:~/build/TRUNK/external/build/sqlite-tea-3070500> make
> gcc -DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TARNAME=\"sqlite\"
> -DPACKAGE_VERSION=\"3.7.5\" -DPACKAGE_STRING=\"sqlite\ 3.7.5\"
> -DPACKAGE_BUGREPORT=\"\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPE
Hello
My problem is no matter how i build sqlite - my binary is much slower than
the precompiled one on sqlite download page (about 3 - 6 times depending on
the query).
I am using sqlite3.h and sqlite3.c from the amalgamation source:
http://www.sqlite.org/sqlite-amalgamation-3070602.zip
I have
mhnSqlite wrote:
> I am attempting to copy records from one table to another. The following
> statement is what i see everywhere when I google how to do this, yet it does
> not work.
> I am using the following:
> Select field1, field2 into {newly created table} from {existing table with
> lotsa re
On 18 Apr 2011, at 10:20am, Stefan Keller wrote:
> Simon wrote:
>> Stefan, please read this:
>> http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
>
> Thank you for the weblink.
> Here are some citations from it which could be of interest to you too
> (see below).
> I don't think SQLite s
That's the nice thing about standards...there's so many to choose from :-)
Michael D. Black
Senior Scientist
NG Information Systems
Advanced Analytics Directorate
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Simon Sl
Good day,
What happens if you insert more than your RAM size into an in memory
database?
(I'm particularly interested in the Windows context).
regards,
Adam
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/lis
Hello,
I have problems with a specific query when using the "sqlite3_step"
function:
SELECT DISTINCT interfaces_int_id,device_dev_id FROM devInterface
INNER JOIN interfaces ON
devInterface.interfaces_int_id=interfaces.intf_id
INNER JOIN nlink ON nlink.interfaces_intf_id=inte
You won't be able to insert. The statement will fail.
Pavel
On Mon, Apr 18, 2011 at 9:44 AM, Adam DeVita wrote:
> Good day,
>
> What happens if you insert more than your RAM size into an in memory
> database?
> (I'm particularly interested in the Windows context).
>
> regards,
> Adam
>
> Depending on the database size, it sometimes takes minutes to get a result.
> But when using the Firefox plugin "SQLite Manager", it "only" takes 1-2
> seconds.
>
> I use SQLITE Version 3.6.22.
Maybe SQLite Manager uses newer version of SQLite? Try to execute in
it "SELECT sqlite_version()"
Hello Pavel,
thank you for your answer. SQLite Manager uses version 3.7.4, but I
checked the SQLite release notes and I could not find changes for
sqlite3_step. Should I upgrade anyway?
Thanks,
Mathias
On Mon 18/04/11 15:49 , "Pavel Ivanov" paiva...@gmail.com sent:
> Depending on the database
Mathias Spoerr wrote:
> I have problems with a specific query when using the "sqlite3_step"
> function:
>
>SELECT DISTINCT interfaces_int_id,device_dev_id FROM devInterface
>
>INNER JOIN interfaces ON
> devInterface.interfaces_int_id=interfaces.intf_id
>
>INNER JOIN nlink ON nlink.i
Hi,
My name is Khanh Nguyen and currently using SQLite3.DLL 3.7.6 in my
application (DLL built with VS2008 C++ with this flag: Multi-threaded Debug
DLL (/MDd). This DLL is called by other DLL via GetProcAddress to access a
blob database. The access and blob database is in very good operation.
Ho
Hello Igor,
this is not the complete query - only the part which causes the problem.
The complete query is:
SELECT DISTINCT interfaces_int_id,device_dev_id FROM devInterface
INNER JOIN interfaces ON devInterface.interfaces_int_id=interfaces.intf_id
INNER JOIN nlink ON nlink.interfaces_intf_id=i
> I checked
> the SQLite release notes and I could not find changes for sqlite3_step.
> Should I upgrade anyway?
Did you notice in release notes something like "optimizer
improvements"? That's what impacts the sqlite3_step performance.
Pavel
On Mon, Apr 18, 2011 at 9:54 AM, Spoerr Mathias wro
the
last Optimizer enhancement was with 3.6.22
http://www.sqlite.org/changes.html
Thanks,
Mathias
On Mon 18/04/11 16:05 , "Pavel Ivanov" paiva...@gmail.com sent:
> I checked
> the SQLite release notes and I could not find changes for
sqlite3_step.
> Should I upgrade anyway?
Did you notice i
Ummm...are we forgetting about swap space?
If you exceed RAM you hit swap. If you exceed RAM+SWAP you start failing.
Or does sqlite monitor physical memory usage?
So if you exceed RAM you just start slowing down towards a disk-based equialent
database.
Michael D. Black
Senior Scienti
Dear list members,
I was surprised to find out that indices are not used in expressions of
the form 'column is value' in contrast to 'column=value' or 'column is
null'. Compare the following example:
create table test (id integer primary key, val double);
insert into test (val) values(r
On 18 Apr 2011, at 2:44pm, Adam DeVita wrote:
> What happens if you insert more than your RAM size into an in memory
> database?
Windows doesn't really keep all its memory in actual RAM. It uses a 'page
file' to allow it to send data it's not actually using right now to disk, and
call it back
Did you try doubling the apostrophes?
*Goin'' Down the Road Feelin'' Bad*
On 4/17/2011 6:16 PM, Simon Slavin wrote:
> On 17 Apr 2011, at 11:54pm, Alan Holbrook wrote:
>
>> I'm using SQLite with VBE2008. I've defined a table with a number of text
>> fields in it. If the information I want to wr
OK, sorry I didn't tell you all possible word combinations to look
for. It looks like release notes use "query planner" instead of
"optimizer".
Pavel
On Mon, Apr 18, 2011 at 10:09 AM, Spoerr Mathias wrote:
> the last Optimizer enhancement was with 3.6.22
> http://www.sqlite.org/changes.html
>
Hello
I have a table with a primary key consisting of three columns: Book, Chapter,
Verse.
I'd like to produce a results set that contains 1 row for each chapter of each
book, showing the total verses in that chapter.
I know enough SQL to know I can get the total number of verses in a chapter
On Mon, Apr 18, 2011 at 08:45:49AM -0700, Danny scratched on the wall:
> Hello
>
> I have a table with a primary key consisting of three columns: Book,
> Chapter, Verse.
>
> I'd like to produce a results set that contains 1 row for each chapter of
> each book, showing the total verses in that
Hello Pavel,
I now upgraded to 3.7.6.2 and it is much better now!
Thank you very much for your help!
Regards,
Mathias
On Mon 18/04/11 17:06 , "Pavel Ivanov" paiva...@gmail.com sent:
OK, sorry I didn't tell you all possible word combinations to look
for. It looks like release notes use "query
On 18 Apr 2011, at 4:52pm, Jay A. Kreibich wrote:
> SELECT book, chapter, count(verse) AS total_verses
>FROM scripture
>GROUP BY 1, 2;
Just for clarity, since he's still learning, I might suggest instead
SELECT book, chapter, count(verse) AS total_verses
FROM scripture
GROUP
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/18/2011 02:20 AM, Stefan Keller wrote:
> for it kind of weak typing (meaning
> 'weak' compared to the information schema).
SQLite's typing is not weak. YOU GET BACK OUT WHAT YOU PUT IN. I'd argue
other implementations are the problem since the
Thanks to all for all the suggestions. Doubling up the apostrophe worked.
On Mon, Apr 18, 2011 at 10:55 AM, Jim Morris wrote:
> Did you try doubling the apostrophes?
>
> *Goin'' Down the Road Feelin'' Bad*
>
>
> On 4/17/2011 6:16 PM, Simon Slavin wrote:
> > On 17 Apr 2011, at 11:54pm, Alan Holb
Thanks everyone. That was so easy it was embarrassing! :)
--- On Mon, 4/18/11, Simon Slavin wrote:
> From: Simon Slavin
> Subject: Re: [sqlite] SELECT help for newbie
> To: j...@kreibi.ch, "General Discussion of SQLite Database"
>
> Date: Monday, April 18, 2011, 1:06 PM
>
> On 18 Apr 2011,
Bug report is here
http://www.mail-archive.com/sqlite-users@sqlite.org/msg59442.html
The fix is here
http://sqlite.mobigroup.ru/fdiff?v1=e7d3fea30c80e2f3&v2=f7d463b30fd7d54f
I'm frustrated with no upstream fix of segfault in core extension :(
--
Best regards, Alexey Pechnikov.
http://pechnikov.t
Newbie here. i'm trying to insert multiple values into a table by a certain
date and when I use where clause it fails. This is my code "insert into db
(table) values ('value') where date = 'date range'". Thanks for any help.
--
View this message in context:
http://old.nabble.com/insert-help-t
>Newbie here. i'm trying to insert multiple values into a table by a
>certain
>date and when I use where clause it fails. This is my code "insert
>into db
>(table) values ('value') where date = 'date range'". Thanks for any help.
There is no where clause in insert statements, it wouldn't mak
32 matches
Mail list logo