On Apr 14, 2009, at 4:00 PM, Bjorn Toft Madsen wrote:
Hi,
The docs for SQLite state:
- Situations Where Another RDBMS May Work Better
- Very large datasets
- [...] [sqlite] has to allocate a bitmap of dirty pages in the
disk file to help it manage its rollback journal. [...]
Hi All,
I tried to compile in Linux. But it is giving error at linking stage as
'unreferenced dlopne dlclose...
Can anybody help me?
With Regards
Pramoda.M.A
KPIT Cummins Infosystems Limited | Bengaluru | Board: +91 80 30783905
___
... and there was much rejoicing! :D
Is it thus safe to say that sqlite can handle 100+ GB of data, or are
other resources consumed exponentially as DB size goes up? (linear
growth I can understand and handle, exponential growth is a problem
for me)
Thanks,
Bjorn
2009/4/14 Dan
On Mon, Apr 13, 2009 at 11:14:17AM -0700, Julian Bui wrote:
Hi all,
I have a question about encoding blob bytes before inserting a record into
SQLite.
CONTEXT:
I have a base java (I'm using JDBC) class that has a many children. Each
child may store a different data type (such as String,
Alex Ousherovitch
alex.ousherovi...@opentv.com wrote in
message
news:5ee1928d06817b4788b64caf1a8517b002eae...@sfo-ex-01.ad.opentv.local
Igor, yes, deletes do occur on table_name, but before every insert
on table_name I delete all records from mods_log_table_name and
nevertheless get duplicates.
2009/4/14 Pramoda M. A pramod...@kpitcummins.com
Hi All,
I tried to compile in Linux. But it is giving error at linking stage as
'unreferenced dlopne dlclose...
Can anybody help me?
did you add the -ldl linker flag?
Vivien
___
sqlite-users
On Apr 14, 2009, at 6:33 AM, Dan wrote:
On Apr 14, 2009, at 4:00 PM, Bjorn Toft Madsen wrote:
Hi,
The docs for SQLite state:
- Situations Where Another RDBMS May Work Better
- Very large datasets
- [...] [sqlite] has to allocate a bitmap of dirty pages in the
disk file to help it
2009/4/14 Pramoda M. A pramod...@kpitcummins.com
What I have done is,
Cc -lpthread sqlite3.o ourApplication.o -o main
Then it is giving linker error. Is it right?
try instead:
cc -lpthread -ldl sqlite3.o ourApplication.o -o main
Vivien
___
Hi,
The docs for SQLite state:
- Situations Where Another RDBMS May Work Better
- Very large datasets
- [...] [sqlite] has to allocate a bitmap of dirty pages in the
disk file to help it manage its rollback journal. [...]
Aside from a larger page size, what remedies are suggested for
Hello,
I'm quite new at sqlite and I need to estimate the size the database I am
creating could reach. Basically, estimating for any table how many bytes
would be used for an average record.
I mainly use INTEGER and REAL values, along with a few TEXT attributes but I
couldn't find the number of
Hi All,
I tried to create object file of sqlite3.6.5 using
Gcc -c sqlite3.c
But it is giving following error.
In pthreaMutexAlloc,
PTHREAD_MUTEX_RECURSIVE IS UNDECLARED
Please can anybody tell me what options has to be used?
With Regards
Pramoda.M.A
KPIT Cummins
Nicolas Gaiffe
nicolas.gai...@gmail.com wrote in
message
news:a729b91e0904140537p7f97fae0q7f2afcb327e55...@mail.gmail.com
By the way, it seems INTEGER are stored on 2 to 8 bytes (from
http://theopensourcery.com/sqlitedocs/sqdatatype3.html ). What about
16-byte integers ?
SQLite doesn't support
I am trying to append text to a field within my database - sothat if a user has
stored 'search, tools' into the Tags column of tblEntry, they can add more tags
later like:
update tblEntry set Tags = Tags + ' new text' where RowID = 13
But whenever I try to do this I end up with 0 in the
Hi,
use the || - Operator to concatenate text. + adds to numbers.
update tblEntry set Tags = Tags || ' new text' where RowID = 13
martin
centipede moto wrote:
I am trying to append text to a field within my database - sothat if a user
has stored 'search, tools' into the Tags column of
Hi Guys,
I have a scenario where I am representing a tree in a table, standard
self relation ID/ParentId stuff. This tree contains bitflag data on each
item, and I want to be able to propagate the bitflag up to the parent by
repeatedly running a query that will bubble them up to the next Item.
Text concatenation is done with
||
Two vertical bars (virgules).
update tblEntry set Tags = Tags || ' new text' where RowID = 13
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Tristan Rhodes tristan.rho...@cotoco.com
wrote:
I have a scenario where I am representing a tree in a table, standard
self relation ID/ParentId stuff. This tree contains bitflag data on
each item, and I want to be able to propagate the bitflag up to the
parent by repeatedly running a query
Hi Igor,
There are potentially a lot of bitflags, so I'm going to have to make a
function, any good resources to get me started on this?
Tristan Rhodes
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik
Sent: 14
In addition, I am trying to do this in .Net. I've had a look and it
seems to only be available in PHP. Any way i can do this using the .Net
framework?
Regards
Tristan Rhodes
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of
My background is with SQL Server and Delphi, so the concepts in SQLite
are new for me. I have a TDISQLite3Database component in my TDataModule
with the DatabaseName set to Demo. Since I am familiar with the
TDataset and other Delphi components, I would like to use those (at the
expense of
Hello,
The last version of Sqlite.exe is not working with Windows 98
Where can I find the last version of Sqlite.exe compatible for windows 98 ?
Thank's
MaxMax14
___
sqlite-users mailing list
sqlite-users@sqlite.org
After successfully reading from a blob sequentially to a buffer in Objective C
the buffer seems to be altered such that it can no longer be accessed from
memory Is there some kind of special buffer type that I should be using?
Here is sample of my code:
int success;
NSData *inBuffer;
Tristan Rhodes tristan.rho...@cotoco.com
wrote:
There are potentially a lot of bitflags, so I'm going to have to make
a function, any good resources to get me started on this?
http://sqlite.org/c3ref/create_function.html
Igor Tandetnik
___
Tristan Rhodes tristan.rho...@cotoco.com
wrote:
In addition, I am trying to do this in .Net. I've had a look and it
seems to only be available in PHP.
It's definitely available in C.
Any way i can do this using the .Net framework?
No clue, sorry.
Igor Tandetnik
Joanne Pham joannekp...@yahoo.com wrote:
I have read this document and it stated that if a database connectin
in read-uncommitted mode does not attempt to obtain reaad-locks
before reading from database tables.
So in this case if the connection in read-uncommited modes then it
allows the
Hi Igor,
I have another question : how to enabled shared-cache mode for the connection?
Thanks,
JP
From: Igor Tandetnik itandet...@mvps.org
To: sqlite-users@sqlite.org
Sent: Tuesday, April 14, 2009 12:06:29 PM
Subject: Re: [sqlite] PRAGMA read_uncommitted = 1
Richard Dauben rdau...@sbcglobal.net wrote:
After successfully reading from a blob sequentially to a buffer in
Objective C the buffer seems to be altered such that it can no longer
be accessed from memory Is there some kind of special buffer type
that I should be using? Here is sample of
On Apr 14, 2009, at 12:48 PM, Richard Dauben wrote:
After successfully reading from a blob sequentially to a buffer in
Objective C
the buffer seems to be altered such that it can no longer be
accessed from
memory Is there some kind of special buffer type that I should
be using?
Joanne Pham joannekp...@yahoo.com wrote:
I have another question : how to enabled shared-cache mode for the
connection? Thanks,
http://sqlite.org/sharedcache.html
Igor Tandetnik
___
sqlite-users mailing list
sqlite-users@sqlite.org
Thanks Igor,
I called this function rc = sqlite3_enable_shared_cache(1); in my main program
to enable the share_cache so if this process is opened any connections then
these connections will be using share-cache right? Sorry for too many questions.
Thanks,
JP
Joanne Pham joannekp...@yahoo.com wrote:
I called this function rc = sqlite3_enable_shared_cache(1); in my
main program to enable the share_cache so if this process is opened
any connections then these connections will be using share-cache
right?
Yes.
Igor Tandetnik
Hi Lukáš,
And I've been trying to run the following query:
sqlite SELECT * FROM Event WHERE bringsSchedule = 0 AND
sourceMachine_id = 9 AND virtualClock = 1000 AND parent_fk IS NOT
NULL ORDER BY id DESC LIMIT 1;
835|29|0|309493|0|334|834|9||
CPU Time: user 0.027995 sys 0.00
Hi All,
I tried to compile sqlite3.6.5 in linux as
gcc -c sqlite3.c
It is giving error : in pthreadMutexAlloc
PTHREAD_MUTEX_RECURSIVE is undeclared...
Please help anybody...
With Regards
Pramoda.M.A
KPIT Cummins Infosystems Limited | Bengaluru | Board: +91 80 30783905
33 matches
Mail list logo