Re: [sqlite] Multiple constraints per table?

I understand your solution Woody, but it isn't practical for me, not for my home shopping list program. A full on relational database like that is an awful lot of work and it's only for home use (and any other family I can con into using it and testing it). I'd go for the relational route if I

Re: [sqlite] Multiple constraints per table?

U, hmm. The tips I gave you were from my pda based shopping program that will be selling for 9.99 soon. Its 6 for one, half dozen for the other. You can design the db so it does the work for you or you code the program to do the work for you. Either way, you will get things to work, it

Re: [sqlite] Multiple constraints per table?

Harold Wood amp; Meyuni Gani wrote: U, hmm. The tips I gave you were from my pda based shopping program that will be selling for 9.99 soon. Good on you Woody, hope you sell a lot.! If my eyes were up to the challenge of reading my PDA's small screen, i'd buy a copy and save myself

[sqlite] Can't get MAX value from table

Hi, I am fairly new to SQLite, and using it to replace Microsoft db in PocketPC applications. I am having trouble getting a MAX value from a table as follows:- SQL = SELECT MAX( ColumnName ) FROM TableName Set Recs = db.Execute(sql) Result = recs(1)(ColumnName) I get nothing in the Result

Re: [sqlite] Index and ORDER BY

В сообщении от Wednesday 02 July 2008 08:25:10 Dan написал(а): I'm using SQLite 3.5.9 and there are no differents in my tests   between DESC and default indeces. I try create index with keywork DESC for   optimize DESC sorting but it don't work for me. My tests you can see above. Have

Re: [sqlite] SQLite and updating VIEWs

On Jul 2, 2008, at 2:12 AM, Shawn Wilsher wrote: Hey all, I'm working with a partitioned table setup with a permanent table and a temp table with the same columns and indexes. Every X time we dump all the records in the temp table over to the permanent one. In order to make selection

[sqlite] Temp Files are not closed during a select call.

We are executing a query which does a select from two different tables and does a union.(For eg : select phonename,uid from contact_primary_info union select name,itemId from Contact_SIM order by 1 ASC; ) We are seeing that Sqlite lib is calling a openFile call two times with the same file

Re: [sqlite] How to connect the SQLite with DBDesigner4?

Then I wonder how can I export my DB4Designer work to the SQLite database? winstonma wrote: I tried to export the the SQL command exported from DBDesigner4 is not going to run on SQLite. But working on MYSQL. However I saw that the DBDesigner4 can connect to SQLite server. I tried to

[sqlite] Float, numeric and query

Hi, I am using SQLAlchemy which is an very nice ORM under python: http://www.sqlalchemy.org/ I am only an amateur. I attach a file, which will be helpful for people willing to help me. I am trying to make a query with a simple table containing integers and floats. The purpose of the query is to

Re: [sqlite] Float, numeric and query

Dom Dom [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] The query, translated into sql by SQLAlchemy, is (it returns tuple objects): SELECT mytable.id AS mytable_id, mytable.colA AS mytable_colA, mytable.colB AS mytable_colB, mytable.colC AS mytable_colC, CAST(mytable.colB AS

Re: [sqlite] Can't get MAX value from table

MAX( ColumnName )No column name - Original Message - From: Bob Dennis [EMAIL PROTECTED] To: SQLite user gorup sqlite-users@sqlite.org Sent: Wednesday, July 02, 2008 4:01 PM Subject: [sqlite] Can't get MAX value from table Hi, I am fairly new to SQLite, and using it to replace

[sqlite] Limiting the time a query takes

Is there any way to limit the time a query takes? i.e. tell sqlite to give up and return an error is the query is not done within a certain time. From the limits page of the documentation, it appears not to be possible, but also not to matter too much: the explanation of limits of LIKE and GLOB

Re: [sqlite] Limiting the time a query takes

Graeme [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Is there any way to limit the time a query takes? i.e. tell sqlite to give up and return an error is the query is not done within a certain time. sqlite3_progress_handler Igor Tandetnik

Re: [sqlite] How to connect the SQLite with DBDesigner4?

winstonma wrote: Then I wonder how can I export my DB4Designer work to the SQLite database? I have no idea - again, please consult the DB4Designer documentation to find out the available export options. ___ sqlite-users mailing list

Re: [sqlite] Multiple constraints per table?

Lol. Thanks. If you want a schema I can attach and send to you. Woody from his pda -Original Message- From: flakpit [EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 11:30 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Multiple constraints per table? Harold Wood amp; Meyuni Gani

Re: [sqlite] Limiting the time a query takes

Thanks for having the patient to answer. I really deserved an RTFM for that. On Wednesday 02 July 2008 13:51:29 Igor Tandetnik wrote: sqlite3_progress_handler -- Graeme Pietersz http://moneyterms.co.uk/ http://pietersz.co.uk/ ___ sqlite-users

Re: [sqlite] Table Level Locking

Joanne Pham [EMAIL PROTECTED] wrote: I read the online document regarding Table Level Locking as below: At any one time, a single table may have any number of active read-locks or a single active write lock. To read data a table, a connection must first obtain a read-lock. To write to a table,

Re: [sqlite] rollback/replay journals and durability of the most recenttransaction

Karl Tomlinson [EMAIL PROTECTED] wrote: I've done a little looking into journals, fsyncs, and filesystems recently. One thing I'm trying to understand is whether there was a reason for SQLite choosing to use a rollback journal (of the steps to undo a transaction) rather than a replay journal

Re: [sqlite] Table Level Locking

Hi Igor, I have an in memory database and a single multiplexed thread for all readers and writes. I like to be able to read tables without locking out other readers and writers. Is this possible? I don't mind writers using locks but some of my readers are slow and I don't want them to hold

Re: [sqlite] Table Level Locking

Alex Katebi [EMAIL PROTECTED] wrote: I have an in memory database and a single multiplexed thread for all readers and writes. I like to be able to read tables without locking out other readers and writers. As far as I can tell, you do everything on a single thread using a single

Re: [sqlite] Float, numeric and query (Continued)

Dom Dom [EMAIL PROTECTED] wrote: Igor Tandetnik [EMAIL PROTECTED] writes: Would it be possible to get SQLAlchemy to cast to REAL, FLOAT or DOUBLE rather than NUMERIC? Hello Igor, Thanks for answering. Casting to NUMERIC leaves integers as integers; basically, it's a no-op in your query.

[sqlite] PRAGMA synchronous = OFF on transaction-safe file system TFAT WinCE

Hello Is it safe do set PRAGMA synchronous = OFF when a transaction-safe file system is used? We are working on WinCE with TFAT (see below) - but this might be a general question. Regards Daniel TFAT: The original file allocation table (FAT) file system enabled file modification operations

[sqlite] Building ft3?

Hi all, I'm on Linux and I would like to build sqlite3 with rtree and ft3 support. How do I do that? I have read through the docs, website, the wiki and have evidently missed the needed page(s). For example: http://www.sqlite.org/compile.html talks about compilation options but does not say

Re: [sqlite] Table Level Locking

Just to make myself clearer. I have one memory connection and many stmts. Each stmt multiplexes the thread. This means that a stmt could give up the thread without finalizing itself. On Wed, Jul 2, 2008 at 11:19 AM, Igor Tandetnik [EMAIL PROTECTED] wrote: Alex Katebi [EMAIL PROTECTED] wrote:

Re: [sqlite] Table Level Locking

Alexey, Do you mean the sqlite3_busy_timeout( ) ? I never thought I could use it for simulating this. I will give that a shot. Thanks, -Alex On Wed, Jul 2, 2008 at 11:40 AM, Alexey Pechnikov [EMAIL PROTECTED] wrote: В сообщении от Wednesday 02 July 2008 19:11:58 Alex Katebi написал(а):

Re: [sqlite] Table Level Locking

Alex Katebi [EMAIL PROTECTED] wrote: Just to make myself clearer. I have one memory connection and many stmts. Each stmt multiplexes the thread. This means that a stmt could give up the thread without finalizing itself. That's OK. It used to be that, say, a SELECT statement in progress (not

Re: [sqlite] Float, numeric and query (Continued)

Igor Tandetnik [EMAIL PROTECTED] writes: Dom Dom [EMAIL PROTECTED] wrote: Igor Tandetnik [EMAIL PROTECTED] writes: Would it be possible to get SQLAlchemy to cast to REAL, FLOAT or DOUBLE rather than NUMERIC? Hi Igor, Thanks for answering. Seems SQLAlchemy had a different numeric

Re: [sqlite] Index and ORDER BY

On Jul 1, 2008, at 3:53 PM, Alexey Pechnikov wrote: В сообщении от Tuesday 01 July 2008 23:47:50 [EMAIL PROTECTED] написал(а): On Tue, 1 Jul 2008, Alexey Pechnikov wrote: Is any difference between CREATE INDEX ev_idx ON events(type,eid) and CREATE INDEX ev_idx ON events(type,eid desc)?

Re: [sqlite] Table Level Locking

В сообщении от Wednesday 02 July 2008 22:42:48 Alex Katebi написал(а):    Do you mean the sqlite3_busy_timeout( ) ? I never thought I could use it for simulating this. I will give that a shot. Client don't get database busy error but sleep some time and execute query later.

Re: [sqlite] rollback/replay journals and durability of the most recenttransaction

On Jul 2, 2008, at 10:56 AM, Igor Tandetnik wrote: Karl Tomlinson [EMAIL PROTECTED] wrote: I've done a little looking into journals, fsyncs, and filesystems recently. One thing I'm trying to understand is whether there was a reason for SQLite choosing to use a rollback journal (of the

Re: [sqlite] Table Level Locking

Do I need to enable shared cache mode plus read uncommitted option? Also you mentioned earlier: (but you will experience dirty reads with all the attendant problems). What is a dirty read? What problems does it cause? Thanks, -Alex On Wed, Jul 2, 2008 at 2:55 PM, Igor Tandetnik [EMAIL

Re: [sqlite] Table Level Locking

Alex Katebi [EMAIL PROTECTED] wrote: Do I need to enable shared cache mode plus read uncommitted option? You only have one connection (one call to sqlite3_open), right? Then it doesn't matter. Shared only makes a difference if there are at least two connections to share between. Also you

Re: [sqlite] Update static database with records from memory database.

I still can't get this to work. Can someone help please. :working: Pejayuk wrote: That is fantastic Igor. Thankyou. All I need to do now is work out how to get an update query to use a select query to update the records from stats_memory to stats_static after doing the link. I think

Re: [sqlite] Update static database with records from memory database.

I still can't get this to work. Can someone please help. :working: I don't understand how to do this. Many thanks in advance. Pejayuk wrote: That is fantastic Igor. Thankyou. All I need to do now is work out how to get an update query to use a select query to update the records from

Re: [sqlite] Update static database with records from memory database.

Pejayuk [EMAIL PROTECTED] wrote: I still can't get this to work. Can't get what to work? What specifically seems to be the problem? Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Table Level Locking

I created a test file. It is attached in this email. I can not see any locking happening at all. On Wed, Jul 2, 2008 at 4:25 PM, Igor Tandetnik [EMAIL PROTECTED] wrote: Alex Katebi [EMAIL PROTECTED] wrote: Do I need to enable shared cache mode plus read uncommitted option? You only have

Re: [sqlite] Update static database with records from memory database.

Pejayuk wrote: I still can't get this to work. Can someone help please. :working: Pejayuk wrote: That is fantastic Igor. Thankyou. All I need to do now is work out how to get an update query to use a select query to update the records from stats_memory to stats_static after doing

Re: [sqlite] Table Level Locking

Alex Katebi [EMAIL PROTECTED] wrote: I created a test file. It is attached in this email. I can not see any locking happening at all. Which part of you should never experience any locking at all in this scenario did you find unclear the first time round? Why exactly are you surprised? Igor

Re: [sqlite] rollback/replay journals and durability of the most recent transaction

Thank you for your comments. Karl Tomlinson wrote: One thing I'm trying to understand is whether there was a reason for SQLite choosing to use a rollback journal (of the steps to undo a transaction) rather than a replay journal (of the steps to perform a transaction). I didn't make this

Re: [sqlite] rollback/replay journals and durability of the mostrecent transaction

Karl Tomlinson [EMAIL PROTECTED] wrote: Thank you for your comments. Karl Tomlinson wrote: One thing I'm trying to understand is whether there was a reason for SQLite choosing to use a rollback journal (of the steps to undo a transaction) rather than a replay journal (of the steps to

Re: [sqlite] Table Level Locking

Igor, Notice that I have multiple stmts stepping over the same table at the same time. Why is this OK? There isn't a table level lock? When is a table locked? Thanks, -Alex On Wed, Jul 2, 2008 at 5:12 PM, Igor Tandetnik [EMAIL PROTECTED] wrote: Alex Katebi [EMAIL PROTECTED] wrote:

Re: [sqlite] Table Level Locking

Alex Katebi [EMAIL PROTECTED] wrote: Notice that I have multiple stmts stepping over the same table at the same time. Why is this OK? Why shouldn't it be? There isn't a table level lock? A file level lock, even. It happily locks out other connections (of which you have none). But a

Re: [sqlite] Table Level Locking

Below is a section from The Definitive Guide to SQLite book Is this not valid any more for the newer releases of SQLite. == Table Locks Even if you are using just one connection, there is a special edge case that sometimes trips people

Re: [sqlite] Building ft3?

Stephen Woodbridge wrote: Hi all, I'm on Linux and I would like to build sqlite3 with rtree and ft3 support. How do I do that? I have read through the docs, website, the wiki and have evidently missed the needed page(s). For example: http://www.sqlite.org/compile.html talks about

Re: [sqlite] Table Level Locking

Alex Katebi [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Below is a section from The Definitive Guide to SQLite book Is this not valid any more for the newer releases of SQLite. This is not valid anymore. See the message from Dr. Hipp in this thread:

Re: [sqlite] Table Level Locking

This is the way I hoped it should work, and it does. Thanks so much Igor! -Alex On Wed, Jul 2, 2008 at 9:39 PM, Igor Tandetnik [EMAIL PROTECTED] wrote: Alex Katebi [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED][EMAIL PROTECTED] Below is a section from The Definitive Guide to

[sqlite] validate SQL Statement

Hello, I was wondering if there a way in sqlite, wherein I could validate the SQL statement (for correct grammar, resource name - column name, table name etc), w/o having to do prepare. Thanks in advance --- On Wed, 7/2/08, Alex Katebi [EMAIL PROTECTED] wrote: From: Alex Katebi [EMAIL

Re: [sqlite] rollback/replay journals and durability of the mostrecent transaction

Igor Tandetnik [EMAIL PROTECTED] wrote:Karl Tomlinson wrote: Thank you for your comments. Karl Tomlinson wrote: One thing I'm trying to understand is whether there was a reason for SQLite choosing to use a rollback journal (of the steps to undo a transaction) rather than a replay

Re: [sqlite] Attempting to merge large databases

Gene Allen wrote: [SNIP] Enter .help for instructions sqlite attach 'c:\test\b.db3' as toMerge; try this: BEGIN; sqlite insert into AuditRecords select * from toMerge.AuditRecords; COMMIT; sqlite detach database toMerge; John -- Regards John McMahon [EMAIL

Re: [sqlite] rollback/replay journals and durability of the most recent transaction

Igor Tandetnik writes: Karl Tomlinson wrote: I really meant, as a first possibility, that writing the pages to the database itself would be performed during the commit process after syncing the replay journal (but the database need not be synced until the journal is about to be removed).