Re: [sqlite] Roadmap for SQLite

On Mon, Nov 2, 2009 at 5:26 PM, Scott Hess wrote: > And always remember that it's cheap to ask > - maybe the feature is in there, you just mis-understood something Whereby "it's cheap to ask" implies that it is "inexpensive to ask" and not "to ask is cowardly, impolite or

Re: [sqlite] How do you save time in a sqlite database?

On Mon, Nov 2, 2009 at 3:30 PM, Dale E. Moore wrote: > Hi Puneet; > > Thanks for your feedback! > > My complete picture is that I would I'd like to enter running, cycling, > walking times like hh:mm:ss.hundredths and have them saved magically as > DURATION in sqlite. Then I

Re: [sqlite] How do you save time in a sqlite database?

On Mon, Nov 2, 2009 at 2:12 PM, Dale E. Moore wrote: > Hi All; > > I want to enter my trip times. Enter where? You have been asking this question for a while now, but something tells me that you are not asking the complete question. Where do you want to enter the trip

Re: [sqlite] SUM(tripSeconds) and format output as days.hours:minutes:seconds.hundredths?

On Mon, Nov 2, 2009 at 1:08 PM, DaleEMoore wrote: > > Thanks David SELECT STRFTIME('%H:%M:%f',62.5,'unixepoch') works great for > seconds less than 1 day! > > I wonder what I should do where the time becomes days, weeks, months, years? I have no idea why you think it won't

Re: [sqlite] Table within a table??

+1 Jay, for explaining. another +1 for explaining so well. yet another +1 for explaining in such detailed. Heck, if you had written such a long post full of nonsense, you should have gotten +1. Since you wrote such a long post that is so useful and helpful to probably everyone, your post should

Re: [sqlite] How to make LIKE searches case-sensitive

On Sat, Oct 31, 2009 at 10:21 AM, Ted Rolle wrote: > I'd like to make LIKE '%Blah%/ only find 'Blah', and not 'blah'. http://www.sqlite.org/lang_expr.html#glob -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source

Re: [sqlite] How to skip the first field on .import

On Fri, Oct 30, 2009 at 9:35 AM, Ted Rolle wrote: > The first field in my table is ID primary integer autoincrement. First, change the above to ID INTEGER PRIMARY KEY > I read that if it is set to NULL it defaults to the maximum value > possible.  Not a Good Thing(tm). I

Re: [sqlite] feature proposal - strong but dynamic typing

I believe I understand Darren's point (whether or not I care for them is another story). On Fri, Oct 30, 2009 at 2:22 AM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Darren Duncan wrote: >> But on a newer SQLite that implements the stronger

Re: [sqlite] Table within a table??

On Fri, Oct 30, 2009 at 2:41 AM, mark m wrote: > Thanks very much!!  It also occurred to me that I could have a Table named > "case1" and another > named "case1workhist".  The RDBMS wouldn't know they were related but my > application could be > set up to know this. Expand

Re: [sqlite] SELECT * vs SELECT columns ?

On Thu, Oct 29, 2009 at 3:19 PM, Gerry Snyder wrote: > Beau Wilkinson wrote: >> >>  If the schema changes, a listing of every column can be invalidated, but >> the asterisk cannot > > OTOH, a listing of every column may catch a query which is no longer > valid,

Re: [sqlite] SELECT * vs SELECT columns ?

On Thu, Oct 29, 2009 at 2:59 PM, John Crenshaw wrote: >> If the schema changes, a listing of every column can be >> invalidated, but the asterisk cannot. > > This is only partly true. At some point, the code is going to need to > grab the individual fields, and that is

Re: [sqlite] FTS3 - closed ticket 3950 - bug still exists in 3.6.19

On Mon, Oct 26, 2009 at 12:40 PM, Wanadoo Hartwig <hartwig.wiesm...@wanadoo.nl> wrote: > > Am 26.10.2009 um 15:27 schrieb P Kishor: > > On Mon, Oct 26, 2009 at 9:17 AM, Scott Hess <sh...@google.com> wrote: > > The bug was closed with "cannot reproduce".

Re: [sqlite] FTS3 - closed ticket 3950 - bug still exists in 3.6.19

On Mon, Oct 26, 2009 at 9:17 AM, Scott Hess wrote: > The bug was closed with "cannot reproduce".  So IMHO either the bug > should be re-opened with the provided repro case, or a new bug should > be opened with the provided repro case. As listed in my earlier email, it can be

Re: [sqlite] FTS3 - closed ticket 3950 - bug still exists in 3.6.19

On Sun, Oct 25, 2009 at 12:47 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > >>> can you please re-open the ticket? This bug only occurs in >>> combination with FTS3. Using normal tables in triggers does not cause >>> any problems. > > The

Re: [sqlite] How does SQLite treat repeated expressions?

On Sun, Oct 25, 2009 at 10:56 AM, Kristoffer Danielsson wrote: > > Sure I can test this specific case, but my question is still relevant. Does > SQLite or does it not optimize repeated expressions? > > You are correct. Stated as above, your question is very valid

Re: [sqlite] How does SQLite treat repeated expressions?

On Sun, Oct 25, 2009 at 9:49 AM, Igor Tandetnik wrote: > Kristoffer Danielsson wrote: >> A: SELECT COUNT(DataID) FROM Data GROUP BY DataID ORDER BY COUNT(DataID); >> >> B: SELECT COUNT(DataID) AS X FROM Data GROUP BY DataID ORDER BY X; >> >> Is statement B faster than A? Why?

Re: [sqlite] FTS3 - closed ticket 3950 - bug still exists in 3.6.19

On Sun, Oct 25, 2009 at 5:33 AM, Wanadoo Hartwig wrote: > Hi Roger, > > I just downloaded SQLite3 version 3.6.19 and did the same testing as I > did before: > > CREATE TABLE Simple (ID integer primary key, Name text); > CREATE VIRTUAL TABLE SimpleFTS USING FTS3

[sqlite] Mac OS X Automator works on SQLite db

fascinating... one can feed it a file of commands, or even a string of commands, and the "Apply SQL" action will run against a specified or a newly created SQLite database and format the output as plain text, HTML or CSV. -- Puneet Kishor http://www.punkish.org Carbon Model

Re: [sqlite] help in understanding sqlite_master output

On Tue, Oct 20, 2009 at 11:50 PM, Andy wrote: > I'm new to sqlite. Just started on a project that comes with a lot of > pre-created tables. > > Trying to understand the data structure, I did: > >>sqlite3 dev.db >>select * from sqlite_master; > > Some of the output of the

Re: [sqlite] PRAGMA scope

On Tue, Oct 20, 2009 at 1:33 PM, John Crenshaw wrote: > database = the physical file itself > database connection = a specific reference to the database, obtained > using sqlite3_open > > page_size has to be set before the database is created (though I'm NOT > entirely

Re: [sqlite] suggestions for avoiding "database locked" on ajax

, localhost seems more prone to this than a remote Apache > box.  ISTR you're a Mac user, so none of this may apply :-)) > > > > > - Original Message > From: P Kishor <punk.k...@gmail.com> > To: General Discussion of SQLite Database <sqlite-users@sqlite.org&g

Re: [sqlite] suggestions for avoiding "database locked" on ajax

On Mon, Oct 19, 2009 at 12:13 PM, Keith Roberts <ke...@karsites.net> wrote: > On Mon, 19 Oct 2009, P Kishor wrote: > >> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> >> From: P Kishor <punk.k...@gmail.com> >> Subject: Re: [sqlite]

Re: [sqlite] suggestions for avoiding "database locked" on ajax

I seem to think it defaults to 30 seconds, but I don't see it documented now. > > If you move the second AJAX request from the onBlur event, to an > explicit user click (button, link, etc), do you still get the locked > DB?  If not, I think it would help prove it's a timing issue (or not). >

Re: [sqlite] getting hung up on LEFT JOIN

On Sun, Oct 18, 2009 at 12:06 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > P Kishor wrote: >> On Sun, Oct 18, 2009 at 11:49 AM, Igor Tandetnik <itandet...@mvps.org> wrote: >>> P Kishor wrote: >>>> Given a specific user_id (say, user_id = 1)

Re: [sqlite] getting hung up on LEFT JOIN

On Sun, Oct 18, 2009 at 11:49 AM, Igor Tandetnik <itandet...@mvps.org> wrote: > P Kishor wrote: >> Given a specific user_id (say, user_id = 1) how on earth do I get the >> following? >> idea_id     idea         created_by_name  rating >> --  ---

Re: [sqlite] sqlite in-memory database far too slow in my use case

On Sun, Oct 18, 2009 at 10:37 AM, Ron Arts wrote: > Very true Simon, > > this has been the fastest way so far and I can do around > 35 selects/second this way, using prepared statements > (on my machine at least), but I need more speed. > > That's why I want to skip the

[sqlite] getting hung up on LEFT JOIN

CREATE TABLE users ( user_id INTEGER PRIMARY KEY, username TEXT ); INSERT INTO users (username) VALUES ('jim'); INSERT INTO users (username) VALUES ('bob'); INSERT INTO users (username) VALUES ('joe'); CREATE TABLE ideas ( idea_id INTEGER PRIMARY KEY, idea TEXT, created_by

Re: [sqlite] suggestions for avoiding "database locked" on ajax

r didn't exist). Even though Javascript has gotten the response from the first event, and started on the second process. sqlite is still busy from the first process, so throws a lockout. Yes, it is very annoying. I have to figure out some other shenanigans to prevent this from happening. > >  -Cl

[sqlite] INTERSECT?

I don't even know how to title this post, and it just might be something very obvious. Either way, I apologize in advance. Consider the following -- sqlite> SELECT * FROM foo; a b -- -- 1 6 2 6 2 3 3 3 3 4 3 5

Re: [sqlite] Why FTS3 has the limitations it does

On Fri, Oct 16, 2009 at 3:12 PM, Scott Hess wrote: > On Wed, Oct 14, 2009 at 11:35 PM, John Crenshaw > wrote: >> The severe limitations on FTS3 seemed odd to me, but I figured I could >> live with them. Then I starting finding that various queries were

Re: [sqlite] suggestions for avoiding "database locked" on ajax

On Fri, Oct 16, 2009 at 3:09 PM, Stephan Wehner <stephanweh...@gmail.com> wrote: > On Fri, Oct 16, 2009 at 12:58 PM, Simon Slavin > <slav...@hearsay.demon.co.uk> wrote: >> >> On 16 Oct 2009, at 8:53pm, P Kishor wrote: >> >>> If neith

Re: [sqlite] length() behaviors on Mac osx

On Fri, Oct 16, 2009 at 1:42 AM, Michael Chen wrote: > select *, (length(path) - length( replace(path, '/','' )) +1 ) sqlite> SELECT length('/1/2/5/'); 7 sqlite> SELECT replace('/1/2/5/', '/', ''); 125 sqlite> SELECT length('125'); 3 7 - 3 = 4 4 + 1 = 5 sqlite>

[sqlite] DBD::SQLite with FTS3 finally works. here is how...

I started with DBD::SQLite 1.26_05 and went back as much as DBD::SQLite 1.21. Kept on getting segfaults. Any further back, and I got DBD::SQLite 1.14 which bundled FTS2, so that wasn't good as well. Finally, the amazing Audrey Tang to rescue. I downloaded the classic DBD::SQLite::Amalgamation

Re: [sqlite] test DBD::SQLite 1.26_05 - foreign keys!

On Thu, Oct 15, 2009 at 11:49 PM, P Kishor <punk.k...@gmail.com> wrote: > On Thu, Oct 15, 2009 at 11:37 PM, Darren Duncan <dar...@darrenduncan.net> > wrote: >> P Kishor wrote [on sqlite-us...@sqlite.org]: >>> >>> On Thu, Oct 15, 2009 at 1:39 AM, Darren

Re: [sqlite] test DBD::SQLite 1.26_05 - foreign keys!

On Thu, Oct 15, 2009 at 11:37 PM, Darren Duncan <dar...@darrenduncan.net> wrote: > P Kishor wrote [on sqlite-us...@sqlite.org]: >> >> On Thu, Oct 15, 2009 at 1:39 AM, Darren Duncan <dar...@darrenduncan.net> >> wrote: >>> >>> All, >>> &

[sqlite] sqlite 3.6.19 missing FTS3?

This is getting weirder by the minute. I just downloaded sqlite 3.6.19 and built it like I have previous versions. But, I didn't get FTS3? I get the following error -- SQL error: no such module: fts3 Did the economic recession affect this? Is this a result of the cutbacks in spending? Where is

Re: [sqlite] DBD::SQLite 1.23 fails with bus error

On Thu, Oct 15, 2009 at 10:59 PM, P Kishor <punk.k...@gmail.com> wrote: > On Thu, Oct 15, 2009 at 10:52 PM, P Kishor <punk.k...@gmail.com> wrote: >> Because of FTS3 problems with DBD::SQLite 1.26_05, I downgraded to >> 1.23, but now I get a bus error/segmentation fa

Re: [sqlite] DBD::SQLite 1.23 fails with bus error

On Thu, Oct 15, 2009 at 10:52 PM, P Kishor <punk.k...@gmail.com> wrote: > Because of FTS3 problems with DBD::SQLite 1.26_05, I downgraded to > 1.23, but now I get a bus error/segmentation fault, once again, on > FTS3 operations. > > Is there a version of DBD::SQLite that is kn

[sqlite] DBD::SQLite 1.23 fails with bus error

Because of FTS3 problems with DBD::SQLite 1.26_05, I downgraded to 1.23, but now I get a bus error/segmentation fault, once again, on FTS3 operations. Is there a version of DBD::SQLite that is known to have a working implementation of FTS3? -- Puneet Kishor http://www.punkish.org Carbon Model

Re: [sqlite] test DBD::SQLite 1.26_05 - foreign keys!

On Thu, Oct 15, 2009 at 1:39 AM, Darren Duncan wrote: > All, > > I am pleased to announce that DBD::SQLite (Self Contained RDBMS in a Perl DBI > Driver) version 1.26_05 has been released on CPAN (by Adam Kennedy). > .. > > P.S.  DBD::SQLite has at least 1 known bug, also

Re: [sqlite] Replacing a table

On Thu, Oct 15, 2009 at 10:37 AM, Kavita Raghunathan wrote: > Thanks much Pavel. > > No you are right I'm more of a L3 protocols > person with some user interfaces and network security, > somehow ended up trying to use sqlite now. I'll look through > your link on

Re: [sqlite] flexible data import

On Sun, Oct 11, 2009 at 3:16 AM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > .. > > If each "entry" will have a random set of arbitrary columns then you'll be > better off with a schema less database - CouchDB is my favourite and the > Javascript

Re: [sqlite] Datetime mystery

On Wed, Oct 7, 2009 at 5:02 PM, Fredrik Karlsson wrote: > Dear list, > > I am sorry if I am asking a FAQ, but what is differnent with > datetime() and time()? > >> date # This is the correct time on the system > Ons  7 Okt 2009 23:56:36 CEST >> sqlite3 temp.sqlite "SELECT

Re: [sqlite] Bayesian ranking

tomorrow and change it to 8 stars. No, no one can vote more than once for an idea, but of course, not everyone is required to vote for every idea. Many thanks for your consideration. On Mon, Oct 5, 2009 at 5:17 PM, P Kishor <punk.k...@gmail.com> wrote: > I am trying to de

Re: [sqlite] Bayesian ranking

On Mon, Oct 5, 2009 at 6:29 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > P Kishor <punk.k...@gmail.com> wrote: >> I am trying to develop a weighted rating system. I have the following >> schema -- >> >> CREATE TABLE ideas ( >>    idea_id INTEGER

[sqlite] Bayesian ranking

I am trying to develop a weighted rating system. I have the following schema -- CREATE TABLE ideas ( idea_id INTEGER PRIMARY KEY, idea_stars REAL DEFAULT 10, -- creator's 10 out of 10 stars; fractional possible idea_votes INTEGER DEFAULT 1 -- creator's vote ); Every item above, upon

Re: [sqlite] left join using where clause instead of using on clause

On Mon, Oct 5, 2009 at 7:02 AM, Tim Lind wrote: > Hi > > I have a query that is using a left join, with a where clause, and the > results I expect are not returned because the one table doesn't have a > related record. > If I put the constraint in the on clause of the query

Re: [sqlite] Compile test example problem

On Fri, Oct 2, 2009 at 9:01 PM, David Morris wrote: > > Thanks for your reply Roger, but doesn't the inclusion of the sqlite3.h file > do that? No, you have to link against the correct library. For example, if you have your sqlite library under /usr/local/lib, you will

Re: [sqlite] SQLite performance with lots of data

On Fri, Oct 2, 2009 at 11:45 AM, Francisc Romano wrote: > Wow. I did not expect such a quick answer... > Is there somewhere I can read exactly how fast and how big databases SQLite > can take, please? See http://www.sqlite.org/limits.html for "how big." You will have to do

Re: [sqlite] SQLite performance with lots of data

On Fri, Oct 2, 2009 at 11:42 AM, Francisc Romano wrote: > Hello! > > I am not entirely certain this is the right way to proceed, but I haven't > been able to find the appropriate official SQLite forum (if one exists). > I want to create a rather complex AIR application that

Re: [sqlite] how to move backward and forward in sqlite?

On Tue, Sep 29, 2009 at 5:11 AM, gyanendra singh wrote: > Hi, > > Can you please help me?I am facing one following problem in sqlite. > > i want to move forward and backward using sqlite. > > for example if i clik on the previous button i could move back > question. > > and

Re: [sqlite] Database Diff libs or applications

On Thu, Oct 1, 2009 at 8:44 AM, Shaun Seckman (Firaxis) wrote: > Hello, > >                I'm looking to externally track the actions made to a > database so that I can apply those same actions to another database > (assuming the other database has a similar schema).  

Re: [sqlite] Inclusion of real examples of the use of SQLite on the official documentation

2009/9/30 "Ing. Marcos L. Ortí­z Valmaseda" <mlor...@uci.cu>: > P Kishor escribió: > > 2009/9/30 "Ing. Marcos L. Ortí­z Valmaseda" <mlor...@uci.cu>: > > > Why we can´t include real examples of the use of SQLite on the official > documentation?

Re: [sqlite] Inclusion of real examples of the use of SQLite on the official documentation

2009/9/30 "Ing. Marcos L. Ortí­z Valmaseda" : > Why we can´t include real examples of the use of SQLite on the official > documentation? > That would be very useful for the new SQLite users. What is a real example? Would you want a tutorial on how to use SQL? Google for it; there

Re: [sqlite] building permanently loaded extensions

On Mon, Sep 28, 2009 at 1:21 PM, Nuno Lucas <ntlu...@gmail.com> wrote: > P Kishor wrote: >> Sometime back I had asked the following question, and it seems to have >> gotten Warnocked (http://en.wikipedia.org/wiki/Warnock's_Dilemma) >> >> So, here it is agai

Re: [sqlite] building permanently loaded extensions

Sometime back I had asked the following question, and it seems to have gotten Warnocked (http://en.wikipedia.org/wiki/Warnock's_Dilemma) So, here it is again -- how can I convert a loadable extension to a permanently loaded extension? A tutorial, por favor. On Wed, Sep 16, 2009 at 10:25 PM, P

Re: [sqlite] Tedious CSV import question

On Mon, Sep 28, 2009 at 12:13 PM, Petite Abeille wrote: > > On Sep 27, 2009, at 7:35 PM, Nuno Lucas wrote: > >> Some time ago I had to do something similar and decided to write a >> small >> virtual table implementation to treat CSV files as just another table. > > Very

Re: [sqlite] Optimise select from attached databases

On Mon, Sep 28, 2009 at 12:31 PM, Andrew Gatt <a.g...@btinternet.com> wrote: > P Kishor wrote: >> On Mon, Sep 28, 2009 at 12:06 PM, Andrew Gatt <a.g...@btinternet.com> wrote: >> >>> I'm trying to optimise a select statement, but from multiple attached >&g

Re: [sqlite] Optimise select from attached databases

On Mon, Sep 28, 2009 at 12:06 PM, Andrew Gatt wrote: > I'm trying to optimise a select statement, but from multiple attached > databases. The general statement would be; > > SELECT * FROM database0.table WHERE id = 1; > > Where i have a long list of ids to retrieve, which

Re: [sqlite] normalization example(s)

On Mon, Sep 28, 2009 at 10:28 AM, John wrote: > CityDev wrote: >> You seem to be asking about four separate issues - normalisation,  table >> creation, table loading, and SQLite syntax. The thing is I've just looked at >> your book's index and I can't imagine a better source

Re: [sqlite] FTS3 phantom token?...

On Sat, Sep 26, 2009 at 6:36 PM, marbex wrote: > > > Shopsland gmail wrote: >> >>    select title from fts_news where fts_news match 'ined' >> > > It looks that you only want to query the title field, so the query should > be: > select title from fts_news where title match

Re: [sqlite] Attach databases using tons of memory (DBI Perl)

On Thu, Sep 24, 2009 at 3:30 PM, John Lynch wrote: > Sqlite Users, > > I am using sqliute user for a very large customer database.  I have 3 > seperate DB files with a table in each file.  The files are cust,acct, and > web. > > Each DB table has  ~ 200 Million Rows.  When I

Re: [sqlite] Tedious CSV import question

On Thu, Sep 24, 2009 at 9:21 PM, C. Mundi wrote: > On Thu, Sep 24, 2009 at 7:16 PM, wrote: > >> On Thu, 24 Sep 2009, Rich Shepard wrote: >> >> > On Thu, 24 Sep 2009, C. Mundi wrote: >> > >> >> I just bit the bullet and did it.  Python has an excellent csv

Re: [sqlite] Why are allowed to keep a text of 3 characters in a field that has been set to 2?

On Tue, Sep 22, 2009 at 8:39 AM, Angus March <an...@uducat.com> wrote: > P Kishor wrote: >> On Mon, Sep 21, 2009 at 5:10 PM, Guillermo Varona Silupú >> <gvaro...@hotmail.com> wrote: >> >>> Hi >>> In these SQL commands: >>> >>

Re: [sqlite] Why are allowed to keep a text of 3 characters in a field that has been set to 2?

On Mon, Sep 21, 2009 at 5:10 PM, Guillermo Varona Silupú wrote: > Hi > In these SQL commands: > > CREATE TABLE "test" ("code" char(2)); > INSERT INTO test (code) VALUES("123") > > Why are allowed to keep a text of 3 characters in a field that has been > set to 2? > Is a bug?

Re: [sqlite] Code problem - apostrophes

On Mon, Sep 21, 2009 at 9:35 AM, Jimmy Verner wrote: > I did realize a couple of points that might be helpful to others: > > 1.  When you run "find and replace," it won't always pick up all the > apostrophes (or single close-quotes).  Apparently, different programs >

Re: [sqlite] SQLite Date problem

On Sun, Sep 20, 2009 at 4:16 AM, Dan Bishop wrote: > Max_wang wrote: >> A few months ago,I used SQLite 3.5.0 execute SQL:"SELECT date(253392451200.0, >> 'unixepoch');" >> The result was "-09-09". >> >> But now I use SQLite 3.6.18 replace it,this SQL execute result is >>

Re: [sqlite] Most wanted features of SQLite ?

On Sat, Sep 19, 2009 at 9:21 AM, John Stanton wrote: > Alexey Pechnikov wrote: >> Hello! >> >> On Saturday 19 September 2009 00:43:18 Noah Hart wrote: >> >>> Stored Procedures >>> >> >> There are Tiny C compiler extension and realization of >> stored procedures for SQLite 2

Re: [sqlite] Select records by specific YEAR

On Wed, Sep 16, 2009 at 9:16 AM, SHARMAQ Sistemas wrote: > Hi, > > > > I have a table called PEOPLE with 2 fiels: > > > > NAME --> TEXT 40 > > BIRTH --> DATETIME > > > > With some records > > > > I want to filter all people with BIRTH = 1946, I'm trying this: > > > > SELECT

Re: [sqlite] Performance in a case of big columns number

On Wed, Sep 16, 2009 at 9:23 AM, Dmitry Konishchev wrote: > Hello. > > Data in my program has such format that there is useful to place it in > the database in many (thousands) columns. Please, answer me: does SQLite > work more slowly when it has very big number of columns

[sqlite] building permanently loaded extensions

pursuant to a recent email, I am wondering if I can build extension-functions.c so that it is permanently available within sqlite library, and not just when loaded manually via a command. If I can, could someone please guide me

Re: [sqlite] Schema and database layout

On Wed, Sep 16, 2009 at 8:57 AM, Kavita Raghunathan wrote: > > - Original Message - > From: "Pavel Ivanov" > To: "General Discussion of SQLite Database" > Sent: Wednesday, September 16, 2009 6:40:18 AM GMT

Re: [sqlite] A question about how to interpret pragma integrity_check

On Tue, Sep 15, 2009 at 8:50 PM, Tito Ciuro <tci...@mac.com> wrote: > On Sep 15, 2009, at 6:42 PM, P Kishor wrote: > >> Could it be that those seemingly identical multiple rows actually have >> trailing spaces or some other non-visible character? Check for their &

Re: [sqlite] A question about how to interpret pragma integrity_check

On Tue, Sep 15, 2009 at 8:34 PM, Tito Ciuro <tci...@mac.com> wrote: > Hello, > On Sep 15, 2009, at 6:15 PM, P Kishor wrote: > > well, your clientName, entityName combo is not unique in the list > above, and it should be given it is a PK. I have no idea how you > managed to

Re: [sqlite] A question about how to interpret pragma integrity_check

On Tue, Sep 15, 2009 at 4:22 PM, Tito Ciuro wrote: > Hello, > > On Sep 15, 2009, at 12:55 PM, D. Richard Hipp wrote: > >> >> On Sep 15, 2009, at 3:33 PM, Tito Ciuro wrote: >> >>> Hello, >>> >>> Given the following pragma integrity_check output: >>> sqlite> pragma

Re: [sqlite] server process gives better concurrency - why?

On Wed, Sep 9, 2009 at 1:39 PM, Pavel Ivanov wrote: >> But I imagine >> there are other issues as well - these are the issues I'd like to get >> a bead on. > > I just keep wondering: do you want to write some new database engine > based on SQLite so that it will heed all these

Re: [sqlite] how to get "One to many" in 1 row of a table ?

On Wed, Sep 9, 2009 at 12:32 PM, Simon Slavin wrote: > > On 9 Sep 2009, at 5:15pm, Stef Mientki wrote: > >> The situation is like this (simplified): >> >> I've a table with persons: name, address, phone, etc. >> I've another table with vehicles: car_or_bike, brand,

Re: [sqlite] Importing data into SQLite - text files are not really portable

On Wed, Sep 9, 2009 at 10:33 AM, Jim Showalter wrote: > Microsoft also supports an XML standard for import/export. Whenever > possible, it should be used instead of CSV. It's not the > line-terminators that are the problem--the problem is CSV itself. > That's why Microsoft

Re: [sqlite] Sqlite uses a lot of memory during a delete operation

On Tue, Sep 8, 2009 at 10:48 PM, Benjamin Rutt <rut...@osu.edu> wrote: > On Mon, Sep 7, 2009 at 12:28 PM, P Kishor <punk.k...@gmail.com> wrote: > >> Find out if the DELETEion is chewing up the memory or the SELECTion. Try >> >> SELECT * FROM old_conns WHERE &qu

Re: [sqlite] Not able to properly inner join?

the column so that it is a > numeric value? > check your table definition. If subcode is not defined as INTEGER, you can create a new table with the proper definitions and then populate the table correctly. > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mai

Re: [sqlite] Not able to properly inner join?

On Tue, Sep 8, 2009 at 10:41 AM, Aaron Drake wrote: > Greetings, > > > > I'm new to SQL and SQLite3, I usually create my SQL queries using a > query builder and then run it against the SQLite3 engine and tweak it > until I get my desired result. > > > > I'm trying to join two

Re: [sqlite] Asking for SQL statement help

On Tue, Sep 8, 2009 at 12:58 AM, Dennis Volodomanov wrote: > Thank you for the quick replies and sorry for not being too clear. > > I will try to state the problem more clearly, without my own attempts to > solve it, as they are incorrect anyway. > > The simplified schemas

Re: [sqlite] Asking for SQL statement help

On Tue, Sep 8, 2009 at 12:31 AM, Dennis Volodomanov wrote: > Hello all, > > A small SQL problem, no doubt, for experts here. > > Let's say we've got 4 tables: > > CREATE TABLE TABLEA ( ID INTEGER PRIMARY KEY, IDB INTEGER, IDC INTEGER, IDD > INTEGER ); > CREATE TABLE TABLEB (

Re: [sqlite] Sqlite uses a lot of memory during a delete operation

On Sun, Sep 6, 2009 at 5:23 PM, Benjamin Rutt wrote: > I noticed sqlite is using a lot of memory (up to 300MB before it hits a data > segment size ulimit and fails) during a delete operation.  This is > reproducable using the 'sqlite3' executable distributed with sqlite.  My >

Re: [sqlite] Problems encountered on upgrade from SQLite2 to -3

On Thu, Sep 3, 2009 at 10:30 AM, Jim Showalter wrote: > At the risk of throwing gasoline on a fire... > > I didn't react badly to Rod's original post. The original post was fine. It was the third post that was inflammatory. > Yes, it could have been > worded more

Re: [sqlite] SQLite 3.6.17

On Wed, Sep 2, 2009 at 6:14 PM, Simon Slavin<slav...@hearsay.demon.co.uk> wrote: > > On 2 Sep 2009, at 8:27pm, P Kishor wrote: > >> Simon >> Slavin<slav...@hearsay.demon.co.uk> wrote: >>> >>> On 2 Sep 2009, at 2:39pm, Alberto Simões wrote: >>

Re: [sqlite] Problems encountered on upgrade from SQLite2 to -3

On Wed, Sep 2, 2009 at 3:54 PM, Rod Dav4is wrote: > Whether _you_ consider them problems or not, they were certainly > problems for me, migrating a working application to version 3 and having > it fall over in subtle ways because of these undocumented two vs three > differences.

Re: [sqlite] SQLite 3.6.17

to ascertain if that is what others (such as Simon or DRH) did who are *not* having any such issues on the Mac. > > All the best, > Alberto > > On Wed, Sep 2, 2009 at 8:27 PM, P Kishor <punk.k...@gmail.com> wrote: >> >> On Wed, Sep 2, 2009 at 10:55 AM, Simon

Re: [sqlite] SQLite 3.6.17

On Wed, Sep 2, 2009 at 10:55 AM, Simon Slavin wrote: > > On 2 Sep 2009, at 2:39pm, Alberto Simões wrote: > >> Can you please send me your env? > > It works fine for me on Leopard, and I have done no special > environment setting at all: I use the default Unix settings

Re: [sqlite] Importing data into SQLite

On Mon, Aug 31, 2009 at 10:02 AM, Kavita Raghunathan wrote: > Hi, > I'm evaluating SQLite to be used as a small embedded database in > a linux environment for Skyfiber Inc. What is the best way to import data > into it ? .import > I have a bunch of entities and

Re: [sqlite] Index performance using 2 integers vs. 1 float

On Wed, Aug 26, 2009 at 9:21 PM, danjenkins wrote: > > Hello, > We use a julian.decimal format to represent date/time (i.e. noon of August > 26, 2009 would be 40049.5000) and we use this julian date for an index key. > Our databases are frequently up to 3GB in size containing 10

Re: [sqlite] trouble with precompiled binaries for MacOS X

On Wed, Aug 26, 2009 at 9:03 AM, Simon Slavin<slav...@hearsay.demon.co.uk> wrote: > > On 26 Aug 2009, at 1:27pm, P Kishor wrote: > >> However, on a Mac you don't really want this. Just download the source >> code at http://www.sqlite.org/sqlite-amalgamation-3.6.17.tar

Re: [sqlite] trouble with precompiled binaries for MacOS X

On Tue, Aug 25, 2009 at 2:47 PM, Matt Stiles wrote: > Am I losing my mind, or is there something wrong with the bin.gz file on the > download page? I've downloaded it several times, but I can't get it to open > completely using Stuffit or the Mac archive utility. It

Re: [sqlite] Using SQLite for GIS Application

On Sun, Aug 23, 2009 at 12:08 AM, Itzchak Raiskin wrote: > Hi > I want to use SQLite in a GIS application where I create a database > containing terrain data (coordinates, height). > I would like to query this database with start and end points of a line and > get a

Re: [sqlite] Using SQLite for GIS Application

On Sun, Aug 23, 2009 at 11:34 AM, P Kishor<punk.k...@gmail.com> wrote: > On Sun, Aug 23, 2009 at 11:11 AM, Simon > Slavin<slav...@hearsay.demon.co.uk> wrote: >> >> On 23 Aug 2009, at 5:00pm, P Kishor wrote: >> >>> WHERE a*x - y + c = 0 >> >&g

Re: [sqlite] Using SQLite for GIS Application

On Sun, Aug 23, 2009 at 11:11 AM, Simon Slavin<slav...@hearsay.demon.co.uk> wrote: > > On 23 Aug 2009, at 5:00pm, P Kishor wrote: > >> WHERE a*x - y + c = 0 > > Here's the problem.  This works only when the equation is exact. Indeed. We already laid out those pre

Re: [sqlite] Using SQLite for GIS Application

On Sun, Aug 23, 2009 at 12:08 AM, Itzchak Raiskin wrote: > Hi > I want to use SQLite in a GIS application where I create a database > containing terrain data (coordinates, height). > I would like to query this database with start and end points of a line and > get a

Re: [sqlite] Reverse string comparison for searches

On Fri, Aug 21, 2009 at 1:33 PM, Shaun Seckman (Firaxis) wrote: > Hello everyone, > >                Currently, in my database I'm storing thousands of > strings that are formatted in such a way where they share similar > prefixes (i.e. TXT_KEY_FOO, TXT_KEY_BAR).  Sadly,

Re: [sqlite] suggestion on the database design

On Thu, Aug 20, 2009 at 8:33 AM, pierr wrote: > > Hi, >  We have a database with a very simple schema: >    CREATE TABLE IF NOT EXISTS tblIndex( >     frame_type  INT, >     pts  VARCHAR(5), >     ts_start  INT primary key, >     ts_end  INT) > > And the application scenario

[sqlite] building an extension

are the following instructions at http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions for building a loadable extension still valid? How To Build a Loadable Extension Shared Library on Linux 0. untar latest sqlite3 source code in a new directory 1. cd to the newly untarred sqlite directory

<    1   2   3   4   5   6   7   8   9   10   >