[sqlite] Is there a substitute for Sqlite3_get_table ?

Hi, I have recently implemented SQlite into my Application which is an Engineering Analysis Software.I have implemented the DB in such a way that, I use the row_id as a primary integer key using this as an identifier for different fields in the table.Most of the fields in the table are VARCHAR

[sqlite] Re triving the database name from the sqlite pointer ....

Hi, I have a Sqlite3 pointer. Is there any way to get the filename of this pointer ? Regards, Atul -- View this message in context: http://www.nabble.com/Retriving-the-database-name-from-the-sqlite-pointer--tp25020127p25020127.html Sent from the SQLite mailing list archive at Nabble.com.

[sqlite] how to Select using results from other selects in a single SQlite querry statement ?

Hi, I have three tables, 1. Table Entity_xdata containing following fields |Entity_id|Layer|grpuid| 2. Table, group_xdata_pipe containing following fields |grpuid|LNV| 3. Table group_id_vs_reggappname containing following fields |grpuid|reggappname| Now, I need to Fire a query to

Re: [sqlite] how to Select using results from other selects in a single SQlite querry statement ?

Atul_Vaidya wrote: > > > SELECT DISTINCT Entity_xData.grpuid from Entity_xdata INNER JOIN > group_id_vs_regappname ON(Entity_xdata.grpuid = > group_id_vs_regappname.grpuid AND group_id_vs_regappname.reg_appname = > 'CPD1') > I get the grpuids using this command

Re: [sqlite] Looking for a w_char alternative for sqlite3_get_table

A.J.Millan wrote: > > Perhaps a seudo-code who let the same result using the standard API > functions would be enough. > > Check this out,It might help > > http://www.sqlite.org/cintro.html will help. > > Also see http://www.sqlite.org/cvstrac/wiki?p=SimpleCode for example of > use. >

Re: [sqlite] how to Select using results from other selects in a single SQlite querry statement ?

gets slower Thanks in Advance, Atul Igor Tandetnik wrote: > > Atul_Vaidya wrote: >> Hi, I have three tables, >> 1. Table Entity_xdata containing following fields >>> Entity_id|Layer|grpuid| >> >> 2. Table, group_xdata_pipe containing followin

Re: [sqlite] Making Update fast

Did you tried using the pragmas refer sqlite documentation for pragmas http://www.sqlite.org/pragma.html Atul souvik.datta wrote: > > > > Update set Flag=1 where Filename=; > > The updates taking huge amount of time. I tried to wrap these updates > within transactions (50 updates within

Re: [sqlite] sqlite3_exec fails on arm

Any help on this issue will be welcome, hi, Can you please specify what statement you are passing in to the sqlite3_exec please ? Atul -- View this message in context: http://www.nabble.com/sqlite3_exec-fails-on-arm-tp25293839p25340486.html Sent from the SQLite mailing list archive at Nabb

[sqlite] STL and SQLite

Hi, How to store a multimap in SQlite database ? My requirement is that i want to store a multimap in a column of the SQlite table Regards, Atul -- View this message in context: http://www.nabble.com/STL-and-SQLite-tp25340733p25340733.html Sent from the SQLite mailing list archive at Nabble.

Re: [sqlite] STL and SQLite

It would be great if i can refer to any example for this Regards, Atul Michal Seliga wrote: > > Atul_Vaidya wrote: >> Hi, >> How to store a multimap in SQlite database ? >> My requirement is that i want to store a multimap in a column >> of >> the SQlit

Re: [sqlite] STL and SQLite

Are you planning on querying for values through SQLITE or are you just using it for persistent storage? If it's just for storage then it's really easy. Thanks Teg-3, I am planning to use it for storage Regards, Atul -- View this message in context: http://www.nabble.com/S

[sqlite] Faster inserts in SQlite ...

Hi List, I have been using SQlite to store the information from my application.However,when i did a time analysis, I found that the sqlite contributes to Half of the total time.The data that i am storing in the Database using SQlite is retrieved on a per entity basis. In order, to enhance

[sqlite] how to compile SQlite 3.3.18 in visual studio 2008 ?

Hi, I want a statically linked SQlite Library connected to my application.I am using Visual Studio 2008.I created my own version using the three files as sqlite3.h,sqlite3.c and sqlite3ext.h.It does creates a Lib file,and i am getting it linked in to my application, however when i try to make a

[sqlite] how to use sqlite 3.6.18 in visual studio 2008 ?

Hi, I want a statically linked SQlite Library connected to my application.I am using Visual Studio 2008.I created my own version using the three files as sqlite3.h,sqlite3.c and sqlite3ext.h.It does creates a Lib file,and i am getting it linked in to my application, however when i try to make a

Re: [sqlite] Faster inserts in SQlite ...

Hi Nicolas, My application is windows based. I did set the pragma Page Size = 4096 as suggested by Alexey. but, it hardy made any difference to the speed. I am abandoning the multi-threading idea, as the other components used in my application aren't thread safe. Also, i was wonderi

[sqlite] Where to create index, a doubt ...

Hi list, I was told that indexing greatly enhance the speed of SQlite, however, i was cautioned that it comes in as an overhead, in terms of increased size of the database.The Database, that I am handling, isn't larger. Also, I was told, that one should watch, where to create the indexes. I