I just wanted to thank everyone who sent me links. Now I just need to
decide what to use. :)
Thanks again,
David
On Wed, 2006-04-05 at 09:42 -0400, David Bicking wrote:
> This is probably off-topic for this list, so let me apologize in advance
> if it is. I don't have a problem in using sqlite
Hello,
I must be missing something obvious, but I can't figure out how to
compile/install the tcl bindings. I've been trying to install
sqlite-3.3.5 for the last few hours.
According to http://www.sqlite.org/quickstart.html, in order to use
the tcl interface I need this line in my tcl script:
Hi Len,
The question you are asking is "loaded". Stay with the ansi SQL statements
that SQLite supports and you will be okay. If you need to use the SQLite
extensions now, you will have to write a "translator" in future - not too
difficult. For an experienced programmer (which you will be if the
Thanks all for your responses.
Here is what I have found: If I open a mem DB with sqlite3_open
using NULL as the filename, then use sqlite3_prepare16, the function
fails with "ErrMisuse". But I can use sqlite3_prepare (etc.). But
if I use sqlite3_open with ":memory:" then I can use
And now I find that if I open a mem DB with sqlite3_open then use
sqlite3_prepare16, the function fails with "ErrMisuse"
Any ideas?
Quoting Brett Goodman :
Hello all. I'm having some trouble with memory DBs. The
documents
that I find on the website say to use ":memory" as
On 4/7/06, Brett Goodman <[EMAIL PROTECTED]> wrote:
>Hello all. I'm having some trouble with memory DBs. The documents
> that I find on the website say to use ":memory" as the filename in
> the call to sqlite3_open. But the only way I can make the function
> succeed is by passing NULL.
>
Try,
:memory:
Cheers!
-Boris
--
+1.604.689.0322
DeepCove Labs Ltd.
4th floor 595 Howe Street
Vancouver, Canada V6C 2T5
[EMAIL PROTECTED]
CONFIDENTIALITY NOTICE
This email is intended only for the persons named in the message
header. Unless otherwise indicated, it contains information that
Hello all. I'm having some trouble with memory DBs. The documents
that I find on the website say to use ":memory" as the filename in
the call to sqlite3_open. But the only way I can make the function
succeed is by passing NULL.
Furthermore, I can't get it work at all if I use
But why don't you use
SELECT x from y WHERE y.x LIKE ? ;
and bind the first parameter to "%SomeText%" instead of "SomeText" like
before?
-Original Message-
From: Slater, Chad [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 06, 2006 6:40 PM
To: sqlite-users@sqlite.org
Subject: [sqlite]
Is it possible to use the LIKE operator with a prepared statement?
I'm trying to build a query that uses binding for the text in the LIKE
operation as follows:
SELECT x from y WHERE y.x LIKE %?% ;
...And binding text to the positional parameter in hopes to get:
SELECT x from y WHERE y.x LIKE
I would also like to suggest Tcl/Tk. I have written grid
viewers, grid editors and also a record based editor for
data entry.
I beef up the scanty sqlite data definition with 3 data
definition tables that describe logical keys, validation
conditions, batch totalling, column titles and other
Thanks for that info Richard - I will certainly try it for size.
Congratulations on your most prestgious award.
NJH
--
View this message in context:
http://www.nabble.com/Most-appropriate-Web-based-database-%28Newbie%29-t1404628.html#a3794224
Sent from the SQLite forum at Nabble.com.
Provided your new database has the features you are using it is simple.
For example we use Sqlite and PostgreSQL and transferring between them
is simple. Even the application program API is similar so a conditional
compile in the programs takes care of that and links appropriately.
JS
JP <[EMAIL PROTECTED]> wrote:
> Sounds like an interesting setup! Maybe off topic, but, would you care
> to elaborate on that topic? Server configuration, virtualization
> software running, etc.?
>
The http://www.sqlite.org/ website runs on a leased virtual
server. The virtual server is
Dennis Cote wrote:
Floppe wrote:
Will Leshner wrote:
On 4/5/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hello,
When using sqlite-3.3.4 with windows I get the following strange
behaviour.
create table Muppet (Kermit float);
insert into Muppet values (100);
select * from
Thanks Dennis, that's great news - I shall give it a try :-)
--
View this message in context:
http://www.nabble.com/Most-appropriate-Web-based-database-%28Newbie%29-t1404628.html#a3793176
Sent from the SQLite forum at Nabble.com.
I think Object Oriented databases came in with the SQL-99 standard and
SQLite is the SQL-92 standard so it may be structured but I'm not sure at
all
On 06/04/06, Aaron Jones <[EMAIL PROTECTED]> wrote:
>
> Hi, I am doing a project for University where I am creating a
> cross-platform,
Sounds like an interesting setup! Maybe off topic, but, would you care
to elaborate on that topic? Server configuration, virtualization
software running, etc.?
[EMAIL PROTECTED] wrote:
Lenster <[EMAIL PROTECTED]> wrote:
The application needs to be available to about twenty users on a daily
Lenster wrote:
I would like to know whether - at some point in the future should it be
necessary - I could convert my entire SQLite databases including tables etc
to another RDMS such as MySQL? Is this straightforward or convoluted?
The .dump command in the sqlite shell will dump your
Thanks for your reply Richard
After further Googling and reading the replies I've received here I am
coming around to the idea that SQLite probably is the best choice.
I would like to know whether - at some point in the future should it be
necessary - I could convert my entire SQLite databases
Thom Ericson wrote:
Marian Olteanu wrote:
You should embed the inserts into a transaction. Otherwise every
insert is a
separate ACID transaction = 2 disk spins.
I thought putting 128 of the inserts between "BEGIN;" and "COMMIT;"
did that. Am I confused?
Thom,
You are
> You should embed the inserts into a transaction. Otherwise every insert
> is a
> separate ACID transaction = 2 disk spins.
>
>
> I thought putting 128 of the inserts between "BEGIN;" and "COMMIT;" did
> that. Am I confused?
No, what you did was correct.
Just for grins:
If you have a
See in-line comments below
--
Jay Sprenkle wrote:
Did you put an index on the table/columns the select uses to lookup
the rowids of the parents?
I though that was what declaring 'str' as KEY and 'parent' as KEY was
supposed to do, but see Dennis Cote's
Thom Ericson wrote:
I am trying to pick a light weight database for a project. SQLite, on
paper, seems like the right choice, but performance is rather
disappointing. I hope it is just that I am doing something wrong.
I have built SQLite for Solaris and Win32 environments and I get
m christensen wrote:
I don't know if it does or not.
I intended to do both, but...
I can not get any variant I tried of --select sqlite_version(); -- to
execute.
It always complained about the statement in one way or another.
It does work with the current shell. I'm not sure when this
On 4/6/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
> No big deal. I thought it was funny (well a little humorous anyway) that
> you did exactly the same thing in the sample code you posted regarding
> the prepare statement tutorial question (only a few minutes apart).
Yeah, I wrote that a while
You should embed the inserts into a transaction. Otherwise every insert is a
separate ACID transaction = 2 disk spins.
-Original Message-
From: Thom Ericson [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 06, 2006 10:18 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Slow performance -
Thom Ericson wrote:
I had hoped to be able to handle 180,000,000 rows in my largest
installation (that's gonna take a
while). Any hints from anyone
IMHO 180 mln rows is no small deal even for a big database - especially
considering you have got text column in it.
If you are trying to
Jay Sprenkle wrote:
On 4/6/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
Jay,
No, he has the open call correct. He has a local pointer, he passes the
address of that pointer to sqlite3_open() and it allocates the sqlite3
structure and sets his pointer to point to it.
No need to change this.
On 4/6/06, Thom Ericson <[EMAIL PROTECTED]> wrote:
> I am trying to pick a light weight database for a project. SQLite, on
> paper, seems like the right choice, but performance is rather
> disappointing. I hope it is just that I am doing something wrong.
>
> I have built SQLite for Solaris and
I am trying to pick a light weight database for a project. SQLite, on
paper, seems like the right choice, but performance is rather
disappointing. I hope it is just that I am doing something wrong.
I have built SQLite for Solaris and Win32 environments and I get
essentially the same results.
I am trying to pick a light weight database for a project. SQLite, on
paper, seems like the right choice, but performance is rather
disappointing. I hope it is just that I am doing something wrong.
I have built SQLite for Solaris and Win32 environments and I get
essentially the same results.
Are you sure that $dbh0>(sqlite_version) returns the same thing as
executing the following SQL:
select sqlite_version();
I don't use perl, so I'm not sure how you actually execute the query.
One other possibility, you may have a wrapper that is statically
linked to an older library and
On 4/6/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
> Jay,
>
> No, he has the open call correct. He has a local pointer, he passes the
> address of that pointer to sqlite3_open() and it allocates the sqlite3
> structure and sets his pointer to point to it.
>
> No need to change this. Derrell has
Floppe wrote:
Will Leshner wrote:
On 4/5/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hello,
When using sqlite-3.3.4 with windows I get the following strange behaviour.
create table Muppet (Kermit float);
insert into Muppet values (100);
select * from Muppet;
100.0
Jay Sprenkle wrote:
> Here you pass the address of db, which is already a pointer.
>
>You've passed a pointer to a pointer but never allocated the structure used.
>
>I think you want to change this:
>
>
>> sqlite3 *db;
>>
>>
>to
>
>
>> sqlite3 db;
>>
>>
Jay,
No, he has the
Olaf Beckman Lapré wrote:
Hi,
I assume that the sqlite3_prepare() / sqlite3_bind() combination results in
faster performance than sqlite3_exec() for INSERT and UPDATE statements. But
where can I find example code that uses prepare/bind? Googling didn't give any
results.
Greetz,
Olaf
Lenster <[EMAIL PROTECTED]> wrote:
>
> The application needs to be available to about twenty users on a daily
> basis, with most of those users making no more than five 'write'
> transactions a day, and around twenty 'read' transactions a day.
>
The SQLite website is itself backed by SQLite.
Hi, I am doing a project for University where I am creating a
cross-platform, open-source GUI to SQLite, I am going to be using mono to
build it, do you think this will be ok or do you think I will encounter any
problems along the way? I've noticed there is a wrapper for mono, but where
mono is
On 4/6/06, 杰 张 <[EMAIL PROTECTED]> wrote:
> Hi all,
> I just want to get the values of a table.The result implemented is
> "Open OK!
> segmentation fault ". Why did I got this result ? The following is my code:
>
> #include
> #include
> #include "sqlite3.h"
> main()
> {
> char
Sqlite works very well for web applications unless they are large and
very busy. It is easy to manage and backup and performs well.
For a larger scale operation PostgreSQL would be a better choice than
MySql. If you design your application with care you could switch from
Sqlite to
杰 张 <[EMAIL PROTECTED]> writes:
> 1. (*) text/plain
>
> Hi all,
> I just want to get the values of a table.The result implemented is
> "Open OK!
> segmentation fault ". Why did I got this result ? The following is my code:
Just from a quick visual inspection, it appears that
Then again only 10,000,000 hits for SQLite (Less information to wade through)
and NO book to buy! (zero out of pocket expense!)
Good luck! You are most likely headed the right direction.
> -Original Message-
> From: Lenster [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 06, 2006 6:59
Hello Len,
On Thu, April 6, 2006 13:58, Lenster wrote:
> 1) Googling PostgreSQL produced 52,700,000 hits, Googling MySQL produced
> 397,000,000 hits
...
well, this is quite a poor comparison. On the Internet there are many articles
comparing MySQL vs PostgreSQL vs other database engines. As a
Find out yourself :-)
If you are using gcc, add -g flag when compiling, and then run it using gdb:
gdb your-executable
and then
> run
and then when it give the seg-fault, run:
> backtrace
This will give you a good hint about what is wrong.
Ran
On 4/6/06, 杰 张 <[EMAIL PROTECTED]>
Thanks Guys
I appreciate the input.
>Denis Sbragion
>how critical and complex is the data stored?
Well the data IS critical but NOT complex
>Gerhard Häring
>From what you have said Gerhard it seems that SQLite is probably upto the
job, however MySQL or PostgreSQL will be more futureproof
Hi all,
I just want to get the values of a table.The result implemented is "Open
OK!
segmentation fault ". Why did I got this result ? The following is my code:
#include
#include
#include "sqlite3.h"
main()
{
char **errmsg;
int ret;
int rc;
sqlite3 *db;
char
Hi,
I assume that the sqlite3_prepare() / sqlite3_bind() combination results in
faster performance than sqlite3_exec() for INSERT and UPDATE statements. But
where can I find example code that uses prepare/bind? Googling didn't give any
results.
Greetz,
Olaf
Lenster wrote:
I am investigating which would be the most appropriate RDMS to use for
a new Intranet based application. I have rounded down my choice to two
candidates - SQLite and MySQL.
Ok. I think that PostgreSQL and Firebird are almost always better
choices than MySQL for a database
Hello Len,
On Thu, April 6, 2006 10:49, Lenster wrote:
...
> Would I be correct in assuming that MySQL is a safer (longterm) bet?
how critical and complex is the data stored? If it's fairly critical and/or
complex (many tables with relations between them) PostgreSQL may be an even
better
Hi Lenster,
For a Web application you are probably better off with MySQL, it runs as
a seperate process and handles multiple threads really well. I'm
probably going to offend the sqlite people out there, but sqlite is
fantastic for an embedded database, and a web app is not what I would
call
I am investigating which would be the most appropriate RDMS to use for
a new Intranet based application. I have rounded down my choice to two
candidates - SQLite and MySQL.
The application needs to be available to about twenty users on a daily
basis, with most of those users making no more
52 matches
Mail list logo