[sqlite] Giving error While compiling sqlite in Linux

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

Re: [sqlite] Problem with ordering

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

Re: [sqlite] PRAGMA read_uncommitted = 1

Joanne Pham 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

Re: [sqlite] PRAGMA read_uncommitted = 1

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

Re: [sqlite] PRAGMA read_uncommitted = 1

Joanne Pham 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

Re: [sqlite] sqlite3_blob_read problem with buffer in Objective C

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

Re: [sqlite] sqlite3_blob_read problem with buffer in Objective C

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? Here is

Re: [sqlite] PRAGMA read_uncommitted = 1

Hi Igor, I have another question : how to  enabled shared-cache mode for the connection? Thanks, JP From: Igor Tandetnik To: sqlite-users@sqlite.org Sent: Tuesday, April 14, 2009 12:06:29 PM Subject: Re: [sqlite] PRAGMA read_uncommitted =

Re: [sqlite] PRAGMA read_uncommitted = 1

Joanne Pham 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

Re: [sqlite] Aggregating BitFlags

Tristan Rhodes 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

Re: [sqlite] Aggregating BitFlags

Tristan Rhodes 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 ___

[sqlite] sqlite3_blob_read problem with buffer in Objective C

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;

[sqlite] SQLite.exe for windows 98

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

[sqlite] Newbie question about creating tables

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

Re: [sqlite] Aggregating BitFlags

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

Re: [sqlite] Aggregating BitFlags

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

Re: [sqlite] Aggregating BitFlags

Tristan Rhodes 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

Re: [sqlite] Appending Text to a Column

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

[sqlite] Aggregating BitFlags

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.

Re: [sqlite] Appending Text to a Column

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

[sqlite] Appending Text to a Column

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

Re: [sqlite] How to calculate the size of my database for n records ?

"Nicolas Gaiffe" 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

[sqlite] sqlite3 is giving error while creating object file in Linux

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

[sqlite] How to calculate the size of my database for n records ?

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

Re: [sqlite] How to minimize or remove need for dirty bitmap memory size?

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

Re: [sqlite] Sqlite3 is not compiling in Linux

2009/4/14 Pramoda M. A > 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

Re: [sqlite] Sqlite3 is not compiling in Linux

2009/4/14 Pramoda M. A > 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 ___

Re: [sqlite] Implicit indices on TEMP tables

"Alex Ousherovitch" wrote in message news:5ee1928d06817b4788b64caf1a8517b002eae...@sfo-ex-01.ad.opentv.local > Igor, yes, deletes do occur on , but before every insert > on I delete all records from mods_log_ and > nevertheless get duplicates. I would expect the

Re: [sqlite] Storage of blobs: to encode or not to encode?

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

[sqlite] Sqlite3 is not compiling in Linux

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 ___

Re: [sqlite] How to minimize or remove need for dirty bitmap memory size?

... 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

Re: [sqlite] How to minimize or remove need for dirty bitmap memory size?

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. [...]

[sqlite] How to minimize or remove need for dirty bitmap memory size?

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