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
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
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]
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
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
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.
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
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
[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
[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
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
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
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
-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
[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
[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
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
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
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
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
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
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.
>
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!
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
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
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
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]
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);
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?
PRAGMA table_info(table-name);
http://sqlite.org/pragma.html
That's just what I was looking for. Thank you very much!
Sijmen Mulder
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
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
"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.
>
> 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
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
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]>
>
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 {
>
> 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
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
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
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
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
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
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
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
45 matches
Mail list logo