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 NUMERIC(6,2)
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 Little Bit Of
*System.Data.SQLite *is an enhanced version of the original SQLite
http://www.sqlite.org/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
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 ...
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 row
can you post those rows with
.mode insert
so I can do a fast try ?
Tnx.
--
[image: Just A Little Bit Of
Geekness]http://feeds.feedburner.com/%7Er/JustALittleBitOfGeekness/%7E6/1
Le tre grandi virtù di un programmatore: pigrizia, impazienza e arroganza.
(Larry Wall).
2008/6/4 Christophe Leske
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
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
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
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
other hand, you
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 referring to a
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 addressed in a
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
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 access
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
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
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]http://feeds.feedburner.com/%7Er/JustALittleBitOfGeekness/%7E6/1
Le tre grandi virtù di un programmatore: pigrizia, impazienza e arroganza.
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)
... );
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 ...
Yes,
]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 [EMAIL PROTECTED] wrote:
On Wed, Apr 23, 2008
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
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 TABLE_2)
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
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 test-index.db
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
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
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]
27 matches
Mail list logo