O_sqlite:
* php_pdo_sqlite
Has SQLite linked in. Depending on your Linux distribution
and/or your PHP version that might be an obsolete version of
SQLite.
* php_pdo_sqlite_external
Uses any SQLite3 library you offer it, for example the compiled
amalgamation.
>Than
to COMMIT your INSERTs frequently
and measure the size of the database file.
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
y, integers are compressed, so they don't occupy eight
bytes all the time.
sqlite3_column_int64(); will always return a sqlite3_int64.
So, no need to worry.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ps the original poster.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
;I suspect the answer is no, but is there any way to salvage any of the data?
You could try the .dump command in the command line tool, but
I'm afraid you're out of luck.
>Thanks
>
>Doug
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
month");
>2006-03-03
>--> not correct
>
>
>Can anyone confirm? Any suggestions / workarounds greatfully received!
Confirmed.
Better:
select date('2006-03-31', 'start of month','-1 month');
>Many thanks
HTH
>Craig
--
( Kees Nuyt
)
c[_]
--
On Wed, 2 Jan 2008 17:49:36 -0600, "Jay Sprenkle"
<[EMAIL PROTECTED]> wrote:
>On Jan 2, 2008 5:31 AM, Kees Nuyt <[EMAIL PROTECTED]> wrote:
>
>I found a solution that seems workable. I ended up rewriting my query
>class so it assumes a bunch of things
ysql> SELECT EXISTS(SELECT x FROM t1);
+--+
| EXISTS(SELECT x FROM t1) |
+--+
|1 |
+--+
1 row in set (0.02 sec)
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
<[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
Subject: Re: [sqlite] sqlite3_rowid
>I will probably just do it myself. I try not to reinvent
>the wheel where possible. ;)
Good luck then ;)
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
tudy the source code of some SQLite GUI
front ends to see how they do it?
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
x column or what column(s) were used to select
>that column.
You know the query, and also the schema, for example from
PRAGMA table_info(tabelname);
That includes primary key info.
Merge that with the i
of the
PRIMARY KEY of the row in the resultset (Role.id ?), it probably
already is available in Role.*.
Iterate over the columns in the resultset and it should be
there. But perhaps I didn't understand your question correctly?
>Thanks
ld be possible, an update trigger most
likely wouldn't fire on a failed update. The only thing you can
rely on is: zero rows changed.
But you could try it anyway.
Experiments are always worth the effort.
--
( Kees Nuyt
)
c[_]
-
SELECT timestamp, x, y FROM d2007.myname;
DETACH DATABASE d2007;
If the table structures are exactly the same, the INSERT
statement can even be shortened:
INSERT INTO myname SELECT * FROM d2006.myname;
etc.
>Thanks in advance W.Braun
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On Sat, 29 Dec 2007 15:17:27 +0100, Lothar Behrens
<[EMAIL PROTECTED]> wrote:
>
>Am 29.12.2007 um 13:59 schrieb Kees Nuyt:
>
>>
>> Hi Lothar,
>>
>> On Sat, 29 Dec 2007 13:13:04 +0100, Lothar Behrens
>> <[EMAIL PROTECTED]> wrote:
>>
>>
rator
>Thanks, Lothar
Hope this helps.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ECTED]> :
IT> You can do
IT>
IT> UPDATE ... WHERE keyfield='xxx';
IT>
IT> then use sqlite3_changes to see whether any update
IT> has in fact taken place, and run INSERT if not.
IT>
IT> Igor Tandetnik
>Thanks in advance and happy hollidays!
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ny
>>rows you do an `INSERT`.
>>
>> In #1, you always get the job done with a single query. In #2,
>> you are usually done after the first but sometimes need a second.
>> Both are more efficient than your current approach, which always
>> runs two queries.
>>
>> Regards,
>>
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
---
>
>I just fetch one row.
>
>if that get's a return I update otherwise I insert a new row.
>
>QUESTION: is there a better way to make this important decision? using
>Sqlite
>
>regards W.Braun
INSERT OR REPLACE may work for you.
http://ww
ery plan had another column that
>indicated which columns it had to crawl through...
EXPLAIN QUERY PLAN SELECT ... only shows which access strategy
the optimizer has chosen.
You will get much more detail with EXPLAIN SELECT ...
It shows the VDBE code, which looks cryptic at first but will
pr
ER INSERT and AFTER UPDATE
triggers, which would store the result of the comparison in a
fourth, indexed, column.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
.help" for instructions
sqlite> .mode csv
sqlite> .output filename.ext
sqlite> SELECT * FROM tablename;
sqlite> .q
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
:-/
>
>Tom
Just for the record:
There is a fix in CSV, which will be included in the next
version.
Related Check-ins:
2007-Dec-18 15:41 Check-in [4638] : In the CLI, quote strings
that contain the separator character. Ticket #2850. (By drh)
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
elect statement how SQLite
behaves. Apart from the architecture and optimization pages on
the SQLite website, you may want to study
http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
>Thanks & Best Regards,
>A.Sreedhar.
--
( Kees Nuyt
)
c[_]
DestinationAdd DOUBLE,
ProtocolINT,
Direction INT,
SourcePort INT,
DestinationPort INT
);
CREATE TABLE HipsLog (
FlagINT,
LogDate DOUBLE,
Parent VARCHAR(255),
Target VARCHAR(255)
);
http://www.personalfire
On Fri, 14 Dec 2007 03:15:17 +0100, Gilles Ganault
<[EMAIL PROTECTED]> wrote:
>On Mon, 10 Dec 2007 16:35:48 +0100, Kees Nuyt <[EMAIL PROTECTED]> wrote:
> >So I activated php_pdo_sqlite_external instead and copied
> >sqlite3.dll v3.5.3 to %serverroot%/bin .
>
PRAGMA user_version = 6002;
INSERT INTO test1 VALUES (1,'alpha');
INSERT INTO test2 VALUES (2,'beta');
PRAGMA schema_version;
: 3
PRAGMA user_version;
: 6002
>Thanks,
>JP
I hope this helps,
--
( Kees Nuyt
)
c[_]
---
On Wed, 12 Dec 2007 11:28:40 +, [EMAIL PROTECTED] wrote:
> SQLite Consortium Launches With Mozilla And
> Symbian As Charter Members
>
Congratulations!
--
( Kees N
specifics that need to be managed outside the
>> >>> context of
>> >>> SQLite, I am fine with that. However, for doing external
>> >>> management I
>> >>> believe I would need hooks into the basic management of the
>> >>> database. What I
>> >>> would like to know
t; if (DATABASE_SERVER == SERVER_MYSQL) {
>$dbh = new PDO("mysql:host=localhost;dbname=tasks", "tasks",
>"tasks");
> }
> else {
>$dbh = new PDO('sqlite:tasks.db');
> }
>}
Nice setup.
I still have MySQL v5.0.41 running next to SQLite for a
ues ('delta','kappa');
and rerun your test to see what happens.
>P.s. in our program, the "update" statement are generated from a
>database-layer, and optimize the statement generation is a big work..
>for that i'm trying to understand
P.
I didn't try php_pdo_sqlite_external yet, it seems to call a
self-supplied sqlite3.dll, so one would be able to use the
latest SQLite3 version.
>Don't worry about PHP4, as this old version will no more be
>supported soon...
--
( Kees Nuyt
)
c[_]
--
ttp://docs.python.org/lib/module-sqlite3.html, shouldn't the
last line be:
""", ('hui*'))
(without the extra comma)?
>The database used can be downloaded from
> http://xile.org/le/prepared_statement.zip (1.75 MB)
>
&
ase-event
ON [database-name .] view-name
trigger-action
Your trigger-action can do about anything.
>Thanks,
>Robert
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
e table and get the information from
the result set.
There was a discussion over that last method just one or two
days ago, so you could try the archives.
sqlite3_column_count() perhaps?
>Thanks for the info.
>JP
HTH
--
blea_old;
-- Drop the original table
DROP TABLE tablea_old;
-- optimize the database
VACUUM;
ANALYZE;
>Thanks,
>jp
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ntionally, you can:
http://www.sqlite.org/lockingv3.html has a chapter 6.0 How To
Corrupt Your Database Files
>We would like to integrate error handling into our software to handle
>all cases.
>
>Regards,
>
atabaseexaminationue0.jpg>
>
>* SimpleSQLite.zip: written by C++/Qt (it needs Qt open source
> edition 4.3.1 to run executables)
>
>http://img338.imageshack.us/img338/2189/simplesqliteps6.jpg
><http://img338.imageshack.us/img338/
onths of messages in this list.
Over 13000 messages, 54 MByte raw, 8.5 MByte zipped.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
tion: Perhaps even on the home page.
"This the homepage for SQLite - a library that implements a
self-contained, serverless, zero-configuration, _portable_,
transactional SQL database engine."
With a link to a 'Portable' paragraph on the 'Di
ogress, not a done
>deal. I am still looking for suggestions, comments,
>and bug reports.
Currently there seems to be no link to the
http://www.sqlite.org/contrib page.
On the contrib page a link to
http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
would
On Fri, 23 Nov 2007 18:47:40 +0100, <[EMAIL PROTECTED]> wrote:
>Btw, what would be the best GUI to use?
I am happy with SQLite3Explorer.
http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
http://www.singular.gr/sqlite/
HTH
--
( Kees N
d 'EXPLAIN QUERY
PLAN SELECT ...' output with and without index.
>Is SQLite going to be able to handle, say, 2,000,000 data pairs, and say
>60,000 positions, efficiently and quickly?
In general, yes.
>How can I help SQLite perfor
TRANSACTION is an alias for COMMIT.
So, you can use either.
>Thanks,
>JP
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
a time... something like:
>
>SELECT * FROM table LIMIT 1 OFFSET 2;
Please read this article from drh to improve performance on that
one.
http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
--
( Kees Nuyt
)
c[_]
---
g updates and deletes
(using triggers) between the 'numeric table' and the 'text
table'.
>Best regards,
>Igor
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
.dump |
awk '{sub(/ oldtable /," newtable ");print}' |
sqlite new_db
(all on one line, but I added linefeeds after every pipe
character for clarity)
Untested, parenthesis in positions where i assume spaces might
cause some problems, but you get the idea.
HTH
--
( Kees Nuyt
)
c[_]
-
ll be about a quarter to a third of the full size.
Using the API or the command line tool (.import) is much easier,
and very fast, if done right (transactions).
The library and the command line tool are both smaller than 400k
(MS Windows, v3.4.2), so why bother?
>Than
gt;1968-08-02
>
>But is there a more robust, built in method?
>
>Thanks,
>Tom
Often there are data cleaning and normalizing tasks to be
performed before the data is ready for (read: can be piped into)
the database.
I would preproces
f I'd
>happily buy one of them [they're inexpensive enough], but I"m just
>trying to correct typos in a DB that I recently converted to version 3]
>Thanks!
> /bernie\
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
se sqlite3_step() etc. to fish values out of pTmp */
> sqlite3_transfer_bindings(pTmp, X);
> sqlite3_finalize(pTmp);
>
>Dan.
Very smart indeed!
Would it matter much that sqlite3_transfer_bindings() is marked
obsolete in the docs, and, as a result, only d
take quite
some time, but as long as the dbfile format stays the same that
won't be a problem, as we will be using the PHP-specific library
version anyway.
I hope Mike Cariotoglou is willing to update sqlite3explorer ;)
The same probably goes for other less actively maintained
frontends.
--
Just some suggestions:
Index locid in both tables, and rewrite
> select *
> from blocks,locations
> where locations.locid = blocks.locid
> AND ? >= blocks.startIpNum
> AND ? <= blocks.endIpNum
to:
select *
from blocks
INNER JOIN locations USING (locid)
where ? >= blocks.sta
known beforehand that it is not reliable if used with ON CONFLICT clauses.
>
>Mike
Perhaps
http://www.sqlite.org/capi3ref.html#sqlite3_update_hook
can help you solve your problem?
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ing scheme
as current versions). You might even be able to find v2.1 in
this way, but first you should try v2.8.17.
You can use the v2.8.17 sqlite.exe program to test if your
version 2.1 database is accessible from version 2.8.17.
>thank u
>vijaya
>
>
>Kees Nuyt wrote:
>>
en more speed you can prepare the SELECT statement during
the init of your program, and bind to the appropriate values
every time you need it, so it doesn't have to be parsed every
time.
Regards,
--
( Kees Nuyt
)
c[_]
--
OWID in
the table prior to the insert.
And:
If a column has the type INTEGER PRIMARY KEY AUTOINCREMENT then
a slightly different ROWID selection algorithm is used.
By supplying NULL as the key (ROWID) you actually don't specify
a value, so SQLite creates a new row wi
atabases can usually be converted easily to v3 with:
sqlite2 yourv2.db .dump | sqlite3 yourv3.db
HTH
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On Fri, 12 Oct 2007 01:00:32 -0500, you wrote:
>On Thu, 11 Oct 2007 13:33:35 +0200, Kees Nuyt wrote
>> On Wed, 10 Oct 2007 22:10:38 -0500, you wrote:
>>> You might want to be a little bit more clear about the fact that
>>> [transaction] nests even though BEGIN does not
tails automatically."
And this is about the TCL transaction {} method.
>You might want to be a little bit more clear about the fact that [transaction]
>nests even though BEGIN does not.
The TCL transaction{} can be nested, the SQL BEGIN can't.
As drh wrote:
>> The
t_id INTEGER PRIMARY KEY,
t_name TEXT
)
SQLite version 3.4.2
Enter ".help" for instructions
sqlite>
Hope this helps.
Regards,
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
age earlier
>
>-x-
>Chetana
This might be of help:
http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers
http://www.rcs-comp.com/site/index.php/view/Utilities-SQLite_foreign_key_trigger_generator
--
( Kees Nuyt
)
c[_]
our
php-cli uses another php.ini than the Apache module does.
Good luck !
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ious key and concatenate the rest.
- store 'fred' as (2,ed)
- store 'google' as (0,google)
- store 'gopher' as (2,pher)
This works nicely for large indexes with long keys and a lot of
repetition. Of course the effort to handle insertions and
deletions is sign
On Mon, 24 Sep 2007 10:35:51 -0700, you wrote:
>Kees Nuyt wrote:
>> On Mon, 24 Sep 2007 07:13:51 -0700, Gururaja Nittur wrote:
>>
>>
>>> Sqlite experts,
>>>
>>> I am running Sqlite version 3.4.1. I ran some performance tests and
>>> obs
omodate 3.5
MByte.
Ideally, the page_size should equal the allocation unit (for
Window: the cluster size of the formatted disk).
Also, if your rows can be large, a too small page_size would
cause overflow pages, and thus additional overhead.
>Thanks in advance.
ed.
The link isn't on the page anymore, but (as with many old
versions) the download is still available:
http://www.sqlite.org/sqlitedll-2_8_17.zip
I'm glad you managed to compile it by yourself.
--
( Kee
On Thu, 20 Sep 2007 13:57:58 -0400, Liam wrote:
> It would be nice if the documentation gave a
> brief indication when a feature is added
> ("new in 3.5.0" unobtrusively somewhere).
Like in http://www.sqlite.org/34to35.html ?
--
tion I'm trying
> to support.
> Thank you to anyone who might be able to provide this for me.
It's on the bottom of the download page:
http://www.sqlite.org/download.html
--
( Kees Nuyt
)
c[_]
-
To unsubscribe,
there a better way? I can't see any number formatting function in
>SQLite's repertoire.
Round comes closest, but is not exacly what you need.
select '$' || round( Amount ,2) from Invoice;
Two remarks:
Formatting and presentation is usually considered a task of the
host language, not of SQL.
Valuta are bes
ngs, bcz the colums aren't
defined as numeric in the table definition.
>thanks,
>
>josé
Hope this helps,
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
re, and if not, define a
proper schema.
The class methods for receiving messages could contain sqlite3
calls that use the database in some way.
You have to take care that every database should have a unique
filename, and that a specific node in the simulated network uses
the same name all the time
person_id INTEGER 99 1
1 name TEXT 99 0
2 dtstampDATETIME 0 CURRENT_TI 0
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
>- Kefah.
Good luck.
>On Saturday 15 September 2007 00:25:03 Kees Nuyt wrote:
>> On Fri, 14 Sep 2007 23:20:53 +0300, you wrote:
>> >Dear All,
>> >
>> >I have been struggling with the performance of insertion in sqlite.
>> >
>> >Here we have
s the best next thing to do either.
>
>Your feedback and input will be highly appreciated,
>
>- Kefah.
Most probably the UNIQUE INDEX on the TEXT column is the
culprit.
My first try would be to create and fill the table first, a
t without the server mechanism.
The performance gain of a :memory: database is limited, one of
the reasons is that most operating systems will cache the
database file in memory anyway.
In general: when you really need a DB server, don't use SQLite.
http://www.sqlite.org/whentouse.html
>Thank you.
/www.sqlite.org/datatype3.html
Regards,
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
n every row you sqlite3_step()
into.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On Tue, 04 Sep 2007 09:20:28 -0700, Gerry wrote:
>Kees Nuyt wrote:
>> On Tue, 04 Sep 2007 07:53:08 -0600, Scott wrote:
>>
>>> I have an application that is inserting a record every second. There
>>> are thousands of periods from a few seconds to hour
ne a
separate table constraint UNIQUE (on,all,columns) ON CONFLICT
IGNORE.
The insert will fail. It depends on the conflict-clause what
happens.
Or you can use INSERT ... ON CONFLICT IGNORE.
http://www.sqlite.org/lang_conflict
4
DELETE FROM testTbl WHERE t_name='d2';
SELECT ROWID,t_name FROM testTbl;
1|d1
3|d3
4|d4
same picture..
Regards,
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
://www.forum.nokia.com/devices/pics/6233_main.jpg
http://www.nokia.com/search/images/logo_nokia_115_40.gif
(I didn't find a real good one)
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ct round(98926650.50001 -0.01, 1);
98926650.501
sqlite> select round(98926650.50001 -0.1, 1);
98926650.4
sqlite>
Oh, well, 9 digits of accuracy is way more than most
measurements we can do in daily life.
For money, use integers and express in cents / centimes or
something.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
l
use around your SQL, even in a shell:
sqlite3 your.db "select * from testTbl;" | \
awk -v OFS='|' '{print NR,$0}'
1|1|d1
2|3|d3
3|4|d4
note: \ is linewrap
Regards,
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
sqlite-networked
>Thanks,
>Mark
Hope this helps.
Regards,
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
loading, sort your input in key order.
4) Tune your operating system and file system.
5) Adjust hardware.
Good luck
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
is
created [snip]
Note: this solution is not standard SQL and not portable.
For more or less protable solution you would have to use smart
trigger code.
Regards,
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
th in the application.
> Thanks in advance
> Nick
Regards,
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
[snip]
> My own Skype installation doesn't show any trace of SQLite.
> Either they don't use it, or they've hidden it very well.
Oops, found it:
C:\Users\\AppData\Roaming\Skype\\dyncontent\bundle.dat
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
cy
DVBT_FrequencyTable
DVBT_FrequencyTableToFrequency
DVB_IPService
Version
Regards,
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
On Thu, 23 Aug 2007 14:15:00 -0400, you wrote:
>On Thu, 23 Aug 2007 18:58:32 +0200, Kees Nuyt wrote:
>
>>Hi Chris,
>
>>On Thu, 23 Aug 2007 12:14:51 -0400, you wrote:
>
>>>On Thu, 23 Aug 2007 08:52:40 -0700, Gerry Snyder wrote:
>>>
>>>>Wi
ust the ones to be updated.
That is exactly what INSERT OR REPLACE does.
http://www.sqlite.org/lang_insert.html
http://www.sqlite.org/lang_conflict.html
>Chris
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
all info
pushed to me.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Use of this email is
>prohibited when received in error.
Exactly the way it says in about every message:
-
To unsubscribe, send email to
[EMAIL PROTECTED]
--
using a web interface,
http://www.mail-archive.com/sqlite-users@sqlite.org/
might suit your needs.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
en, so the stamping will be more
consistent, much like constraints.
As a side note, I seem to remember all sqlite timestamps within
a transaction have the same value: the time at BEGIN
TRANSACTION. To me that is the most important reason to have the
DBMS do the timesta
roduct_id
)
WHERE ...
See also:
http://www.sqlite.org/cvstrac/wiki?p=UnsupportedSql
item 2005.10.06
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
browsers (Firefox), embedded systems like PDA's, mp3
players etcetera. These are all enviroments where the users 1)
aren't especially careful 2) aren't willing or able to
handrecover a database. They even don't
ands on experience with Vista...
Perhaps you should install the software in directories outside
the ones "guarded" by Vista. I think "Program Files" and
"Windows" aren't safe anymore for people who want to be in
control themselves.
>Re
be quoted at all.
If you choose your columnnames carefully (not contained in the
collection of reserved words), the [] could easily be filtered
out with sed or awk.
--
( Kees Nuyt
)
c[_]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
701 - 800 of 849 matches
Mail list logo