Stefan Arentz wrote:
> First, the index is completely unusable.
>From the few authors I have spoken to, they don't make the index
themselves. The publisher does it using someone else and you end up
with junk, and they bill the author for it!
It is a miracle any computer books are any good. I
В сообщении от Thursday 19 June 2008 02:37:57 Dennis Cote написал(а):
> I'm not sure if you even need unique id numbers for these records, or
> why you are concerned that there might be multiple records with the same
> save_date for that matter? Is this table linked to any others?
I'm using URL
Hi all,
Short question:
Do you have or know where to find some regex (regular expressions) for
parsing SQLite statements such as create table, create trigger etc
into their component parameters?
More detail:
SQLite gives us the Name, Tbl_Name and SQL of create statements via
the
First, thanks for all your answers.
I would like to come back to my question (see first post).
All events come sequentially (because it's a time line).
I can have more than one event during the same time but I use 1 different
bit to identify each event types.
I think it's important to use this
Hello Everyone,
I was hoping that someone could explain why my updates are taking so long.
My schema is as follows:
CREATE TABLE Objects (ObjectId INTEGER PRIMARY KEY, Name TEXT, Type INTEGER,
Lock INTEGER, Data BLOB 3DDataId INTEGER DEFAULT NULL)
My table has 12,243 rows.
when I execute the
I use a language called PureBasic and am playing with BLOB data. Got data
saving successfully but read in these forums that updating is the same. Yes,
I know it's a compiled statement, saving to database is fine, I can even
view my saved blobs so I know my code works..
The SQL to insert the blob
> First, the index is completely unusable.
I'll second that, worst index that I have ever tried to use.
On Wed, Jun 18, 2008 at 11:05 PM, Roger Binns <[EMAIL PROTECTED]> wrote:
> Stefan Arentz wrote:
> > First, the index is completely unusable.
>
> From the few authors I have spoken to, they
Alexey Pechnikov wrote:
>
> P.S. Is any method for multy-master replication of SQLite databases?
Nothing built in, but I believe several user have developed their own
systems to do this. You would probably be better off asking this
question in a new thread.
Dennis Cote
Raphaël KINDT wrote:
>
> All events come sequentially (because it's a time line).
> I can have more than one event during the same time but I use 1 different
> bit to identify each event types.
>
> I think it's important to use this sequential constraint to do the delete
> request.
> But SQLite3
Stephen Woodbridge wrote:
>
> Well if the index requires fewer page reads then it should be
> proportionally faster. For example if you can only get 5 rows on a page
> but 25 index entries, you have 1/5 the number of pages to read.
>
Yes, that is true, but this effect is offset by the fact
On Wed, 18 Jun 2008, Roger Binns wrote:
> From the few authors I have spoken to, they don't make the index
> themselves. The publisher does it using someone else and you end up with
> junk, and they bill the author for it!
Roger,
That's not always the case. Springer would not hire a
BareFeet wrote:
> So, before I get too far into it, I figured others of you out there
> must already have some regexes that are suitable for this, or know of
> a simpler approach. Or at worst any regex gurus out there that can
> help fine tune the above?
>
Regular expressions are generally
flakpit wrote:
>
> The SQL to insert the blob into my database is :
>
> "INSERT INTO archive (docnumber, document) VALUES (?,?)"
>
> How to change the syntax to update a blob field? Is it the same as updating
> normal data or a variant on the above?
You can replace the data using an replace
On Jun 19, 2008, at 9:17 AM, Jason Tudor wrote:
> Hello Everyone,
>
> I was hoping that someone could explain why my updates are taking so
> long.
> My schema is as follows:
>
> CREATE TABLE Objects (ObjectId INTEGER PRIMARY KEY, Name TEXT, Type
> INTEGER,
> Lock INTEGER, Data BLOB 3DDataId
Hello!
Is any method for multy-master replication of SQLite databases?
Best regards, Alexey.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Alexey Pechnikov wrote:
> Hello!
>
> Is any method for multy-master replication of SQLite databases?
>
http://www.google.com/search?num=100=en=1=sqlite++replication
___
sqlite-users mailing list
sqlite-users@sqlite.org
Okay that worked, thanks.
Just curious though... I've compiled C and C++ code together many times.
I've never had a problem before since C is basically a subset of C++.
Why doesn't it work here?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of D.
On Wed, 18 Jun 2008 19:58:02 -0400, D. Richard Hipp wrote:
>
> On Jun 18, 2008, at 7:12 PM, Andrea Connell wrote:
>
>> I want to use the C API with a C++ class but when I try compiling...
>>
>> $ aCC -AA +W829 main.cpp sqlite3.c
>> main.cpp:
>> sqlite3.c:
>> Error 482: "sqlite3.c", line 532 #
On Jun 19, 2008, at 10:49 PM, Matt Sergeant wrote:
> On Wed, 18 Jun 2008 19:58:02 -0400, D. Richard Hipp wrote:
>>
>> On Jun 18, 2008, at 7:12 PM, Andrea Connell wrote:
>>
>>> I want to use the C API with a C++ class but when I try compiling...
>>>
>>> $ aCC -AA +W829 main.cpp sqlite3.c
>>>
On Jun 19, 2008, at 11:49 AM, Matt Sergeant wrote:
>
> Note that there are some C++ style comments crept back into the code
> (I
> noticed in the amalgamation, so I can't give you a direct pointer to
> them). This causes compile failures on stricter C compilers.
Already been fixed.
В сообщении от Thursday 19 June 2008 20:23:22 Stephen Woodbridge написал(а):
> Alexey Pechnikov wrote:
> > Hello!
> >
> > Is any method for multy-master replication of SQLite databases?
>
> http://www.google.com/search?num=100=en=1=sqlite++replication
Are you really saw solution for replication
The blob sizes are about 24KB.
I downloaded the sqlite3_analyzer, is there any documentation on this? It's
just an executable and when I dbl click I get a console window that
disappears.
Also, the time I gave was wrong, it was closer to 55 seconds. I set the
synchronous flag to 0 (NONE) and
On Thu, Jun 19, 2008 at 09:20:24AM -0700, Jason Tudor scratched on the wall:
> The blob sizes are about 24KB.
You do understand the command "UPDATE Objects SET Lock = 1" will
update all 12,243 rows, right? And that requires the whole table to
be sucked in off disk, modified, and written
Alexey Pechnikov wrote:
> В сообщении от Thursday 19 June 2008 20:23:22 Stephen Woodbridge написал(а):
>> Alexey Pechnikov wrote:
>>> Hello!
>>>
>>> Is any method for multy-master replication of SQLite databases?
>> http://www.google.com/search?num=100=en=1=sqlite++replication
>
> Are you really
A limited SQL parser is fairly simple. You could write the program and
launch it from a scripting language as a filter program with input and
output piped.
Dennis Cote wrote:
> BareFeet wrote:
>
>>So, before I get too far into it, I figured others of you out there
>>must already have some
В сообщении от Thursday 19 June 2008 21:47:12 Stephen Woodbridge написал(а):
> Alexey Pechnikov wrote:
> > В сообщении от Thursday 19 June 2008 20:23:22 Stephen Woodbridge
написал(а):
> >> Alexey Pechnikov wrote:
> >>> Hello!
> >>>
> >>> Is any method for multy-master replication of SQLite
All:
I noticed the following when using sqlite to timestamp flags in an
embedded system. I will lay out the tests performed and the results I
got.
First, an overview. I am working with a linux 2.6.26 kernel and
sqlite v3.5.0. For the handling of timezones, I use the zoneinfo
files.
On Thu, Jun 19, 2008 at 3:28 PM, Rich Rattanni <[EMAIL PROTECTED]> wrote:
>
> So this email isn't blaming SQLite for my improper timestamps even
> after I set the correct zoneinfo file. I am just trying to
> understand what is going on. Should I assume that my observation of
> 'Set zoneinfo
On Thu, Jun 19, 2008 at 4:35 PM, Matthew L. Creech <[EMAIL PROTECTED]> wrote:
>
> I think this behavior is probably due to the way localtime() works in
> glibc. From what I've seen (at least on my embedded ARM-Linux board),
> localtime() only invokes tzset() the first time it's run by an
>
Matthew:
I simply called tzset() after I extract the timezone file. It worked
like a charm. Thank you very much! I was having a heck of a time
information online.
On Thu, Jun 19, 2008 at 4:53 PM, Matthew L. Creech <[EMAIL PROTECTED]> wrote:
> On Thu, Jun 19, 2008 at 4:35 PM, Matthew L. Creech
This looks interesting:
http://sqlitedbms.sourceforge.net/index.htm
Alexey would this work for your multi-master replication? Maybe you
modify this to work for the specific task you have in mind.
-Steve
___
sqlite-users mailing list
31 matches
Mail list logo
