Hi Eric,
> I'm loking for some gui tools for looking at and changing my sqlite
> database,
See a comparison of several GUI SQLite tools here:
http://www.tandb.com.au/sqlite/compare/?ml
Tom
BareFeet
___
sqlite-users mailing list
sqlite-users@sqlite.o
I'm loking for some gui tools for looking at and changing my sqlite database,
the only ones I know of are the firefox extension and sqlitemanager. the
firefox extension fails with:
Error in opening file messages.sqlite - perhaps this is not an sqlite db file
Exception Name: NS_ERROR_FAILURE
Excep
It's security 101... a single point of authentication is better than
many points doing their own checks. I do in fact write the code to
write or not as needed, but last count I have 43,000 lines of code and
I'm smart enough to know I'm not perfect. Good security is done in
layers and in this case
Your rsync command might be ignoring any journal files that may be
outstanding.
John
On Fri, Mar 6, 2009 at 10:33 AM, Derrell Lipman wrote:
> On Thu, Mar 5, 2009 at 7:39 AM, Peter van Dijk
> wrote:
>
> > On Thu, Mar 05, 2009 at 04:30:50AM -0800, donnied wrote:
> > >
> > > rsync was corrupting t
Hi,
I see that SQLite executes statements like
CREATE TABLE t (a TEXT NULL);
create table g (x text constraint c null default 'abc');
even though NULL only as a column constraint this is not mentioned in the
syntax diagram
http://www.sqlite.org/lang_createtable.html
Am I missing somethi
On Sat, 7 Mar 2009 14:02:36 -0800 (PST), baxy77bax
wrote:
>
>hi,
>
>i need help with attaching databases. in my last post i recived some
>valuable info on limitation of attached databases (Thanx !!). since i'm
>using perl (its DBI) all modifications like cache_size, max page number ,
>journal siz
On 8/03/2009 9:02 AM, baxy77bax wrote:
> hi,
>
> i need help with attaching databases. in my last post i recived some
> valuable info on limitation of attached databases (Thanx !!). since i'm
> using perl (its DBI) all modifications like cache_size, max page number ,
> journal size ... i've introd
On 8/03/2009 4:27 AM, P Kishor wrote:
> On Sat, Mar 7, 2009 at 10:59 AM, Tom Spencer wrote:
>> Is there a way to set the current database handle as read-only? I'm
>> connecting to an SQLite3 database (actually two including an attached
>> database) using Perl with DBD::SQLite, which doesn't seem
hi,
i need help with attaching databases. in my last post i recived some
valuable info on limitation of attached databases (Thanx !!). since i'm
using perl (its DBI) all modifications like cache_size, max page number ,
journal size ... i've introduced through PRAGMA but for limitations on
number
On Fri, 06 Mar 2009, Rich Shepard might have said:
> On Fri, 6 Mar 2009, Hans-Martin wrote:
>
> > It seems that there is no way to get rid of the embedded CR/LF without parse
> > the complete output.
>
>Use sed. That's what it's for.
>
> Rich
Or tr(1) if it's a single character.
Mike
If your goal is to handle 1 million inserts/updates per second, and a
hard transaction to disk takes 1/60th of a second, you need at least
1 insert/updates per transaction.
Do your testing with a transaction size of 20,000 and see what kind of
performance you get. I'd probably set it higher,
On Sat, Mar 7, 2009 at 10:59 AM, Tom Spencer wrote:
> Is there a way to set the current database handle as read-only? I'm
> connecting to an SQLite3 database (actually two including an attached
> database) using Perl with DBD::SQLite, which doesn't seem to implement
> the ReadOnly database handle
Is there a way to set the current database handle as read-only? I'm
connecting to an SQLite3 database (actually two including an attached
database) using Perl with DBD::SQLite, which doesn't seem to implement
the ReadOnly database handle attribute. Is there some kind of setting
or pragma that wil
Hi.
I'm trying to convert a sqlite3 database into sqlite2 database with:
c...@emx:~$ sqlite3 banco.sqlite3 .dump > dump3
c...@emx:~$ echo '.read dump3' | sqlite banco.sqlite2
CREATE TABLE `abc` (`test` TEXT);
SQL error: unrecognized token: "`"
c...@emx:~$
I know that the problem is in `abc`, but
If you need high concurrency then you probably shouldn't spend too
much time looking at SQLite.
That said, how often do you actually need to read information from
this database? If you need to insert a lot but not necessarily read a
lot you might consider simply appending new information al
On Sat, 7 Mar 2009 04:18:42 -0800 (PST), baxy77bax
wrote:
>
> hi
>
> i have a problem , my program is returning me the
> message that sqlite is complaining, because it
> can't attach more than 10 databases at once.
> is that true ? and is there a way to attach
> at least 30 db at once ?
It's in
On Sat Mar 7 12:18:42 GMT 2009
baxy,,,hi.htnet.hr wrote:
> i have a problem , my program is returning me the message
> that sqlite is > complaining, because it can't attach more
> than 10 databases at once. is that true ?
> and is there a way to attach at least 30 db at once ?
See "Limits In SQLi
hi
i have a problem , my program is returning me the message that sqlite is
complaining, because it can't attach more than 10 databases at once. is that
true ? and is there a way to attach at least 30 db at once ?
thanx!
bax
--
View this message in context:
http://www.nabble.com/is-there-any
On Sat, 7 Mar 2009 14:22:28 +0800, kin foo
wrote:
>Hi I'm wondering if it is possible to import a table from an SQLite database
>to another SQLite database.
>Thanks!
ATTACH DATABASE 'database2.db' AS db2;
CREATE TABLE table1 AS SELECT x,y FROM db2.table2;
DETACH DATABASE db2;
http://www.sqlite.
On Sat, 7 Mar 2009 01:09:28 -0800 (PST), liubin liu
<7101...@sina.com> wrote:
>I'm very happy that my question have triggerred the wiki-FAQ's question.
>
>but if the next version could solve(settle?) the question,
>many guys will be happy, :)
In my opinion, there is no problem, so there is nothin
Yes, I'm looking for the digest articles.
and appreciate you for you tell me that, :)
Ribeiro, Glauber wrote:
>
> Are you looking perhaps for digest mode? Yes, there is a digest mode for
> the SQLite email lists, it's one of the options you can set up.
>
> Or are you thinking of posts that we
Am Freitag, 6. März 2009 23:33:33 schrieb John Machin:
> On 7/03/2009 6:16 AM, Rich Shepard wrote:
> > On Fri, 6 Mar 2009, Hans-Martin wrote:
> >> It seems that there is no way to get rid of the embedded CR/LF without
> >> parse the complete output.
> >
> >Use sed. That's what it's for.
>
> Has
I'm very happy that my question have triggerred the wiki-FAQ's question.
but if the next version could solve(settle?) the question, many guys will be
happy, :)
and now, does it mean that we have to use link-list struct to write such
kind of codes?
Kees Nuyt wrote:
>
> On Fri, 6 Mar 2009 02:15
I use an excellent piece of software called AutoIT
(http://www.autoitscript.com). AutoIt is a very flexible easy to use
programming language which supports SQLite. I used it to write a csv
import program for SQLite. Took me 10 minutes. If you would like to
see the source as an example just say.
Ch
John,
looking at your example I have only some of the
standard remarks that might help to speed up:
1. add an index on tbl_data(cell) since you query/update
for cell = ?", each time.
2. Try to increase the cache for example by using:
db.execDML("PRAGMA page_size = 4096;");
db.execDML
25 matches
Mail list logo
