Re: [sqlite] Introspection and RowID / INTEGER PRIMARY KEY

On 20 May 2010, at 1:21am, Andrew Rodland wrote: > I understand that, but that's not what I need. I'm working on the code that > loads a database schema into an ORM, and I need to properly set the flag > "is_auto_increment" which is used to identify a column that will be > automatically set by

Re: [sqlite] Accessing SQLite from PHP5?

On Tue, 18 May 2010 09:49:49 -0400, Gilles Ganault wrote: > On Tue, 18 May 2010 14:30:06 +0100 (BST), Swithun Crowe > wrote: >> If you use PDO, then you get access to Sqlite 3.x databases: >> >> http://www.php.net/manual/en/ref.pdo-sqlite.php > > Thanks for the input. After following the follo

Re: [sqlite] Proposed: drop support for LinuxThreads

On May 19, 2010, at 6:35 PM, Mike Frysinger wrote: > On Wednesday 12 May 2010 11:43:13 D. Richard Hipp wrote: >> If we drop support for (the non-standard, non-compliant) LinuxThreads >> threading library and instead support only standard Posix threads >> implemented using NPTL, beginning with SQL

Re: [sqlite] SQLite file Validation

> Devs were told to make sure they are validating their sql statements, > but as I have seen in the code, few of them have > Question: Do you think that instead of getting them go back throughout > their code, it is feasible to create a function that just eliminates the ; > and replaces it wit

Re: [sqlite] Leading zeros disappear

Thanks to all who replied! Single quotes? How simple...I used double quotes... Ted -- __ 3.14159265358979323846264338327950 Let the spirit of pi 2884197169399375105820974944592307 spread all over the world! 8164062862089986

Re: [sqlite] SQLite file Validation

On May 19, 2010, at 12:46, seandakid wrote: > Thanks for the quick reply Dustin. That was my concern as well.. it might > create more issues than it will solve. > > One of the devs suggested this code example: > > int makeSQLtight(const TCHAR* update); I'm all for developer laziness,

Re: [sqlite] SQLite file Validation

I do need to add that the docs say the create_function must be done in the same thread as the defined funtion is running. So if you're mutli-threaded it won't work unless each thread defines it (still doable though). Michael D. Black Senior Scientist Northrop Grumman Mission Systems __

Re: [sqlite] SQLite file Validation

When you say "create a function" -- sure you can write your own program that would do that -- but it sounds like you want something to intercept all the calls, yes? You could create an insert or update trigger. Then write your own cleanup sqlite function to stick in the trigger. Shouldn't b

Re: [sqlite] SQLite file Validation

Thanks for the quick reply Dustin. That was my concern as well.. it might create more issues than it will solve. One of the devs suggested this code example: int makeSQLtight(const TCHAR* update); S Dustin Sallings wrote: > > > On May 19, 2010, at 12:24, seandakid wrote: > >> Question: Do

Re: [sqlite] Leading zeros disappear

Are you putting single quotes around it? That's what you need. sqlite> create table text (t1 text, t2 varchar); sqlite> insert into text values ('01234','01234'); sqlite> select * from text; 01234|01234 sqlite> insert into text values (01234,01234); sqlite> select * from text; 01234|01234 1234|123

Re: [sqlite] Leading zeros disappear

On Wed, May 19, 2010 at 03:36:03PM -0400, Ted Rolle, Jr. scratched on the wall: > I'm entering UPCs. > > 0071318119 becomes 71318119. This is not good, or expected, for that > matter Are you entering 0071318119 (a number) or are you entering '0071318119' (a string)? The number is already a

Re: [sqlite] SQLite file Validation

On May 19, 2010, at 12:24, seandakid wrote: > Question: Do you think that instead of getting them go back throughout their > code, it is feasible to create a function that just eliminates the ; and > replaces it with a ,? And if so, any suggested code? On one hand, you have something tha

[sqlite] Leading zeros disappear

I'm entering UPCs. 0071318119 becomes 71318119. This is not good, or expected, for that matter . The column is specified as TEXT. I thought that TEXT values went in 'as entered'. After reading the docs, Section 2.0: "If numerical data is inserted into a column with TEXT affinity it is converted

[sqlite] SQLite file Validation

Hi all, Total noob question for you guys: Background: I have a project where there are many components touching different SQLite dbs. Devs were told to make sure they are validating their sql statements, but as I have seen in the code, few of them have. On some components they have used the BIND

Re: [sqlite] Delete from FTS3 with ROWID really really slow.....

Try showing us an "explain" of your statements. Also seeing your table structure might help. I take it you have a lot of keywords (like multiple 100,000's) Michael D. Black Senior Scientist Northrop Grumman Mission Systems From: sqlite-users-boun...@sqli

[sqlite] Delete from FTS3 with ROWID really really slow.....

If I run the statement: delete from keyword where rowid in (SELECT idToDelete FROM keywordDeleteList); This statement takes an eternity even if there are only say 5 records in keywordDeleteList. Same thing if I do this: delete from keyword where rowid in (418458, 418541, 421168, 421326, 421367

Re: [sqlite] Introspection and RowID / INTEGER PRIMARY KEY

On 19 May 2010, at 12:05pm, Andrew Rodland wrote: > Is there any possibility that in a future version of SQLite, pragma > table_info > or some other pragma could return a simple boolean "this column is the rowid" > indicator? As demonstrated under "Goofy Behavior Alert" at > http://www.sqlite

[sqlite] Introspection and RowID / INTEGER PRIMARY KEY

Is there any possibility that in a future version of SQLite, pragma table_info or some other pragma could return a simple boolean "this column is the rowid" indicator? As demonstrated under "Goofy Behavior Alert" at http://www.sqlite.org/lang_createtable.html#rowid it is possible (if unlikely)

Re: [sqlite] Problem with CREATE TABLE AS and primary key

On Wed, May 19, 2010 at 02:49:05PM +0200, Raoul scratched on the wall: > Hi Simon, > > Thanks for your answer, I suppose by ", ..." in the create table command you > mean that I should explicitly specifying each column, which is exactly what > I didn't want to do in the first place. > > By your r

Re: [sqlite] Problem with CREATE TABLE AS and primary key

Hi Simon, Thanks for your answer, I suppose by ", ..." in the create table command you mean that I should explicitly specifying each column, which is exactly what I didn't want to do in the first place. By your response I guess that there is no other way of doing it then Well I will test and

Re: [sqlite] read only databases and in-memory databases

I was talking about using sleeps. I show 1ms minimum on my system. This code executes in 1 second so that makes the minimum sleep 1ms on my Linux system. #include struct timespec req; int main () { int i; for (i = 0; i < 1000; i++) { req.tv_nsec = 1; nanosleep (&req, NULL

Re: [sqlite] Problem with CREATE TABLE AS and primary key

On 19 May 2010 08:31, Raoul wrote: > Hi all, > > I have read that it’s not possible to alter an existing table to add a > primary key, this is causing me some troubles. I have a table “My_main_tbl” > from where I want to take a subset of rows in order to create a new table > with the exact same c

[sqlite] ANNOUNCE - Muldis D version 0.129.1

Greetings, I am pleased to announce that version 0.129.1 of the specification of the Muldis D language, for object-relational databases, has been released on CPAN. This release marks a milestone for Muldis D in that the /language specification/ is now fundamentally complete, with all of the impor

[sqlite] Problem with CREATE TABLE AS and primary key

Hi all, I have read that it’s not possible to alter an existing table to add a primary key, this is causing me some troubles. I have a table “My_main_tbl” from where I want to take a subset of rows in order to create a new table with the exact same columns. CREATE TABLE My_second_tbl AS SELECT