Hi Dennis
> --- Ursprüngliche Nachricht ---
> Von: Dennis Cote <[EMAIL PROTECTED]>
> An: sqlite-users@sqlite.org
> Betreff: Re: [sqlite] Charset-Confusions
> Datum: Mon, 15 May 2006 14:55:19 -0600
>
> You should try Ralf Junker's SQLiteSpy (see
>
They say "You cannot teach an old dog new tricks", but we are not dogs
and have to learn :-). I am glad that you have got Sqlite to work for you.
Best regards from the South Pacific.
[EMAIL PROTECTED] wrote:
--- Ursprüngliche Nachricht ---
Von: John Stanton <[EMAIL PROTECTED]>
An:
Do you intend to access array elements using SQL?
Kevin Piciulo wrote:
Hey everyone,
This may not be the place to ask (if not please direct me.) I'm
relatively new to sql, and newer to sqlite. Through experimenting i've
figured out how to add a string to a table, create a table, remove
[EMAIL PROTECTED] wrote:
An the 2. question: Is there any Really-Good-Admin-Tool to create
DB and Table, to browse and maybe edit Fieldvalues in a grid?
I have found 4 Admin-Programms. Some of them cannot open Version 3,
some cannot differ Unicode and Multibytecharset, one of them has
not a
I'd like to use SQLite for development/testing of a
website under Apache on OS X. I'm running into trouble
with permissions. The script runs as the www user, and
so does not have full permissions.
I can create a file called 'sqlite_test.db' and make
it writable by the www user, but then can only
I can't comment on Anne's situation, but I too think there is something funny
going on with charsets because of one small data point:
I open and use a database using the '16' APIs (ie sqlite3_open16,
sqlite3_prepare16, etc). When I tried to run an EXPLAIN QUERY PLAN statement
(like "EXPLAIN
Hi
I have some confusion again. I have create the same Database 4 times
and after that perform Insert some records. I dont change the
SQL-Commands.
1. Compiler-Option Unicode and run "sqlite3_exec()"
2. Compiler-Option Multibyte and run "sqlite3_exec()"
3. Compiler-Option Unicode and run
On 5/15/06, Kevin Piciulo <[EMAIL PROTECTED]> wrote:
Both ideas are very helpful. I'll definately be visiting that sql
site a lot. I'm not sure about BLOBs though, is it just like a catch
all. Where if you can't save data as something better, just save it as
a BLOB? As you can imagine a
> --- Ursprüngliche Nachricht ---
> Von: John Stanton <[EMAIL PROTECTED]>
> An: sqlite-users@sqlite.org
> Betreff: Re: [sqlite] BLOB
> Datum: Sat, 13 May 2006 08:17:29 -0700
>People with English as a first language can have difficulty
>understanding the description of manifest typing in the
I'm not a C++ guy, but I don't think the question and answer are specific to
C++.
I would use a child table. Think of the two "columns" in your example as two
tables in your database. In its simplest form, it might be:
create table names (id integer primary key, name);
insert into names
Both ideas are very helpful. I'll definately be visiting that sql
site a lot. I'm not sure about BLOBs though, is it just like a catch
all. Where if you can't save data as something better, just save it as
a BLOB? As you can imagine a google search for BLOB gives me a general
definition
Indeed storing the array as a BLOB is the best way to store this.
To store a blob you will need to use the following syntax I believe:-
INSERT INTO (NAME, NUMBERS) VALUES (,?)
And will need to bind the array to the SQL query after using
sqlite3_bind_blob(). There is documentation on this on
On 5/15/06, Kevin Piciulo <[EMAIL PROTECTED]> wrote:
Hey everyone,
This may not be the place to ask (if not please direct me.) I'm
relatively new to sql, and newer to sqlite. Through experimenting i've
figured out how to add a string to a table, create a table, remove a
string, some
Hey everyone,
This may not be the place to ask (if not please direct me.) I'm
relatively new to sql, and newer to sqlite. Through experimenting i've
figured out how to add a string to a table, create a table, remove a
string, some basic stuff like that.
What I'd like to do is add an
After I've been able to overcome the initial compiler problem (missing
library installation), I'm faced with a new one:
1) Compiling JDBC wrapper for 3.2.1 works fine
2) Compiling JDBC wrapper for 3.3.5 fails:
cl -Gs -EHsc -D_WIN32 -nologo -Zi -DOS_WIN=1 -D_CRT_SECURE_NO_DEPRECATE
-DNDEBUG=1
Iker Arizmendi <[EMAIL PROTECTED]> wrote:
> The FAQ makes clear that calling sqlite3_open from muliple
> processes is safe if the database in question already exists.
> However, is it safe to do so even if the database file
> does _not_ exist? In other words, can multiple processes
> safely
The FAQ makes clear that calling sqlite3_open from muliple
processes is safe if the database in question already exists.
However, is it safe to do so even if the database file
does _not_ exist? In other words, can multiple processes
safely compete to create a new database file?
Regards,
Iker
--
I will be out of the office starting 05/15/2006 and will not return until
05/30/2006.
I will be on travel to China and will be checking my email daily so I will
respond to you as soon as I can.
Please contact Jon Hamann if you need immediate assistance with OMS Product
Line or P30 OMS.
-Nicole
Is there a quicker way to get rid of a bunch of tables or I'm wrong
in something unseen (by me) ?
If you're dropping all the tables just drop the database (delete the file).
Otherwise I don't believe there is a faster method. You might redesign
to make it faster though. Place all the tables you
Hi list,
I'm running in a performance bottleneck in the following situation:
Database ~1.2 GB, sqlite 3.3.5, WinXP
~200 tables [phs_matrices_1 - phs_matrices_200] building the bulk of the
database. No AUTOVACUUM has been set.
Trying to drop these tables, the whole action requires ~2:45 min. The
20 matches
Mail list logo