Re: [sqlite] Dates based on fliter

My understanding on the below code is that this is adding one month to the current date. I need to add months to the date listed in a table. Simon Slavin-3 wrote: > > > On 28 Oct 2010, at 7:58pm, Redhot wrote: > >> the first filter would be the Date entered to >> Six months from the Date

Re: [sqlite] Problem dumping a single line ot UTF8 text into a table (likely a n00b problem)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/28/2010 08:58 AM, Drake Wilson wrote: > Quoth "J. Bobby Lopez" , on 2010-10-28 11:48:12 -0400: >> Another think that crossed my mind is that maybe I haven't set up the >> database properly to accept UTF8 or UTF16 data, but I

Re: [sqlite] Dates based on fliter

SQLite version 3.7.3 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table t(d date); sqlite> insert into t values('2010-06-01'); sqlite> insert into t values('2010-08-01'); sqlite> insert into t values('2010-09-01'); sqlite> insert into t

Re: [sqlite] Dates based on fliter

On 28 Oct 2010, at 7:58pm, Redhot wrote: > the first filter would be the Date entered to > Six months from the Date Entered. The Next would be Six months +1 to twelve > months from the date entered. See http://www.sqlite.org/lang_datefunc.html and the example that says SELECT

[sqlite] Dates based on fliter

I would like to add the 6 months, 12 months 18 months and 24 months to a date entered into the sqlite database. The date in the database is in sql formate -MM-DD. The dates will be used for a filter. The filter will pull Rows from a table. Like the first filter would be the Date entered to

Re: [sqlite] DB rotate / incremental

> I currently use a single database and it works fine. > The trouble is replication. > Or the sharing of an ever growing database. I think your question is more architectural than sqlite-specific. If your user base / data set is going to be getting more serious and if you have some time

Re: [sqlite] DB rotate / incremental

There is just one table, data is simple, fits well in CSV, but I like to do SQL query on this data and sqlite3 packs it pretty well. The data comes from external source and changes constantly, I just grab a snapshot of it every minute. I currently use a single database and it works fine. The

Re: [sqlite] Problem dumping a single line ot UTF8 text into a table (likely a n00b problem)

Thanks! Likely I will stick with UTF8, however I'm having a hard time detecting (programmatically) when a file is UTF16. I've tried the 'file' command on the command line, but it just returns the file as 'data' I'll likely have to find a way to detect this in perl, then do the conversion with

Re: [sqlite] DB rotate / incremental

My first question is: Why are you using a database? Sounds to me like grep might do what you want. All you're doing is inserts and selects. Can you show what kind of selects you're doing or your database schema? And why do you need to rotate the database? Why can't you just keep it all

Re: [sqlite] Problem dumping a single line ot UTF8 text into a table (likely a n00b problem)

Quoth "J. Bobby Lopez" , on 2010-10-28 11:48:12 -0400: > And here it is again when less (which doesn't translate the UTF8 text): > t...@y^@p...@e^@ ^@ ^@ ^@ ^@ ^@ ^...@t^@i...@m^@e^@ ^@ ^@ ^@ ^@ ^@ ^@ ^@ ^@ > ^@ ^@ ^@ > ^@ ^@ ^@ ^@ ^@ ^@ ^@ ^@ ^...@u^@s...@e^@r^@ ^@ ^@ ^@ ^@ ^@

[sqlite] Problem dumping a single line ot UTF8 text into a table (likely a n00b problem)

Hi all, I'm trying to dump a single line into an SQLite database, however the line is UTF8 text, and the operation fails. Here's what the text file looks like when using head: $ head -n 1 test1.txt Type TimeUserDescription And here it is again when

[sqlite] DB rotate / incremental

Hi, i'm not sure what exact vocabulary I should use for this... I'm looking for a way or technique, that allows rotating the database just like some tools will rotate my /var/log/messages on Linux. So, to rotate a database, I'm guessing the current DB needs to be renamed and kept nearby, new DB

Re: [sqlite] Loss of Binary Data in Dump File

On 28 Oct 2010, at 8:28am, Art Age Software wrote: > There is a bug in PHP versions prior to PHP 5.3 that makes it > impossible to reliably create/store BLOB columns. My code ends up > creating TEXT data when run under any version of PHP in the 5.2.x > branch. When run under PHP 5.3.x, BLOB

Re: [sqlite] Compilation flags required for amalgamation

On Thu, Oct 28, 2010 at 2:59 AM, Navaneeth.K.N wrote: > Hello, > > I am trying to understand the compilation flags required to use for > compiling the amalgamation copied into my source code directory. I > can't use the make files provided with the amalgamation as I am

[sqlite] Sqlite3_progress_handler and automatic rollback

Hi, I try to use Sqlite3_progress_handler in my program and everything seems work fine, except for some unexplained things related to rollback and Sqlite3_get_autocommit function. I assume that everything that is related to sqlite3_interrupt can be applied to interrupting from

Re: [sqlite] Loss of Binary Data in Dump File

Art Age Software wrote: > With Roger's help I have gotten to the bottom of this issue, and I > wanted to post the resolution to the list in case anyone else bumps > into it. > > There is a bug in PHP versions prior to PHP 5.3 that makes it > impossible to reliably create/store BLOB columns. My

Re: [sqlite] Loss of Binary Data in Dump File

With Roger's help I have gotten to the bottom of this issue, and I wanted to post the resolution to the list in case anyone else bumps into it. There is a bug in PHP versions prior to PHP 5.3 that makes it impossible to reliably create/store BLOB columns. My code ends up creating TEXT data when

[sqlite] Compilation flags required for amalgamation

Hello, I am trying to understand the compilation flags required to use for compiling the amalgamation copied into my source code directory. I can't use the make files provided with the amalgamation as I am using a different build system using CMake. Currently I am using only "SQLITE_THREADSAFE=1"