[sqlite] macro redefinition

Hi, I am getting the following error log when i try to build sqlite source : c:\Documents and Settings\Administrator\My Documents\Visual Studio Projects\Source Tagging System\sqlite\where.c(37): warning C4005: 'WHERETRACE' : macro redefinition c:\Documents and Settings\Administrator\My Documents\V

Re: [sqlite] macro redefinition

> Hi, > I am getting the following error log when i try to build sqlite source : > ... > c:\Documents and Settings\Administrator\My Documents\Visual Studio > Projects\Source Tagging System\sqlite\where.c(2902): fatal error C1010: > unexpected end of file while looking for precompiled header direct

[sqlite] SQLITE_CONFIG_SERIALIZED

Hi, Which version introduced this option? I am accessing the same connection with multiple threads. I'm seeing a problem since the application locks the database connection during a prepare/step sequence for SELECT operations. It also locks the connection for transactions that perform INSERT/UPD

Re: [sqlite] SQLITE_CONFIG_SERIALIZED

On Sep 30, 2008, at 11:39 AM, Rick Keiner wrote: > Hi, > > Which version introduced this option? > > I am accessing the same connection with multiple threads. > > I'm seeing a problem since the application locks the database > connection > during a prepare/step sequence for SELECT operations. I

[sqlite] seeking storage design assistance

Hi All, I've got some general db storage design questions that I hope someone can offer some advice on... I have a need to store some CAD-type geometry in a SQLite database, and I'm trying to decide on the best db design. Specifically, I need to store "entity" data, which will include such th

Re: [sqlite] seeking storage design assistance

ORM is always a tricky business. My experience is that unless the entity is very very simple, it's often inappropriate to attempt to do 1 row = 1 entity mapping. If things are collections of points, then by all means have a points table. A lot of this type of stuff can be made easier by 1) reall

Re: [sqlite] seeking storage design assistance

It also helps to know how you want to access/manipulate your data and what you want to do with it in SQL versus with your application. For instance, you could just store all the cad data as a blob, along with the attributes in columns. Then you can fetch the data based on attributes, and manipu

[sqlite] how to connect to existing db with sqlite3.exe

Hi, I have a database file in windows that I want to connect to with sqlite3.exe so I can add a column to a table. Not sure how to so it. There doesn't appear to be any relevant command when I enter .help. Thanks, Ryan -- Ryan Walker www.WebCommunicate.net: Insights and resources for effecti

Re: [sqlite] how to connect to existing db with sqlite3.exe

On 9/30/08, Ryan Walker <[EMAIL PROTECTED]> wrote: > Hi, > I have a database file in windows that I want to connect to with > sqlite3.exe so I can add a column to a table. Not sure how to so it. > There doesn't appear to be any relevant command when I enter .help. > Thanks, > Ryan > > comman

Re: [sqlite] how to connect to existing db with sqlite3.exe

You mean a command like ALTER TABLE? Maybe check the SQL Syntax available to SQLite (http://sqlite.org/lang_altertable.html) On Tue, Sep 30, 2008 at 4:09 PM, Ryan Walker <[EMAIL PROTECTED]> wrote: > Hi, > I have a database file in windows that I want to connect to with > sqlite3.exe so I can add a

Re: [sqlite] how to connect to existing db with sqlite3.exe

Hi Enrique, I'm not referring to the syntax. I know the syntax. I'm wondering how to connect to a local database with sqlite3.exe. That is, how do I tell sqlite3.exe where the database file is on my computer? When I use the .databases command, my database is not listed, so I assume I need to

Re: [sqlite] how to connect to existing db with sqlite3.exe

On 9/30/08, Ryan Walker <[EMAIL PROTECTED]> wrote: > Hi Enrique, > I'm not referring to the syntax. I know the syntax. I'm wondering how > to connect to a local database with sqlite3.exe. That is, how do I tell > sqlite3.exe where the database file is on my computer? When I use the > .datab

Re: [sqlite] how to connect to existing db with sqlite3.exe

I think that the problem is with your understanding of what the .databases command does. I could be mistaken, but I thought is only listed attached databases. It is not a command to search for possible databases that may exist on your file system. So when you use the command: sqlite3 foo.db T

Re: [sqlite] how to connect to existing db with sqlite3.exe

Thanks. That's what I needed. I didn't get your earlier message because I signed up for the digest. My problem was that I was just clicking on sqlite3.exe instead of running it from the command line. -Ryan P Kishor wrote: > On 9/30/08, Ryan Walker <[EMAIL PROTECTED]> wrote: > >> Hi Enr

[sqlite] more on networked file access failures

I tracked the initial failure into sqlite3WinDelete, which is used to delete journal files. There is a semi-kludge to retry the deletion, based on the ad-hoc observation that sometimes the delete fails because some other process has the file open. Two observations: (1) the retry count of 3 seem

Re: [sqlite] SQLITE_CONFIG_SERIALIZED

D. Richard Hipp wrote: > > SQLITE_CONFIG_SERIALIZED has been the default behavior since version > 3.5.0. All it does is move the locks to inside of SQLite so that your > application code does not have to mess with them. It does not > magically provide you any additional concurrency. > R

Re: [sqlite] Can't insert timestamp field with value CURRENT_TIME

On Sep 27, 2008, at 7:13 AM, Mark Wyszomierski wrote: > Hi, > > I'm trying to add a timestamp field to an existing table using the > following > statement: > >ALTER TABLE test ADD COLUMN lunchtime TIMESTAMP NOT NULL DEFAULT > CURRENT_TIME > > this fails with the following error: > >Cann

Re: [sqlite] macro redefinition

I tried the first option you suggested , i get the following error log : -- Build started: Project: Source Tagging System, Configuration: Debug Win32 -- Compiling... sqlite3.c c:\Documents and Settings\Administrator\My Documents\Visual Studio Projects\Source Tagging System\sqlite-amalgam