Re: [sqlite] Date Selection

On Thu, Jun 12, 2008 at 5:50 AM, Harold Wood <[EMAIL PROTECTED]> wrote: > Hello Igor > the create table statement: > > CREATE TABLE Items > ( > ID INT NOT NULL PRIMARY KEY ASC, > SubCatId INT NOT NULL, > Description VARCHAR(60) NOT NULL, > LastUnitPrice

Re: [sqlite] SQL question

sqlite> create table t1(n,c); sqlite> insert into t1 values("a",3); sqlite> insert into t1 values("a",5); sqlite> insert into t1 values("b",7); sqlite> insert into t1 values("b",2); sqlite> select * from t1; a|3 a|5 b|7 b|2 sqlite> select n,max(c) from t1 group by n; a|5 b|7 -- [image: Just A

Re: [sqlite] How to speed up my queries?

can you post those rows with .mode insert so I can do a fast try ? Tnx. -- [image: Just A Little Bit Of Geekness] Le tre grandi virtù di un programmatore: pigrizia, impazienza e arroganza. (Larry Wall). 2008/6/4 Christophe Leske

Re: [sqlite] How to speed up my queries?

> > Can someone tell me what kind of performance one is to expect from a > 40Mb Sqlite database like the one I have? > if you put it on a floppy and throw it out of the window it fall at 9.8 m/s ... Can you give me some row of your db (also fake data are ok) so I try to populate a db with 840k

Re: [sqlite] Speed-Lost on using expression with combined "AND" and "OR"!

2008/6/4 Markus Wolters <[EMAIL PROTECTED]>: > Well why not? They've just integrated the ADO.NET provider into the DLL. > It IS SQLITE... > I have just quote what they write: "It is a complete drop-in replacement for the original sqlite3.dll" I don't know what they rewrite and how ...

Re: [sqlite] Speed-Lost on using expression with combined "AND" and "OR"!

"*System.Data.SQLite *is an enhanced version of the original SQLite database engine. It is a complete drop-in replacement for the original sqlite3.dll" If you don't use original sqlite I think you can't get any help here ... -- [image: Just A Little Bit Of

Re: [sqlite] transaction recovery question

2008/6/3 Darko Filipovic <[EMAIL PROTECTED]>: > But, what happen if journal file is deleted before starting B process? > what if a UFO stole your pc ? :-D try to delete journal file and see what happens ... ___ sqlite-users mailing list

Re: [sqlite] SQLite allows "RowID" to be the name of a column

> > The normal proper way to do what you said is to declare a table like this: > > CREATE TABLE person ( > person_id INT PRIMARY KEY, > name TEXT, > birthdate DATE > ) > > In my example, you are using only the normal data, which is the 3 columns > specified, and you are not

Re: [sqlite] Sqlite on RAM

> > > > For windows the easiest thing to do would be setting up the ram disk > and > > > store database there. > > > > easier than using :memory: ??? > > Not easier, but sometimes more useful. Using a RAM disk means going > through the OSes file manager, which adds some overhead. On the >

Re: [sqlite] SQLite allows "RowID" to be the name of a column

> > Your example doesn't counter my suggestion at all, which is to use the data > only and not a special rowid. So you put 2 identical rows in a table. > Since rows in a table are unordered, there isn't even an ordinal position > to distinguish the 2 occurrences of that same row. Since they are

Re: [sqlite] Sqlite on RAM

> > For windows the easiest thing to do would be setting up the ram disk and > store database there. easier than using :memory: ??? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite allows "RowID" to be the name of a column

> > But thinking more about hijacking "RowID" I am glad this is now a separate > thread. Lack of a reseverd "RowID" column name to guarantee unambiguous > record operations by general SQLite tools is a potential thread to data > security IMO. > > I would very much appreciate if this could be

Re: [sqlite] SQLite remote management tools?

> > I was hoping there might be a client/server management tool out there. > I would need the source code, since the server part would need to be > ported to my embedded device. > Maybe you haven't yet read this http://www.sqlite.org/serverless.html There isn't a sqlite server so you can't have a

Re: [sqlite] development vs production

2008/5/10 sebastian stephenson <[EMAIL PROTECTED]>: > > I see that sqlite is great for development but for production would > that be a bright idea? > see ya > it you develop a single user embedded sw than sqlite is a good solution, if you develop a db for a really BIG with many concurrent write

Re: [sqlite] splite database under version control (subversion)?

If you use svn only to sync over many pc maybe you can put your project on a usb device (or usb hd) so you don't need to "sync" with svn. If you WANT to use svn and you are under linux you can create an alias for commit that make a dump of your db then commit it and one alias that update and read

Re: [sqlite] splite database under version control (subversion)?

In the BIG db I have worked on there is a table that log every insert/update on specific and important tables and a log of every sql statement execute but I haven't ever see a db under version control with svn (or csv or git or any other). -- [image: Just A Little Bit Of

Re: [sqlite] Insert date

On Linux I get SQLite version 3.5.6 Enter ".help" for instructions sqlite> CREATE TABLE Sighting ( ...> SightingIdinteger PRIMARY KEY AUTOINCREMENT NOT NULL, ...> SpeciesId integer, ...> LocationIdinteger, ...> SightingDate date, ...> Note nvarchar(100)

Re: [sqlite] What is faster?

If you are under linux you can use "time" command to execute sqlite with various query and see which one is faster. -- [image: Just A Little Bit Of Geekness] Le tre grandi virtù di un programmatore: pigrizia, impazienza e

Re: [sqlite] Trigger on an attached db.

ttle Bit Of Geekness]<http://feeds.feedburner.com/%7Er/JustALittleBitOfGeekness/%7E6/1> Le tre grandi virtù di un programmatore: pigrizia, impazienza e arroganza. (Larry Wall). On Wed, Apr 23, 2008 at 3:01 PM, P Kishor <[EMAIL PROTECTED]> wrote: > On 4/23/08, Federico Granata &l

Re: [sqlite] Trigger on an attached db.

On Wed, Apr 23, 2008 at 12:22 AM, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Each connection has its own independent temp database. You've created a > temporary trigger which exists in the temp database for your connection. > The trigger simply doesn't exist on the other connection. > damn ...

[sqlite] Trigger on an attached db.

Hi, I hope this question isn't a noob one like my last one ... I have two db, the main one is used from mine sw (call this db A), the other is used from another sw (call this db B). I open A, attach B, create a temp trigger in A triggered by insert into a table in B and writing in a table in A

[sqlite] trigger and attached db

Hi, I'm trying to create in the main db a trigger on "after insert on ATTACHED_DB.TABLE" but I get an error "SQL error: trigger TEST_TRIGGER cannot reference objects in database ATTACHED_DB" Can I obtain TABLE_1 in the attached db and TABLE_2 and TRIGGER (who read from TABLE_1 and write to

[sqlite] Ruby - SQLite 3.0.7

Hi I'm looking for a sqlite 3.0.7 wrapper for ruby (nothin found with wiki). Can you help me ? -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: Biscotti perfetti? Metti la pasta dentro allo Sparabiscotti e...click click... biscotti pronti per

[sqlite] Index test on 3.0.7

Hi, I'm testing index on sqlite ver 3.0.7. I've create a really simple database CREATE TABLE tbl1(rowid integer primary key,fld1 text,fld2 integer); and fill it with 100 row like this insert into tbl1(fld1,fld2) values("blablablablablablabla",759928); Then I copy this test.db to

Re: [sqlite] New SQL Function.

Alle 20:04, mercoledì 18 agosto 2004, Doug Currie ha scritto: > > You must link with a math library that includes sqrt. > > Perhaps adding -lm (assuming you have libm.a and it has sqrt) to the > end of the TCC or LTLINK lines in the Makefile will help. Thanks, now it's ok. -- Email.it, the

[sqlite] New SQL Function.

Sorry for my english. I try to add a new SQL function (sqrt) as described at http://www.hwaci.com/sw/sqlite/c_interface.html#cfunc If I try (for understanding pourpose only) to return the same value I give to the function it's all ok, then (for a little experiment) I try to return the abs and

[sqlite] ODBC Driver

Hi, I try to find a ODBC driver to use on linux with OOo. Can you help me ? P.S. Sorry for my english. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]