Re: [sqlite] Tidy Up Schema

Murray Moffatt wrote: I would like to tidy up the schema's of a few tables. At the moment all of the fields run together on the same line, i.e. something like this: sqlite> .schema materials CREATE TABLE Materials (MaterialType varchar(10) not null, MaterialCode varchar( 10) not null,

[sqlite] Tidy Up Schema

I would like to tidy up the schema's of a few tables. At the moment all of the fields run together on the same line, i.e. something like this: sqlite> .schema materials CREATE TABLE Materials (MaterialType varchar(10) not null, MaterialCode varchar( 10) not null, Description

[sqlite] Newbie

Hi, I have just compiled Sqlite for PowerPc 8XX and I'm trying to open a new database but i'm getting the error below. /mnt/nfs/TesteSqlite # ./sqlite test.db ./sqlite: error while loading shared libraries: libsqlite.so.0: cannot open shared object file: No such file or directory I try to

Re: [sqlite] 128-bit numbers

Christopher Petrilli wrote: On 5/3/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote: On Tue, 2005-05-03 at 17:52 -0400, Christopher Petrilli wrote: I'm wondering if the availability of 128-bit numbers has ever been contemplated? The reason I'm asking is that I have an application that needs

Re: [sqlite] Newbie problem with locks and DB repair

On Tue, 2005-05-03 at 18:55 -0400, Tom Shaw wrote: At 6:09 PM -0400 5/3/05, D. Richard Hipp wrote: >On Tue, 2005-05-03 at 17:45 -0400, Tom Shaw wrote: >> Hi. >> >> I was using SQLite with PHP 5 (MacOSX) and due to some issues the php >> page timedout before completing the DB update. Now I

Re: [sqlite] 128-bit numbers

On Tue, 2005-05-03 at 18:25 -0400, Christopher Petrilli wrote: > On 5/3/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > > On Tue, 2005-05-03 at 17:52 -0400, Christopher Petrilli wrote: > > > I'm wondering if the availability of 128-bit numbers has ever been > > > contemplated? The reason I'm

Re: [sqlite] Newbie problem with locks and DB repair

On Tue, 2005-05-03 at 18:55 -0400, Tom Shaw wrote: > At 6:09 PM -0400 5/3/05, D. Richard Hipp wrote: > >On Tue, 2005-05-03 at 17:45 -0400, Tom Shaw wrote: > >> Hi. > >> > >> I was using SQLite with PHP 5 (MacOSX) and due to some issues the php > >> page timedout before completing the DB update.

Re: [sqlite] Newbie problem with locks and DB repair

At 6:09 PM -0400 5/3/05, D. Richard Hipp wrote: On Tue, 2005-05-03 at 17:45 -0400, Tom Shaw wrote: Hi. I was using SQLite with PHP 5 (MacOSX) and due to some issues the php page timedout before completing the DB update. Now I can't read the DB via php nor via the sqlite command line tool. I

Re: [sqlite] 128-bit numbers

On 5/3/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > On Tue, 2005-05-03 at 17:52 -0400, Christopher Petrilli wrote: > > I'm wondering if the availability of 128-bit numbers has ever been > > contemplated? The reason I'm asking is that I have an application that > > needs to store IPv6

Re: [sqlite] Newbie problem with locks and DB repair

On Tue, 2005-05-03 at 17:45 -0400, Tom Shaw wrote: > Hi. > > I was using SQLite with PHP 5 (MacOSX) and due to some issues the php > page timedout before completing the DB update. Now I can't read the > DB via php nor via the sqlite command line tool. I keep getting DB > busy/DB locked. How

[sqlite] 128-bit numbers

I'm wondering if the availability of 128-bit numbers has ever been contemplated? The reason I'm asking is that I have an application that needs to store IPv6 addresses, which are 128bits. Right now, I'm storing them in 2 64-bit fields, but this obviously complicates the query quite a bit.

[sqlite] Newbie problem with locks and DB repair

Hi. I was using SQLite with PHP 5 (MacOSX) and due to some issues the php page timedout before completing the DB update. Now I can't read the DB via php nor via the sqlite command line tool. I keep getting DB busy/DB locked. How do I repair the DB and remove the "lock"and either 1) try to

[sqlite] Variable-length records

Hi, The SQLite documentantion 'Distinctive Features' says: "If you store a single character in a VARCHAR(100) column, then only a single byte of disk space is consumed. (Actually two bytes - there is some overhead at the beginning of each column to record its datatype and length.)" I would like

RE: [sqlite] Pragmas

Understood. I fall into case 5, and this is definitely not the way they're represented. So assuming my code was correct, and the documentation refers to 3.2.1, the documentation is STILL incorrect? Regards, Steve -Original Message- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent:

Re: [sqlite] Pragmas

On Tue, 2005-05-03 at 15:09 +0100, Drew, Stephen wrote: > This is not the case for the version of SQLite 3.2.1 I am using. Is > the documentation incorrect, or am I doing anything wrong? > Documentation is wrong. See http://www.sqlite.org/cvstrac/wiki? p=ColumnNames -- D. Richard Hipp

[sqlite] Pragmas

Hello, Sorry to keep on harping on about this, but the documentation for the full_column_names pragma states clearly: "...Normally, such result columns are named if the SELECT statement joins two or more tables together, or simply if the SELECT statement queries a single table." This is

RE: [sqlite] SqliteExplorer and ISO8601 dates

Mike if you are working on dates, I also noticed that SqliteExplorer parses dates in sql statements (even with "Use Datatypes" off). As a simple example, the following works fine with sqlite directly but not through SE SELECT DATE('2005-04-02T00:00:00') Thanks, -Brad