[sqlite] on delete no action

Hi all, I've been lurking for a few days while I explore SQLite and find myself now with a question. What's the correct usage for the "ON DELETE NO ACTION" statement? I'm converting a schema file to SQLite. Executing a create table statement on the sqlite3 cmd-line, ON DELETE NO ACTION

Re: [sqlite] MySQL vs. SQLite

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > You might be interested in NoSQL, or in databases which have no schema: every > piece of information is a property of an object. I do happen to use them pretty intensively, especially MongoDB, so here are some things they do differently: There is

Re: [sqlite] MySQL vs. SQLite

Simon Slavin wrote: > On 2 Jun 2010, at 1:14am, Darren Duncan wrote: > >> What are some examples of the proposed SQL replacements that do this? > > You might be interested in NoSQL, or in databases which have no schema: every > piece of information is a property of an object. Please note: I am

Re: [sqlite] MySQL vs. SQLite

On 2 Jun 2010, at 1:14am, Darren Duncan wrote: > What are some examples of the proposed SQL replacements that do this? You might be interested in NoSQL, or in databases which have no schema: every piece of information is a property of an object. Please note: I am not recommending these

Re: [sqlite] MySQL vs. SQLite

Simon Slavin wrote: > On 1 Jun 2010, at 11:59pm, Scott Hess wrote: >> Well, really, what you want is "SQLite, for this table, I want to these >> SELECT and UPDATE statements in this ratio, what indices would be ideal?" > > That's often handled with smart caching. The cache system notes down how

Re: [sqlite] MySQL vs. SQLite

On 1 Jun 2010, at 11:59pm, Scott Hess wrote: > Well, really, what you want is "SQLite, for this table, I want to > these SELECT and UPDATE statements in this ratio, what indices would > be ideal?" That's often handled with smart caching. The cache system notes down how often each item is hit,

Re: [sqlite] MySQL vs. SQLite

On Tue, Jun 1, 2010 at 2:37 PM, Simon Slavin wrote: > On 1 Jun 2010, at 7:11pm, Israel Lins Albuquerque wrote: >> About that future release functionality. Will be possible to know whats >> temporary index are created? >> Using that information will be easy to know what

Re: [sqlite] MySQL vs. SQLite

On 1 Jun 2010, at 7:11pm, Israel Lins Albuquerque wrote: > About that future release functionality. Will be possible to know whats > temporary index are created? > Using that information will be easy to know what indexes we need create to > increase perfomance, > don't giving chance to

Re: [sqlite] Performance issue on view

Create a new table to do this and add a trigger on op to make the sum. - Mensagem original - De: "Stéphane MANKOWSKI" Para: sqlite-users@sqlite.org Enviadas: Terça-feira, 1 de Junho de 2010 16:57:16 Assunto: [sqlite] Performance issue on view Hi, In the

Re: [sqlite] Performance issue on view

> PS: I don't want to compute "balance" attribute by code and save it in op > balance due to the fact that I am using an undo/redo mechanism. >From my experience this is the only way to go - calculate the balance in your application then store it in database along with transaction as "balance

[sqlite] Different error message after sqlite3_reset() or sqlite3_finalize()

Related to constraint violations, an error message returned by sqlite3_errmsg() changes to the better after calling sqlite3_reset() or sqlite3_finalize(). Example code is below, here is the output: sqlite3_step: 19 constraint failed sqlite3_reset:19 t.c may not be NULL

[sqlite] Performance issue on view

Hi, In the this database file (http://skrooge.org/files/test.wrk), I created a table named "op" containing banking transactions. A transaction has: An unique id An account A date An amount I created a view named "v_op" with one more computed attribute named

Re: [sqlite] What languages can include SQLite statically?

On Tue, 1 Jun 2010 15:13:57 -0400, Doug Currie wrote: >You may find eLua interesting. http://www.eluaproject.net/ >The supported platforms are heavily ARM based, but in the same performance >class as Blackfin. Thanks very much for the link. I'll go check if it can be

Re: [sqlite] What languages can include SQLite statically?

On Jun 1, 2010, at 2:24 PM, Gilles Ganault wrote: > Actually, it's a Blackfin processor, and since it's an embedded > environment, RAM and storage (NAND) are an issue. You may find eLua interesting. http://www.eluaproject.net/ The supported platforms are heavily ARM based, but in the same

Re: [sqlite] MySQL vs. SQLite

On Tue, Jun 01, 2010 at 02:13:06PM -0400, Richard Hipp scratched on the wall: > On Tue, Jun 1, 2010 at 2:09 PM, Israel Lins Albuquerque < > israel...@polibrasnet.com.br> wrote: > > > About that future release functionality. Will be possible to know whats > > temporary index are created? > > Using

Re: [sqlite] What languages can include SQLite statically?

On Tue, 1 Jun 2010 11:33:36 -0400 (EDT), Rob Sciuk wrote: >As you may be aware, SQLite and Tcl/Tk have an affinity which was not >entirely accidental. There are threads which discuss compiling Tcl for >Arm/Linux: >

Re: [sqlite] MySQL vs. SQLite

On Tue, Jun 1, 2010 at 2:09 PM, Israel Lins Albuquerque < israel...@polibrasnet.com.br> wrote: > > > About that future release functionality. Will be possible to know whats > temporary index are created? > Using that information will be easy to know what indexes we need create to > increase

Re: [sqlite] MySQL vs. SQLite

About that future release functionality. Will be possible to know whats temporary index are created? Using that information will be easy to know what indexes we need create to increase perfomance, don't giving chance to sqlite create that indexes! -- Regards/Atenciosamente, Israel Lins

Re: [sqlite] MySQL vs. SQLite

- Mensagem original - De: "Richard Hipp" Para: "General Discussion of SQLite Database" Enviadas: Segunda-feira, 31 de Maio de 2010 20:56:33 Assunto: Re: [sqlite] MySQL vs. SQLite On Mon, May 31, 2010 at 3:57 PM, Simon Slavin

Re: [sqlite] What languages can include SQLite statically?

On Mon, 24 May 2010 12:28:14 +0400, Max Vlasov wrote: >For Delphi I successfully used files from http://www.aducom.com to >statically link sqlite files compiled with bcc (Borland command-line c >compiler freely available now) with Delphi. Also the components of >aducom.com

Re: [sqlite] What languages can include SQLite statically?

From: Gilles Ganault > On Tue, 1 Jun 2010 08:40:15 -0300 (BRT), Israel Lins Albuquerque > wrote: > >Look for C++ QT framework! http://qt.nokia.com/ > > Thanks, I'll check it out. Gilles, As you may be aware, SQLite and Tcl/Tk have an

[sqlite] Returning empty result set

Hi, Tried to figured out the simplest query returning empty result set without binding to any existing table. The query SELECT 1 WHERE 1=2 worked, but it looked a little strange ) and besides it didn't work in mysql. Will it work in future versions of sqlite or I'd be better to use a query

Re: [sqlite] What languages can include SQLite statically?

On Tue, 1 Jun 2010 08:40:15 -0300 (BRT), Israel Lins Albuquerque wrote: >Look for C++ QT framework! http://qt.nokia.com/ Thanks, I'll check it out. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] What languages can include SQLite statically?

Look for C++ QT framework! http://qt.nokia.com/ - Mensagem original - De: "Gilles Ganault" Para: sqlite-users@sqlite.org Enviadas: Terça-feira, 1 de Junho de 2010 8:10:34 Assunto: Re: [sqlite] What languages can include SQLite statically? On Tue, 1 Jun

[sqlite] Bug and possible fix: Access violation in rtree.c:nodeGetRowid()

I am getting an access violation in rtree.c::nodeGetRowid() using a database image of questionable integrity (the application the database was last updated on shut down abnormally, but executing PRAGMA integrity_check returns "ok" and there is no journal file). The access violation can be

[sqlite] OpenSQLCamp EU 2010 - Call for participation is now open

OpenSQL Camp is a free conference of, by, and for the open-source database community of users and developers. The OpenSQLCamp 2010, European Edition (http://opensqlcamp.org/) will take part in parallel to the Free and Open Source Conference 2010 (http://froscon.org/) on Saturday 21st and Sunday

Re: [sqlite] What languages can include SQLite statically?

On Tue, 1 Jun 2010 11:57:29 +0100, Simon Slavin wrote: >The obvious solution is to use PHP, and have it use one of the three >avaialable sets of SQLite calls. Can I compile a PHP script + modules into something that will run on embedded devices? They don't have enough RAM

Re: [sqlite] What languages can include SQLite statically?

On Tue, 1 Jun 2010 05:49:27 -0500, "Black, Michael (IS)" wrote: >About the only thing you'll find cross-platform + embedded is C/C++ Yes, it looks like it's pretty much it. I'll check Lua, though, to see whether the modules I need are either in Lua, or are writte in C and

Re: [sqlite] Getting a "rowid" from a view

A bit of bitterness here: Jim, do you know that SELECT doesn't guarantee rows to be returned in any particular order unless ORDER BY clause is used? It's even not guaranteed that the same SELECT without ORDER BY issued twice will return rows in the same order. So when you do SELECT * FROM

Re: [sqlite] What languages can include SQLite statically?

On 1 Jun 2010, at 10:30am, Gilles Ganault wrote: > The problem is that I'd like a cross-platform > solution so that the HTTP + SQLite solution runs on Windows and Linux The obvious solution is to use PHP, and have it use one of the three avaialable sets of SQLite calls. > (and in the case of

Re: [sqlite] What languages can include SQLite statically?

About the only thing you'll find cross-platform + embedded is C/C++ For an IDE use Code::Blocks as it is cross-platform Windows/Unix (no embedded though of course). But does run gcc on both. And since gcc is a popular choice for embedded that will maximize your code portability. Michael D.

Re: [sqlite] What languages can include SQLite statically?

On Mon, 24 May 2010 12:28:14 +0400, Max Vlasov wrote: >For Delphi I successfully used files from http://www.aducom.com to >statically link sqlite files compiled with bcc (Borland command-line c >compiler freely available now) with Delphi. Also the components of >aducom.com

[sqlite] check constraint error message

Is it possible to have a custom check constraint error message? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Windows] Application to let end-users handle records?

On Tue, 18 May 2010 17:03:17 +0100, Bart Smissaert wrote: >This is a VB6 procedure (in an ActiveX dll) that handles this. >Obviously there are a lot of secondary routines that you don't have, >but I think you will get the general idea of what is going on here. Thanks a

Re: [sqlite] What languages can include SQLite statically?

On Sat, 22 May 2010 14:09:18 +0200, Peter Rodwell wrote: >Take a look at REALbasic (http://www.realsoftware.com/), now called >REALStudio. It has SQLite support built in (and support for other >dabases such as MySQL). The same source code can be compiled simultaneously >for