Re: [sqlite] Memory DB to disk DB

Very good Keith. I think this will work fine for me. thanks Quoting Keith Herold <[EMAIL PROTECTED]>: > I am/was doing this in application, with 2.8.15 . I simply attached > the on-disk database to the memory, and then wrote a bunch of dump > queries to drop the memory data to disk (from the m

Re: [sqlite] Memory DB to disk DB

I am/was doing this in application, with 2.8.15 . I simply attached the on-disk database to the memory, and then wrote a bunch of dump queries to drop the memory data to disk (from the memory db connection): ATTACH 'C:\my_database_on_disk.sqlitedb' AS diskdb ; Unfortunately, I don't think you ca

Re: [sqlite] Memory DB to disk DB

I gues you could attach in-memory db to a newly created disk db and then do something like CREATE TABLE newDiskTbl AS SELECT * FROM memoryTbl Take a look at http://www.sqlite.org/lang_createtable.html for more details Regards, chorlya On Fri, 18 Feb 2005 11:13:40 +1100, [EMAIL PROTECTED] <[EMA

RE: [sqlite] BLOB versus table storage

That's not "good database design", it's relational dogma. Good database design involves understand what data needs to be stored and *how it's going to be accessed*, which John hasn't told us in detail. If you don't need to access individual point relationally, and only are going to process entire

[sqlite] Memory DB to disk DB

I have a situation where I start with an in-memory DB, then need to save the entire thing to a new disk DB. Does anyone know the best way to do this? Would I attach the memory DB to a newly created disk DB? Is this even possible? I notice the COPY command is not supported in 3.x according to t

Re: [sqlite] BLOB versus table storage

Clay Dowling wrote: [EMAIL PROTECTED] said: CREATE TABLE polygons (id INTEGER PRIMARY KEY, externalref INTEGER, pointcount INTEGER, pointlist BLOB) When I insert data to this table, I have to write a binary list of x,y coordinates in a sequential memory region before storing in the database. Get

[sqlite] Journalling Settings

Hello everyone. I can see that the journal settings for the SQLite DB are buried deep within the code, so I figured I would ask before I go meddling. Is there a simple / easy / proper way to disable journalling for a given database? Can this be done on the fly ( on / off ), or is it possible

[sqlite] Using sqlite3_get_table get a row, modifing the row, and then updating the row in the sqlite datatabase obtain from sqlite3_get_table

I retrieved some rows from a sqlite database using the sqlite3_get_table function. Some of these rows are these are modified. How do I have these rows update the same sqlite database? Is there another sqlite function I can call passing the table that was retrieved from the sqlite3_get_table fu

Re: [sqlite] BLOB versus table storage

[EMAIL PROTECTED] said: > CREATE TABLE polygons (id INTEGER PRIMARY KEY, externalref INTEGER, > pointcount INTEGER, pointlist BLOB) > > When I insert data to this table, I have to write a binary list of x,y > coordinates in a sequential memory region before storing in the database. > Getting infor

Re: [sqlite] Re: AUTOINCREMENT Functionality by default required in 3.0.8 (Is it possible?)

[EMAIL PROTECTED] wrote: Hi Morten, Thanks for the help. I got the idea for doing this based on the trigger. I shall implement the same. Thanks once again for the help. Regards, Sankara Narayanan B morten bjoernsvik <[EMAIL PROTECTED]> 02/17/2005 03:06 PM Please respond to sqlite-users@sqlite.

Re: [sqlite] Basic insert statement - syntax problem

Asko Kauppi wrote: Still, shouldn't the 'mri_output' (table name) be quoted? 17.2.2005 kello 11:45, Anirban Sarkar kirjoitti: I am really very sorry. I mistyped the entire sql statement. This is what my actual code looks like: sqlite db1 "cesc_simputer.db" #Inserting data into mri_output table s

Re: [sqlite] Python bindings for SQLite 3?

On Thu, 17 Feb 2005 10:00:08 -0800, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > On Feb 17, 2005, at 9:53 AM, H. Wade Minter wrote: > > I'm playing around with some Python stuff, and was wondering if there > > were any reasonably stable bindings for SQLite 3? I've got an > > existing SQLite 3 da

Re: [sqlite] Python bindings for SQLite 3?

On Feb 17, 2005, at 9:53 AM, H. Wade Minter wrote: I'm playing around with some Python stuff, and was wondering if there were any reasonably stable bindings for SQLite 3? I've got an existing SQLite 3 database that I want to work against, so I'd rather not drop back to SQLite 2? I have been usi

[sqlite] Python bindings for SQLite 3?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm playing around with some Python stuff, and was wondering if there were any reasonably stable bindings for SQLite 3? I've got an existing SQLite 3 database that I want to work against, so I'd rather not drop back to SQLite 2? I've found http://w

Re: [sqlite] BLOB versus table storage

[EMAIL PROTECTED] wrote: Does anyone have a recommendation as to which solution would be more optimal, both for space and processing time? Perhaps you should consider using Postgres. It has builtin support for polygons. It can index polygon columns. And it includes some builtin functions to wo

Re: [sqlite] BLOB versus table storage

[EMAIL PROTECTED] wrote: I have a fairly simple database design with a series of tables that reference graphical data. Currently, there is one table that contains the following: CREATE TABLE polygons (id INTEGER PRIMARY KEY, externalref INTEGER, pointcount INTEGER, pointlist BLOB) When I insert

RE: [sqlite] BLOB versus table storage

I agree. I have done similar work for GIS data. Unless you absolutely need access to inidvidual x,y data at the *sql* level, it is much better to use memory storage for these. And, if you plan to do operations like point-in-polygon, which I am sure you will, you need access to all the points at the

Re: [sqlite] Beginner Problem...

On Thu, 17 Feb 2005 16:34:07 +0100, Peter Berkenbosch <[EMAIL PROTECTED]> wrote: > Yes :) > > -Oorspronkelijk bericht- > Van: Claudio Bezerra Leopoldino [mailto:[EMAIL PROTECTED] > Verzonden: donderdag 17 februari 2005 16:25 > Aan: SQLiter Mailing List > Onderwerp: [sqlite] Beginner Proble

RE: [sqlite] Beginner Problem...

EG: % sqlite3 test.db < /data/temp/test.sql -Oorspronkelijk bericht- Van: Claudio Bezerra Leopoldino [mailto:[EMAIL PROTECTED] Verzonden: donderdag 17 februari 2005 16:25 Aan: SQLiter Mailing List Onderwerp: [sqlite] Beginner Problem... I've used SQLite utility to learn about the librar

Re: [sqlite] INSERT, UPDATE or..?

On Thu, 17 Feb 2005 01:22:38 +0200, Asko Kauppi <[EMAIL PROTECTED]> wrote: > > Please help me refine the following SQL. I have pretty much all the C > code in place, table creation & detection works, then.. brick wall. > > I cannot add a single small text string into the table. What am I doing >

RE: [sqlite] Beginner Problem...

Yes :) -Oorspronkelijk bericht- Van: Claudio Bezerra Leopoldino [mailto:[EMAIL PROTECTED] Verzonden: donderdag 17 februari 2005 16:25 Aan: SQLiter Mailing List Onderwerp: [sqlite] Beginner Problem... I've used SQLite utility to learn about the library, but have a doubt... I need to sub

Re: [sqlite] BLOB versus table storage

On Thu, 2005-02-17 at 10:12 -0500, [EMAIL PROTECTED] wrote: > Does anyone have a recommendation as to which solution would be more > optimal, both for space and processing time? In a worst case > scenario, I could insert over 1 million polygons, resulting in a max > 20 million point list table. >

[sqlite] Beginner Problem...

I've used SQLite utility to learn about the library, but have a doubt... I need to submit sql text scripts to the utility instead of command line sql code. It´s possible? Cláudio Leopoldino ___ Yahoo! Ace

[sqlite] SQLite for didatic purposes...

Hi, I think to use SQLite for didactical purposes but i want to start with some aditional information about the results, activities performed the possible didatic uses of sqlite. Do you have some experience using SQLite to teach about DBMS? There is some known article or book about this specific

[sqlite] BLOB versus table storage

I have a fairly simple database design with a series of tables that reference graphical data. Currently, there is one table that contains the following: CREATE TABLE polygons (id INTEGER PRIMARY KEY, externalref INTEGER, pointcount INTEGER, pointlist BLOB) When I insert data to this table, I h

Re: [sqlite] Basic insert statement - syntax problem

On Thu, 17 Feb 2005, Anirban Sarkar wrote: >I am really very sorry. >I mistyped the entire sql statement. >This is what my actual code looks like: > >sqlite db1 "cesc_simputer.db" > >#Inserting data into mri_output table > set connection_no { } > set insert_normal "insert into mri_output (pwd,ac

RE: [sqlite] Getting metadata

SELECT * FROM SQLITE_MASTER WHERE type = 'table' There's an explanation of the SQLITE_MASTER table at http://sqlite.org/faq.html Jeff Dinsmore MIS - Interfaces Ridgeview Medical Center [EMAIL PROTECTED] 952.442.2191 x6592 -Original Message- From: Sijmen Mulder [mailto:[EMAIL PROTECTED]

Re: [sqlite] Getting metadata

SELECT name FROM sqlite_master WHERE type = 'table' Best regards, Witold Czarnecki - Original Message - From: "Sijmen Mulder" <[EMAIL PROTECTED]> To: Sent: Thursday, February 17, 2005 3:22 PM Subject: Re: [sqlite] Getting metadata PRAGMA table_info(table-name); http://sqlite.org/pragma.

Re: [sqlite] Getting metadata

PRAGMA table_info(table-name); http://sqlite.org/pragma.html That's just what I was looking for. Thank you very much! It looks very good, but is there also a way to query the currently opened database to get a list of tables?

Re: [sqlite] Getting metadata

PRAGMA table_info(table-name); http://sqlite.org/pragma.html That's just what I was looking for. Thank you very much! Sijmen Mulder

Re: [sqlite] Getting metadata

PRAGMA table_info(table-name); http://sqlite.org/pragma.html - Original Message - From: "Sijmen Mulder" <[EMAIL PROTECTED]> To: Sent: Thursday, February 17, 2005 3:03 PM Subject: [sqlite] Getting metadata Hi there, Is there a way to get information about the format of the database from

[sqlite] Getting metadata

Hi there, Is there a way to get information about the format of the database from an appication? IE, I would like to know whether collumn x or table y does exist, and what type they are. So, is it possible to get this information with SQLite? Thanks in advance, Sijmen Mulder

[sqlite] Re: SQlite 3.1.2 autoconf problem

"D. Richard Hipp" <[EMAIL PROTECTED]> writes: > On Wed, 2005-02-16 at 21:31 +0100, Andreas Rottmann wrote: >> > >> > Does check-in [2346] help? >> > http://www.sqlite.org/cvstrac/chngview?cn=2346 >> > >> >From a quick glance, this should fix it. I'll add this patch to >> Debian's 3.1.2 packaging.

Re: [sqlite] Unrecognised token error in insert statement

> > From: "Anirban Sarkar" <[EMAIL PROTECTED]> > Date: 2005/02/17 Thu AM 10:51:08 GMT > To: > Subject: [sqlite] Unrecognised token error in insert statement > The variable $system_tm contains the value 16:40 > When I try to insert this value in a varchar field in a sqlite table it gives > me '

Re: [sqlite] Basic insert statement - syntax problem

17.2.2005 kello 11:45, Anirban Sarkar kirjoitti: I mistyped the entire sql statement. This is what my actual code looks like: sqlite db1 "cesc_simputer.db" #Inserting data into mri_output table set connection_no { } set insert_normal "insert into mri_output (pwd,ac_my,con_no) values ('$pass',

[sqlite] Unrecognised token error in insert statement

The variable $system_tm contains the value 16:40 When I try to insert this value in a varchar field in a sqlite table it gives me ' unrecognised token ":" ' due to which the insertion process fails. How do I get rid of this? Probably should be some addslashes or some other stuff, but I am not qui

Re: Re: [sqlite] Basic insert statement - syntax problem

Thanks Lawrence, once again. Regards, Anirban - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Thursday, February 17, 2005 3:46 PM Subject: Re: Re: [sqlite] Basic insert statement - syntax problem > > > > > From: "Anirban Sarkar" <[EMAIL PROTECTED]> > > Date: 2005/02/17 Thu AM

Re: [sqlite] Basic insert statement - syntax problem

Still, shouldn't the 'mri_output' (table name) be quoted? 17.2.2005 kello 11:45, Anirban Sarkar kirjoitti: I am really very sorry. I mistyped the entire sql statement. This is what my actual code looks like: sqlite db1 "cesc_simputer.db" #Inserting data into mri_output table set connection_no {

Re: Re: [sqlite] Basic insert statement - syntax problem

> > From: "Anirban Sarkar" <[EMAIL PROTECTED]> > Date: 2005/02/17 Thu AM 09:45:03 GMT > To: > Subject: Re: [sqlite] Basic insert statement - syntax problem > > #Inserting data into mri_output table > set connection_no { } > set insert_normal "insert into mri_output (pwd,ac_my,con_no) values

Re: [sqlite] Re: AUTOINCREMENT Functionality by default required in 3.0.8 (Is it possible?)

Hi Morten, Thanks for the help. I got the idea for doing this based on the trigger. I shall implement the same. Thanks once again for the help. Regards, Sankara Narayanan B morten bjoernsvik <[EMAIL PROTECTED]> 02/17/2005 03:06 PM Please respond to sqlite-users@sqlite.org To sqlite-users@

Re: [sqlite] Basic insert statement - syntax problem

I am really very sorry. I mistyped the entire sql statement. This is what my actual code looks like: sqlite db1 "cesc_simputer.db" #Inserting data into mri_output table set connection_no { } set insert_normal "insert into mri_output (pwd,ac_my,con_no) values ('$pass','$ac_mth$ac_yr','$sel_co

Re: [sqlite] Re: AUTOINCREMENT Functionality by default required in 3.0.8 (Is it possible?)

Hi You can easily fix this trick with the "insert null to and integer primary key" trick or by using a trigger. Use a reference value you either increase or decrease, or count to set for new values. % cat /data/temp/test.sql .header on create table test ( num integer, num2

[sqlite] Cannot compile using CygWin

Hello all,   I cannot compile SQLite 3 anymore (I used to before) using CygWin. I update files daily from CVS, but when I try to run autoconf I get the following:   configure.ac:357: warning: AC_CANONICAL_HOST invoked multiple timesautoconf/specific.m4:363: AC_CYGWIN is expanded from...config

Re: [sqlite] Basic insert statement - syntax problem

The error messages provided by SQLite seem to be very helpful, can you use them? like: if (rc) glua_errorN( "sqlite3 error %d: %s", rc, sqlite3_errmsg(db) ); Aside that, shouldn't the table name (mri) have quotes ('mri')? What's the $con_no doing without quotes as well. Use ?1 for binding stu

Re: [sqlite] Versions 2.8.16 and 3.1.2

On Tue, Feb 15, 2005 at 08:23:59AM -0500, D. Richard Hipp wrote: > Version 3.1.2 is also (by coincidence) the first stable release > of the 3.1 line. SQLite 3.1 adds support for correlated subqueries, > autovacuum, autoincrement, ALTER TABLE, and other features. > > Please let me know if you find

Re: [sqlite] Re: AUTOINCREMENT Functionality by default required in 3.0.8 (Is it possible?)

Didn't SQLite provide commercial support somewhere..? I'm sure this is not an open source issue, since no-one dealing there would "not have time to upgrade". Funny, I'm sad for your timetables. -ak 17.2.2005 kello 10:02, [EMAIL PROTECTED] kirjoitti: Hi, A soft reminder. Please inform if the bel

[sqlite] Basic insert statement - syntax problem

Hi all, I am having syntax problem with a basic sqlite insert statement. I know it's very simple but just could'nt make out where I am going wrong. set insert_details "insert into mri (pwd,con_no) values ('$pwd',$con_no)" Where am I going wrong? Thanks and regards, Anirban Sarkar

[sqlite] Re: AUTOINCREMENT Functionality by default required in 3.0.8 (Is it possible?)

Hi, A soft reminder. Please inform if the below mentioned request is a possibility? Regards, Sankara Narayanan. Sankara Narayanan/BTC/PIN/PHILIPS 02/14/2005 05:40 PM To SQLITE cc Subject AUTOINCREMENT Functionality by default required in 3.0.8 Hi, I am currently using Sqlite3.0.8 in