On Sat, 22 May 2010 14:09:18 +0200, Peter Rodwell
pe...@gedackt.org 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 Windows
On Tue, 18 May 2010 17:03:17 +0100, Bart Smissaert
bart.smissa...@gmail.com 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 lot
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
On Mon, 24 May 2010 12:28:14 +0400, Max Vlasov
max.vla...@gmail.com 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 will
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.
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
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
On Tue, 1 Jun 2010 05:49:27 -0500, Black, Michael (IS)
michael.bla...@ngc.com 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
can
On Tue, 1 Jun 2010 11:57:29 +0100, Simon Slavin
slav...@bigfraud.org 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 to
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
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
Look for C++ QT framework! http://qt.nokia.com/
- Mensagem original -
De: Gilles Ganault gilles.gana...@free.fr
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 2010
On Tue, 1 Jun 2010 08:40:15 -0300 (BRT), Israel Lins Albuquerque
israel...@polibrasnet.com.br wrote:
Look for C++ QT framework! http://qt.nokia.com/
Thanks, I'll check it out.
___
sqlite-users mailing list
sqlite-users@sqlite.org
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
From: Gilles Ganault gilles.gana...@free.fr
On Tue, 1 Jun 2010 08:40:15 -0300 (BRT), Israel Lins Albuquerque
israel...@polibrasnet.com.br 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 affinity which
On Mon, 24 May 2010 12:28:14 +0400, Max Vlasov
max.vla...@gmail.com 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 will
- Mensagem original -
De: Richard Hipp d...@sqlite.org
Para: General Discussion of SQLite Database sqlite-users@sqlite.org
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 slav...@bigfraud.org
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
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 perfomance,
On Tue, 1 Jun 2010 11:33:36 -0400 (EDT), Rob Sciuk
r...@controlq.com 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:
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 that
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
On Tue, 1 Jun 2010 15:13:57 -0400, Doug Currie
doug.cur...@gmail.com 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
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
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
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 after
Create a new table to do this and add a trigger on op to make the sum.
- Mensagem original -
De: Stéphane MANKOWSKI steph...@mankowski.fr
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 this
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 sqlite
On Tue, Jun 1, 2010 at 2:37 PM, Simon Slavin slav...@bigfraud.org 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 indexes we
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, and
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
often
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
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 not
-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
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
35 matches
Mail list logo
