[sqlite] Regarding Memory Database

Hi, I am using SQLite in a embedded system which has the following databases 1. 64MB Flash stored Database for persistent storage 2. 2 MB In-Memory Database. When the Memory Database is closed the 2MB should be returned to the operating system. The 2 MB will be reallocated when the

Re: [sqlite] Forensics data control

On 26 Aug 2009, at 4:28am, Gene Allen wrote: > Well, now we want to add some sophisticated forensics features. > Currently we > have fancy filtering but no real OLAP sort of capability. > > Have anyone seen a anything like this that we might be able to > integrate > into our product? We're

Re: [sqlite] SQLite Tools

BareFeet wrote: > Hi Barton, > > >> I saw all the tools listed on the SQLite wiki. I was hoping that I >> could solicit opinions on the various ones there to save me the time >> of trying all of them. >> > > I've tried several and posted a fairly detailed comparison at: >

[sqlite] Forensics data control

Hello all, I would like to ask for some guidance. We sell a file auditing product and, like you would think, the database can get large. SQLite has been a perfect engine for us since we only do inserts and searches. Well, now we want to add some sophisticated forensics features. Currently we

Re: [sqlite] sqlite-users Digest, Vol 20, Issue 65

> > > I am currently involved in porting sqlite on mobile phone > > As an aside, you do realize that most smartphone OSes already have > SQLite available? WinCE, iPhone OS, Symbian, PalmOS, Pre, and Android > either have SQLite libs built-in to the SDK, or have a version of SQLite > that

Re: [sqlite] SQLite Tools

Hi Barton, > I saw all the tools listed on the SQLite wiki. I was hoping that I > could solicit opinions on the various ones there to save me the time > of trying all of them. I've tried several and posted a fairly detailed comparison at: http://www.tandb.com.au/sqlite/compare/?ml >> is

Re: [sqlite] loadable extension doesn't load

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sub sk79 wrote: > I followed the exact instructions ( > http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions) on SQLite wiki for > loadable extensions and still have run into this issue. > Can someone help me here? The instructions are how to make

Re: [sqlite] port sqlite to VxWorks

Hi, use these definitions. -DOS_VXWORKS_660=660\ -DOS_VXWORKS_670=670\ -DOS_VXWORKS=OS_VXWORKS_670\ -DSQLITE_HOMEGROWN_RECURSIVE_MUTEX\ -DSQLITE_ENABLE_LOCKING_STYLE=1\ -DSQLITE_OMIT_LOAD_EXTENSION and below is my patch

[sqlite] loadable extension doesn't load

Hi, I followed the exact instructions ( http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions) on SQLite wiki for loadable extensions and still have run into this issue. Can someone help me here? @HOME-Ubuntu:~/utils/sqlite/sqlite-3.6.17$ gcc -I`pwd` -fPIC -shared ./loadableext.cpp -o

Re: [sqlite] Binding parameters to prepared statements

>> Although quotes can be used, they are not needed when the table and >> field names contain all valid characters. I simply saw no value in >> adding them, and they did seem to unnecessarily complicate the text. >> >> > It also says on http://www.sqlite.org/lang_keywords.html

Re: [sqlite] Find the letters that can follow the current text

> Just a note: > select distinct substr(col, length(?1), 1) > should be > select distinct substr(col, length(?1) + 1, 1) Oh, yes, sure. I always mix 0-based and 1-based indexing of symbols in different languages. :) Pavel On Tue, Aug 25, 2009 at 11:50 AM, Mohit Sindhwani wrote:

Re: [sqlite] Find the letters that can follow the current text

Pavel Ivanov wrote: > Maybe you want something like this: > > select distinct substr(col, length(?1), 1) > from table > where col like ?1||'%' > > Hi Pavel, thanks! It works..! Just a note: select distinct substr(col, length(?1), 1) should be select distinct substr(col, length(?1) + 1, 1) So,

Re: [sqlite] SQLite Tools

2009/8/25 Barton Torbert : > I am looking for one of two things.  The first thing would be a tool to   > easily synchronize data and structure between SQLite and Access.   I want to > be able to do something in one system and have it exported to the other. > Bart

Re: [sqlite] Binding parameters to prepared statements

On Tue, Aug 25, 2009 at 11:19:17AM -0400, Angus March scratched on the wall: > It also says on http://www.sqlite.org/lang_keywords.html that in > case you use a name that one day becomes a keyword you should always use > quotes. It is also quite specific about which quotes to use:

Re: [sqlite] CURRENT_TIMESTAMP with fractional seconds?

> Put parentheses around the strftime() function call: > > CREATE TABLE info(..., stamp DEFAULT (strftime('%f','now'))) > > The extra parentheses are needed to avoid a parsing ambiguity in the > SQL language. > > D. Richard Hipp > d...@hwaci.com Perfect! Ron Wilson, Engineering Project

Re: [sqlite] Binding parameters to prepared statements

John Elrick wrote: > Angus March wrote: > >> John Elrick wrote: >> >> >>> Angus March wrote: >>> >>> >>> I'm trying to make a prepared statement and bind parameters to it, but the documentation is very confusing. This is the statement I'm trying to prepare:

Re: [sqlite] CURRENT_TIMESTAMP with fractional seconds?

On Aug 25, 2009, at 11:04 AM, Wilson, Ronald wrote: > Is there a way to set a default timestamp with fractional seconds? > This gives a syntax error (obviously) but expresses my intent: > > CREATE TABLE info(k, v, stamp DATETIME default strftime('%Y-%m-%d > %H:%M:%f', 'now')); > Put

Re: [sqlite] Find the letters that can follow the current text

Maybe you want something like this: select distinct substr(col, length(?1), 1) from table where col like ?1||'%' Pavel On Tue, Aug 25, 2009 at 10:57 AM, Mohit Sindhwani wrote: > OK, I know the subject is difficult to understand but I want to use a > sqlite table for

[sqlite] CURRENT_TIMESTAMP with fractional seconds?

Is there a way to set a default timestamp with fractional seconds? This works but doesn't give fractional seconds: CREATE TABLE info(k, v, stamp DATETIME default CURRENT_TIMESTAMP); This gives a syntax error (obviously) but expresses my intent: CREATE TABLE info(k, v, stamp DATETIME

[sqlite] Find the letters that can follow the current text

OK, I know the subject is difficult to understand but I want to use a sqlite table for auto-completion. So, suppose I have records that are like: ITEM0 ITS THERE ITS HERE ITIS NOW ITSY BITSY ITZ COOL And if the user has typed in "IT", I'd like to prompt him saying that the only letters that

Re: [sqlite] SQLite Tools recommended: SQLite Manager

I use this tool now for basic data management. But I am looking for a tool that will help with documentation. Bart From: sqlite-users-boun...@sqlite.org on behalf of J Glassy Sent: Tue 8/25/2009 8:43 AM To: General Discussion of SQLite Database Subject: Re:

Re: [sqlite] Binding parameters to prepared statements

Angus March wrote: > John Elrick wrote: > >> Angus March wrote: >> >> >>> I'm trying to make a prepared statement and bind parameters to it, but >>> the documentation is very confusing. This is the statement I'm trying to >>> prepare: >>> UPDATE 'KEYS' SET 'IVAndKey'=:VVV WHERE

Re: [sqlite] SQLite Tools recommended: SQLite Manager

Hello Barton, Here is one suggestion to try: SQL Manager. I use SQLite Manager (by Mrinal Kant (http://sqlite-manager.googlecode.com) and find it extremely useful. It is developed in Xulrunner, Gecko, thus runs only under Mozilla/Firefox. That said, it runs essentially as a stand alone

Re: [sqlite] SQLite Tools

I saw all the tools listed on the SQLite wiki. I was hoping that I could solicit opinions on the various ones there to save me the time of trying all of them. Bart From: sqlite-users-boun...@sqlite.org on behalf of Kees Nuyt Sent: Tue 8/25/2009 8:28 AM To:

Re: [sqlite] Binding parameters to prepared statements

John Elrick wrote: > Angus March wrote: > >> I'm trying to make a prepared statement and bind parameters to it, but >> the documentation is very confusing. This is the statement I'm trying to >> prepare: >> UPDATE 'KEYS' SET 'IVAndKey'=:VVV WHERE "ItemID"=?NNN >> Where IVAndKey is a BLOB and

Re: [sqlite] SQLite Tools

On Tue, 25 Aug 2009 09:00:46 -0500, "Barton Torbert" wrote: > Hello, > > I have just started to use SQLite and am looking for > tools to manage my databases with. > > Right now my development group is manually importing > our SQLite databases into Access so to use the

Re: [sqlite] Binding parameters to prepared statements

Pavel Ivanov wrote: >> UPDATE 'KEYS' SET 'IVAndKey'=:VVV WHERE "ItemID"=?NNN >> Where IVAndKey is a BLOB and ItemID is an INTEGER and the primary key >> for the table. I'm told that there is a syntax error near "NNN". >> > > You have actually used some number instead NNN and wrote it here

Re: [sqlite] Binding parameters to prepared statements

Angus March wrote: > I'm trying to make a prepared statement and bind parameters to it, but > the documentation is very confusing. This is the statement I'm trying to > prepare: > UPDATE 'KEYS' SET 'IVAndKey'=:VVV WHERE "ItemID"=?NNN > Where IVAndKey is a BLOB and ItemID is an INTEGER and the

[sqlite] SQLite Tools

Hello, I have just started to use SQLite and am looking for tools to manage my databases with. Right now my development group is manually importing our SQLite databases into Access so to use the latter to document table relationships, create ERDs, etc. This is the painful way to do this,

Re: [sqlite] Binding parameters to prepared statements

> UPDATE 'KEYS' SET 'IVAndKey'=:VVV WHERE "ItemID"=?NNN > Where IVAndKey is a BLOB and ItemID is an INTEGER and the primary key > for the table. I'm told that there is a syntax error near "NNN". You have actually used some number instead NNN and wrote it here just for abstract example, haven't

[sqlite] Binding parameters to prepared statements

I'm trying to make a prepared statement and bind parameters to it, but the documentation is very confusing. This is the statement I'm trying to prepare: UPDATE 'KEYS' SET 'IVAndKey'=:VVV WHERE "ItemID"=?NNN Where IVAndKey is a BLOB and ItemID is an INTEGER and the primary key for the table. I'm

Re: [sqlite] datetime('now', 'utc') vs. CURRENT_TIMESTAMP

On Mon, Aug 24, 2009 at 06:21:49PM -0400, Wilson, Ronald scratched on the wall: > According to the documentation for CURRENT_TIMESTAMP, it should insert > the current UTC date/time: http://www.sqlite.org/lang_createtable.html. > sqlite> select datetime('now', 'utc'); > > 2009-08-25 02:20:10 >

Re: [sqlite] datetime('now', 'utc') vs. CURRENT_TIMESTAMP

> Do I misunderstand something fundamental? According to http://www.sqlite.org/lang_datefunc.html datetime('now') returns date and time already as UTC. If you add 'utc' modifier then it makes datetime() think that it's your local time and convert it to 'utc' thus adding 4 hours (apparently you're

[sqlite] thank

thank you ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] port sqlite to VxWorks

On Mon, 24 Aug 2009 14:46:00 +0800 (CST), mly_hlmgood wrote: > Hi, > I am puzzled by porting sqlite to VxWorks. can you help me. Please specify the bottlenecks. -- ( Kees Nuyt ) c[_] ___ sqlite-users mailing list

[sqlite] datetime('now', 'utc') vs. CURRENT_TIMESTAMP

According to the documentation for CURRENT_TIMESTAMP, it should insert the current UTC date/time: http://www.sqlite.org/lang_createtable.html. However, there appears to be a mismatch with datetime('now', 'utc'): SQLite version 3.6.10 Enter ".help" for instructions Enter SQL statements

[sqlite] port sqlite to VxWorks

Hi, I am puzzled by porting sqlite to VxWorks. can you help me. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite client and server with new RPC system

Hi, all. I'm working on new RPC (remote procedure call) system integrated into C language, so I desided to write a client and server side for Sqlite with this system. System is called CRPC, integrated in C with special modificators, has own network protocol and marshaling method. Also SSL

[sqlite] Software operation and ETL tools

Hi all, We are in the process of getting an ETL program. We need it to perform some basic extract, transform and load jobs. But we want to get an open source tool with good training. Our team is mainly business oriented, with some computer knowledge. We would like to have someone come to our