On Mon, Feb 10, 2014 at 9:23 PM, Richard Hipp d...@sqlite.org wrote:
(1) Reword the banner to make it more terse and to try to avoid
banner fatigue.
Thanks.
(2) If opened with no command-line arguments (and hence on an in-memory
database) output a warning in the banner.
(a) On unix
On Tue, Feb 11, 2014 at 5:06 AM, James K. Lowden
jklow...@schemamania.orgwrote:
(1) Detect double-click launch by looking at argc and argv.
Why make this a special case? If no database name is provided,
the behavior should be the same regardless of how launched or what OS.
Easier to
You may enjoy reading up on Btrees here:
http://en.wikipedia.org/wiki/B-tree
-Ursprüngliche Nachricht-
Von: Raheel Gupta [mailto:raheel...@gmail.com]
Gesendet: Montag, 10. Februar 2014 10:49
An: General Discussion of SQLite Database
Betreff: Re: [sqlite] Free Page Data usage
Note that
- We encrypted our database with common System.Data.SQLite method -
public void ChangePassword(string newPassword) -
in SQLiteConnection .NET class.
- No, there were no changes in the system.
- We tried SQLite shell tool. Does it open an encrypted database? Honestly, we
found no info about it.
All,
Does anyone know if it is possible for a date field to be automatically
incremented with a month when a new record is created?
If the last row contains 2013-01-01 in the DateField then the DateField
of the new row should automaticllay be 2013-02-01.
Thanks
gert
On Feb 11, 2014, at 7:07 PM, Gert Van Assche ger...@gmail.com wrote:
Does anyone know if it is possible for a date field to be automatically
incremented with a month when a new record is created?
If you are looking for something wacky, triggers are where to look:
On 2014/02/11 20:07, Gert Van Assche wrote:
All,
Does anyone know if it is possible for a date field to be automatically
incremented with a month when a new record is created?
If the last row contains 2013-01-01 in the DateField then the DateField
of the new row should automaticllay be
This is what I came up with -- it seems to work but I don't know how safe
it is:
CREATE TRIGGER [AddMonthToAPSGEN]
AFTER INSERT
ON [APS_Generale]
BEGIN
UPDATE APS_Generale SET nDate = date((SELECT nDate FROM APS_Generale
WHERE rowid=(SELECT max(rowid)-1 FROM APS_Generale)),'start of
On Mon, Feb 10, 2014 at 10:30 PM, Simon Slavin slav...@bigfraud.org wrote:
On 11 Feb 2014, at 4:06am, James K. Lowden jklow...@schemamania.org wrote:
${HOME}/.sqlite/db would be my choice.
Since the objective is not to let a naive user unexpectedly lose the data, it
might seem a bad idea to
Lets not throw honey at the problem when a bear is around. Some of the
things I've seen in this thread just makes it sound like the kitchen sink
should be included in this application.
I don't like the idea of letting the software decide what should be done
based on a configuration file. Linux
On 11 Feb 2014 at 21:49, Stephen Chrzanowski pontia...@gmail.com wrote:
I don't like the idea of letting the software decide what should be done
based on a configuration file.
The .sqliterc file already exists, so you're too late.
Linux and Windows both can isolate processes from each other,
On Tue, 11 Feb 2014 16:49:50 -0500
Stephen Chrzanowski pontia...@gmail.com wrote:
I don't like the idea of letting the software decide what should be
done based on a configuration file.
Hmm, isn't it the other way around? Does the user tell the software
what to do via a configuration file?
12 matches
Mail list logo