Re: [sqlite] Compiling 3.6.11 on Solaris results in runtime segmentation fault

On Mar 14, 2009, at 5:47 AM, David Jones wrote: > I am compiling 3.6.11 from amalgamated sources on Solaris and I get a > Segmentation Fault whenever I type something at the shell. Pasted > below are some information which might be helpful. Does anyone else > see this error or have a workaround?

Re: [sqlite] Problem with table refactoring

"Rand Huck" wrote in message news:d232e14b0903131809x74e4f0cdn9264d4a4e...@mail.gmail.com > Sorry, that was the result of my genericizing the code. The code I > have does > not have the trailing comma. So, does the code that you show exhibit the problem you are asking about? My crystal ball

Re: [sqlite] Problem with table refactoring

I just found the problem. I was executing this from a file, but was splitting the file by the ';' delimiter and executing it accordingly. Of course, that produces an array whose last element is an empty string. I tacked on a ';' at the end of that, producing this error. Carry on. :P I need a beer.

Re: [sqlite] Problem with table refactoring

"Rand Huck" wrote in message news:d232e14b0903131800j53e59f56ic8e19b1d94bd7...@mail.gmail.com > When I execute this, SQLite gives me a very useless error code: -1 > with no additional information. Define "gives". How do you obtain this error code? Normally, SQLite error codes are positive intege

Re: [sqlite] Problem with table refactoring

Sorry, that was the result of my genericizing the code. The code I have does not have the trailing comma. On Fri, Mar 13, 2009 at 9:03 PM, Igor Tandetnik wrote: > "Rand Huck" wrote in > message > news:d232e14b0903131800j53e59f56ic8e19b1d94bd7...@mail.gmail.com > > CREATE TABLE `tbl` ( > > `id`

Re: [sqlite] Problem with table refactoring

"Rand Huck" wrote in message news:d232e14b0903131800j53e59f56ic8e19b1d94bd7...@mail.gmail.com > CREATE TABLE `tbl` ( > `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL, > `title`varchar(255), > `body`text, > `isRead` integer(1), > `isExpired`

[sqlite] Problem with table refactoring

I am refactoring a table for an Adobe AIR application a little bit and am calling the following statements: CREATE TEMPORARY TABLE `tbl_backup` ( `id` integer, `title`varchar(255), `body`text, `status`varchar(16) ); INSERT INTO

[sqlite] Compiling 3.6.11 on Solaris results in runtime segmentation fault

I am compiling 3.6.11 from amalgamated sources on Solaris and I get a Segmentation Fault whenever I type something at the shell. Pasted below are some information which might be helpful. Does anyone else see this error or have a workaround? I get the same behavior when I run in gdb or just from th

Re: [sqlite] Query Doesn't Find Record

Kees Nuyt wrote: > >>What are you folks using to type these queries? I've yet to find any good >>utilities that do this for the Windows platform. > > sqlite3.exe in a CMD window. > > And SQLiteSPy for browsing databases. > Thanks! Jonathan -- View this message in context: http://www.nabb

Re: [sqlite] Query Doesn't Find Record

On Fri, 13 Mar 2009 12:42:46 -0700 (PDT), jonwood wrote: > > >P Kishor-3 wrote: >> >> why don't you try it? See below -- >> > >What are you folks using to type these queries? I've yet to find any good >utilities that do this for the Windows platform. sqlite3.exe in a CMD window. If I suspect

Re: [sqlite] Upgrade from 3.5.9 to 3.6.11

On Mar 13, 2009, at 9:22 PM, Kees Nuyt wrote: > On Fri, 13 Mar 2009 08:57:35 -0700 (PDT), Joanne Pham > wrote: > >> Hi All, >> We have a application using SQLite 3.5.9 now >> and we will be releasing this product in June. >> I am think about upgrading SQLite from 3.5.9 to >> SQLite 3.6.11 but I

Re: [sqlite] datetime as integer

I stand corrected on the math Bottom line is that different applications use different baseline values for epoch (beginning of time) and you must know that baseline value --Original Message-- From: Kees Nuyt Sender: sqlite-users-boun...@sqlite.org To: sqlite-users@sqlite.org ReplyTo: sqli

Re: [sqlite] Upgrade from 3.5.9 to 3.6.11

On Fri, 13 Mar 2009 08:57:35 -0700 (PDT), Joanne Pham wrote: > Hi All, > We have a application using SQLite 3.5.9 now > and we will be releasing this product in June. > I am think about upgrading SQLite from 3.5.9 to > SQLite 3.6.11 but I don't know what are the > impact for the application and i

Re: [sqlite] Query Doesn't Find Record

P Kishor-3 wrote: > > why don't you try it? See below -- > What are you folks using to type these queries? I've yet to find any good utilities that do this for the Windows platform. Thanks. Jonathan -- View this message in context: http://www.nabble.com/Query-Doesn%27t-Find-Record-tp2246

Re: [sqlite] datetime as integer

You could just try this and see what happens: char *ctime(const time_t *timer); The returned string is in the following format: DDD MMM dd hh:mm:ss You may just be surprised or not! Michael -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-bou

Re: [sqlite] datetime as integer

You could of course just try this and see what happens: -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Kees Nuyt Sent: Friday, March 13, 2009 2:58 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] datetime as integer Just

Re: [sqlite] datetime as integer

Just a few corrections. On Fri, 13 Mar 2009 13:48:46 +, "Timothy A. Sawyer" wrote: >To be able to do this you need the following data points: > >1. What is the integer representation of the date? > Is it days or seconds from a certain date? > Keep in mind that 1 day = 86400 seconds = 3

Re: [sqlite] Advices to get max performance with SQLITE and BLOBS

Hello, > Have you considered storing the blob data into a file? > Just keep a record of the blob in the sqlite.db if you store all the > blobs in a single file then you'll need a filename, begin, length. > Or if one blob per file just the filename.. > Just an idea. Not really sure which would

Re: [sqlite] Merging two SQLites + leaving out duplicates?

"Adam DeVita" wrote in message news:804081910903130900r6c615f02u2b72ba810cccf...@mail.gmail.com > Suppose you have a field that time stamps the date each company's data > was entered. > > Unfortunately some records in old2.db have newer contact information, > while others are older than in old1.db

Re: [sqlite] Merging two SQLites + leaving out duplicates?

Good day, I'd like to tack on an additional question, since it is a common case applied to the goal of this thread. Suppose you have a field that time stamps the date each company's data was entered. Unfortunately some records in old2.db have newer contact information, while others are older than

[sqlite] Upgrade from 3.5.9 to 3.6.11

Hi All, We have a application using SQLite 3.5.9 now and we will be releasing this product in June.  I am think about upgrading SQLite from 3.5.9 to SQLite 3.6.11 but I don't know what are the impact for the application and is it worth to upgrade SQLite to newest one before the product is releas

Re: [sqlite] Proposal for SQLite and non pure ASCII letters

"Jean-Christophe Deschamps" schrieb im Newsbeitrag news:7.0.1.0.2.20090312013713.0262b...@q-e-d.org... > Perhaps the best way is practice: what's the way to find > this guy named Éric or is it éric, or Eric, or eric? > He lives in MÜNCHEN, München, MUNCHEN, > Munchen or ... Munich. IMO that's n

Re: [sqlite] Advices to get max performance with SQLITE and BLOBS

Pierre, Have you considered storing the blob data into a file? Just keep a record of the blob in the sqlite.db if you store all the blobs in a single file then you'll need a filename, begin, length. Or if one blob per file just the filename.. Just an idea. Not really sure which would be faste

Re: [sqlite] how to divide a database?

on lower half.. attach database 'yourdbname' as full; insert into table1 select * from full.table1 where col1 < 'your mid point value'; on upper half attach database 'yourdbname' as full; insert into table1 select * from full.table1 where col1 >= 'your mid point value'; You'll need a uniqu

Re: [sqlite] WHERE clause doesn't seem to work right

On Mar 13, 2009, at 10:10 PM, Fitter Man wrote: > > @John: Is that documented anywhere? I ask because there are some > cases I'd > like to understand better without going through a lot of testing to > determine how it works. I'm inferring from your example the rule is > all > numerics come f

Re: [sqlite] Merging two SQLites + leaving out duplicates?

"Gilles Ganault" wrote in message news:bcqkr45c944gv4g1h9ovpjq1ood1i1v...@4ax.com > On Fri, 13 Mar 2009 09:52:25 -0400, "Igor Tandetnik" > wrote: > Thank you Igor for the help. Before I give it a shot, I need to speciy > those requirements: > 1. The tables live in two SQLite database files, so I

Re: [sqlite] WHERE clause doesn't seem to work right

See section 3.0 http://www.sqlite.org/datatypes.html Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Fitter Man Sent: Friday, March 13, 2009 11:10 AM To: sq

Re: [sqlite] WHERE clause doesn't seem to work right

@John: Is that documented anywhere? I ask because there are some cases I'd like to understand better without going through a lot of testing to determine how it works. I'm inferring from your example the rule is all numerics come first, with integer and floats interleaved according to their numeri

Re: [sqlite] WHERE clause doesn't seem to work right

Fitter Man wrote: > I tried something for kicks and it worked. I flipped all the column > definitions from VARCHAR(255) to INTEGER and my query, above, works > properly. I did a little reading and found this described my problem: > http://www.sqlite.org/datatypes.html . > > > Q: Is their some inver

Re: [sqlite] Merging two SQLites + leaving out duplicates?

On Fri, Mar 13, 2009 at 9:14 AM, Gilles Ganault wrote: > On Fri, 13 Mar 2009 09:52:25 -0400, "Igor Tandetnik" > wrote: > (snip) > > Thank you Igor for the help. Before I give it a shot, I need to speciy > those requirements: > 1. The tables live in two SQLite database files, so I must open both >

Re: [sqlite] WHERE clause doesn't seem to work right

I tried something for kicks and it worked. I flipped all the column definitions from VARCHAR(255) to INTEGER and my query, above, works properly. I did a little reading and found this described my problem: http://www.sqlite.org/datatypes.html . Q: Is their some inverse problem now that all the c

Re: [sqlite] WHERE clause doesn't seem to work right

Fitter Man wrote: > I've just started using Sqlite and something seems wrong. I'm sure I'm making > a mistake, but can't spot it. > > I have a process that loads data from an RSS feed into a database. All the > columns are defined as VARCHAR(255) but I figure that's irrelevant here > based on what

[sqlite] WHERE clause doesn't seem to work right

I've just started using Sqlite and something seems wrong. I'm sure I'm making a mistake, but can't spot it. I have a process that loads data from an RSS feed into a database. All the columns are defined as VARCHAR(255) but I figure that's irrelevant here based on what I've read about dynamic typ

Re: [sqlite] Fossil

D. Richard Hipp wrote: > On Mar 12, 2009, at 5:43 PM, John Elrick wrote: > > >> I just joined the Fossil newsgroup and posted two messages; one a >> documentation defect and the second a question. I don't know how much >> it's being monitored, so I wanted to give those concerned a heads up. >>

Re: [sqlite] Merging two SQLites + leaving out duplicates?

On Fri, 13 Mar 2009 09:52:25 -0400, "Igor Tandetnik" wrote: (snip) Thank you Igor for the help. Before I give it a shot, I need to speciy those requirements: 1. The tables live in two SQLite database files, so I must open both in the same client session 2. Each table may contain one or more recor

Re: [sqlite] datetime as integer

On 14/03/2009 12:48 AM, Timothy A. Sawyer wrote: > Most date representations are stored as seconds since 1-1-1970 depending on > the underlying OS This applies (fortunately) only to applications whose use for a date is related to unix-alike filesystems and nothing much else ... imagine a passp

Re: [sqlite] Merging two SQLites + leaving out duplicates?

"Gilles Ganault" wrote in message news:h0kkr4993udaujhneohd4nacpfnp73p...@4ax.com > I have two SQLites databases that I need to merge. Some companies are > found in both, so I'd like to only keep one record when this occurs. > > What would be the right way to do this? If the company name is decla

Re: [sqlite] datetime as integer

To be able to do this you need the following data points: 1. What is the integer representation of the date? Is it days or seconds from a certain date? Keep in mind that 1 day = 86400 seconds = 3600 minutes Most date representations are stored as seconds since 1-1-1970 depending on the underlyi

Re: [sqlite] how to divide a database?

On Fri, Mar 13, 2009 at 3:21 AM, baxy77bax wrote: > > ok, >  and how to construct a query that says; select data from table until row > number = 'middle point or so...'. > > or > > generally how to say; select 30 rows then transfer it into new table , then > select next 30 rows and do the same...

[sqlite] Merging two SQLites + leaving out duplicates?

Hello I have two SQLites databases that I need to merge. Some companies are found in both, so I'd like to only keep one record when this occurs. What would be the right way to do this? Thank you. ___ sqlite-users mailing list sqlite-users@sqlite.org h

Re: [sqlite] How to interrupt a running query in SQLite?

sqlite3_errcode() was not used, I was just checking the return code of sqlite3_step(), I read about the problem with sqlite3_step(), I will think about using sqlite3_prepare_v2(). It is returning with SQLITE_INTERRUPT if I use sqlite3_errcode(). Thanks for replying, Manohar On Fri, Mar 13, 2009 a

Re: [sqlite] How to interrupt a running query in SQLite?

On Mar 13, 2009, at 5:41 PM, manohar s wrote: > Thanks for that. I Should have searched that :). > > Now I am Executing the Vacuum query, and sqlite3_interrupt() is > called from > a different thread, It is interrupted. > But once interrupted query execution is failing with SQLITE_ERROR. > I

Re: [sqlite] How to interrupt a running query in SQLite?

No, I am using sqlite3_prepare(). Regards, Manohar.S On Fri, Mar 13, 2009 at 4:23 PM, Simon Davies < simon.james.dav...@googlemail.com> wrote: > 2009/3/13 manohar s : > > Thanks for that. I Should have searched that :). > > > > Now I am Executing the Vacuum query, and sqlite3_interrupt() is cal

Re: [sqlite] How to interrupt a running query in SQLite?

2009/3/13 manohar s : > Thanks for that. I Should have searched that :). > > Now I am Executing  the Vacuum query, and sqlite3_interrupt() is called from > a different thread, It is interrupted. > But once interrupted query execution is failing with SQLITE_ERROR. It has to > fail with SQLITE_INTERR

Re: [sqlite] How to interrupt a running query in SQLite?

Thanks for that. I Should have searched that :). Now I am Executing the Vacuum query, and sqlite3_interrupt() is called from a different thread, It is interrupted. But once interrupted query execution is failing with SQLITE_ERROR. It has to fail with SQLITE_INTERRUPT right? sqlite3_errmsg() is r

Re: [sqlite] SQLite Database Corruption

On Fri, 13 Mar 2009 14:17:12 +0530, "Chaitali" wrote: >I am using SQLite database on Windows XP Professional as a back-end for my >application in VB6. Generally SQLite is functioning satisfactorily except >for a few instances when the database is getting corrupted. In one such case >of corruption

[sqlite] Advices to get max performance with SQLITE and BLOBS

Hello, I am using SQLITE to store and retrieve raw data blocks that are basically ~300Ko. Each block has an int identifier, so that insert/ select are easy. This is a very basic use : I do not use complex queries. Only "INSERT/SELECT where index=..." Now, I am thinking about performance, for

[sqlite] SQLite Database Corruption

I am using SQLite database on Windows XP Professional as a back-end for my application in VB6. Generally SQLite is functioning satisfactorily except for a few instances when the database is getting corrupted. In one such case of corruption the data from two tables got intermingled. In another case

Re: [sqlite] datetime as integer

2009/3/13 John Machin : > On 12/03/2009 12:21 AM, Nicolás Solá wrote: >> Hi I’m using Trac software and it is implemented using SQLITE3. In Trac DB >> schema there is a table called “milestone”. It has a field called “due” and >> it means due date. The problem is that it uses an integer data type t

Re: [sqlite] how to divide a database?

ok, and how to construct a query that says; select data from table until row number = 'middle point or so...'. or generally how to say; select 30 rows then transfer it into new table , then select next 30 rows and do the same... and so on until you reach the end iteration is not such a probl