[sqlite] Password protection to sqlite3 db file

Hi, Is it possible to protect sqlite3 db file with password protection in Linux. Techi

[sqlite] Sqlite3 handler uses

What is the best practice to use sqlite3 handler in multithread environment.[I am using on Linux] · Open sqlite3 database file once & use the same sqlite3 handler in all the thread for any operation on sqlite3 database file. or · Open & close all the time for each operation on

[sqlite] duplicate row in sqlite3 database

Hi, SQlite3 have any method where it can avoid adding duplicate row or throwing error status code on duplication., Techi- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite3 & Concurrency

Many Thanks for quick reply. Could you please suggest me other journal mode for second case.My target filesytem dosen't support mmap & WAL required mmap support. Thanks On Wed, Apr 23, 2014 at 3:05 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 23 Apr 2014, at 10:29am,

[sqlite] Sqlite3 & Concurrency

Hi, Please correct me on below points for Sqlite3 on Linux platform. 1) Sqlite3 doesn’t have any concurrency issue when multiple process reading one database file at same time. This doesn’t required any special mode setting (Like WAL) 2) One process is reading & other process

Re: [sqlite] Memory leak in online backup api

Any hint will help me to identify root cause of leak. Thanks On Mon, Mar 10, 2014 at 2:58 PM, techi eth <techi...@gmail.com> wrote: > Hi, > > I come across memory leak with sqlite3 online backup api (Leak detected by > valgrind tool). I have used reference code from b

[sqlite] Memory leak in online backup api

Hi, I come across memory leak with sqlite3 online backup api (Leak detected by valgrind tool). I have used reference code from below link for test. (Online backup for running database) http://www.sqlite.org/backup.html Please find below memory leak snapshot for reference. ==6084== 78,688 (880

Re: [sqlite] SQlite3 Performnace

.at> wrote: > .timer on (in the sqlite shell) > > Unless you are storing the databases on different disks AND your SQLite > queries are IO bound I don't expect any performance gains. > > -Ursprüngliche Nachricht- > Von: techi eth [mailto:techi...@gmail.com] > Ges

[sqlite] SQlite3 Performnace

Hi, Is there any way I can check SQlite3 Database read/write timing for performance measurement. What are the changes in performance if I have single SQlite3 Database file (Contain 'N' table) or 'N' Database file each contain single table. Regards, Techi

Re: [sqlite] SQlite3 Query Format for Export

I need this often. If possible provide some hint of plugin in Linux platform. Thanks On Tue, Nov 19, 2013 at 7:01 PM, RSmith wrote: > > What will be the query format to export database table data into different >> export format (CSV,HTML,XML,SQL) ? >> >> > This is not an

[sqlite] SQlite3 Query Format for Export

Hi, What will be the query format to export database table data into different export format (CSV,HTML,XML,SQL) ? Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Inter Process Communincation using SQLite3 Trigger

Thanks for answer. I am in sync with your answer. I believe their is no risk from SQLite3 point of view to handle the mentioned case. On Fri, Nov 1, 2013 at 6:47 PM, Igor Tandetnik <i...@tandetnik.org> wrote: > On 11/1/2013 5:58 AM, techi eth wrote: > >> 1) Is proc

Re: [sqlite] Dropping Trigger from Table

3 PM, RSmith <rsm...@rsweb.co.za> wrote: > On 2013/11/01 14:41, techi eth wrote: > >> I think so checking possible cases of any sqlite operation should not be >> called as bogus. Where ever I am not sure I will ask expert help & I have >> got all the

Re: [sqlite] Dropping Trigger from Table

ould suggest how to best get there (as many have done here > already). > > > > > On 2013/11/01 13:53, techi eth wrote: > >> How to drop trigger from specific table with condition around? >> >> >> >> I tried this but got syntax error. >> >> DRO

[sqlite] Dropping Trigger from Table

How to drop trigger from specific table with condition around? I tried this but got syntax error. DROP TRIGGER trigger_name From tbl_name = TestTbl WHERE ; Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Inter Process Communincation using SQLite3 Trigger

Hi, I understand SQLite3 will not be able to handle any IPC related operation. I am attempting my idea below to handle IPC with the help of SQLite3 Trigger. *Scenario:* I have two processes. Process – A will be responsible to create trigger & Process -B will doing operation like update,

[sqlite] Hex value with DEFAULT Constraint

Is it possible to attach hex value with DEFAULT constraint? I am getting return error code as SQLITE_ERROR & detail error message as "unrecognized token". ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Feature Request: Binding Arrays

It is really useful feature. I have a use case where I need to log the data in continuous interval & store in database. If array type is supported by sqlite then in single row I can store data in array of time stamp & array of value. Is it specific to int type or any other data type can be

Re: [sqlite] Segmentation Fault With Trigger

Please provide me hint to solve the issue. Thanks.. On Fri, Oct 11, 2013 at 7:58 PM, techi eth <techi...@gmail.com> wrote: > It is giving same trace what i have sent last time. > > It is possible by some one to send test code snapshot of scenario of > selecting user defi

Re: [sqlite] Segmentation Fault With Trigger

013 at 10:06 AM, techi eth <techi...@gmail.com> wrote: > > > Please provide some hint. > > > > Recompile with -O0 and -g and then post the stack trace after the segfault. > > -- > D. Richard Hipp > d...@sqlite.org > ___

Re: [sqlite] Segmentation Fault With Trigger

provide by me. Thanks On Fri, Oct 11, 2013 at 7:41 PM, Stephan Beal <sgb...@googlemail.com> wrote: > On Fri, Oct 11, 2013 at 4:06 PM, techi eth <techi...@gmail.com> wrote: > > > > #4 0x778e1127 in SqliteTestInsert (SQLitePrivate=0x602300, > > > TableName_

Re: [sqlite] Segmentation Fault With Trigger

); } /*Create Function */ sqlite3_create_function(Handler, "Test",1, SQLITE_UTF8, NULL, , NULL, NULL); /*Create Trigger Query */ create trigger TestTrigger after insert on dbTestTbl for each row begin SELECT Test (new.RowId) from dbTestTbl; end; On Fri, Oct 11, 2013 at 5:55 PM, techi eth <techi...@gma

Re: [sqlite] Segmentation Fault With Trigger

2013 at 5:35 PM, Richard Hipp <d...@sqlite.org> wrote: > On Fri, Oct 11, 2013 at 7:57 AM, techi eth <techi...@gmail.com> wrote: > > > Hi, > > > > I am getting segmentation fault while executing query in sqlite3. [Linux > > OS]. > > > >

[sqlite] Segmentation Fault With Trigger

Hi, I am getting segmentation fault while executing query in sqlite3. [Linux OS]. Find below sequence. // Getting SQLiteHandler OpenConnection (); //Creating user defined function “Test” sqlite3_create_function(SQLiteHandler, "Test",1, SQLITE_UTF8, NULL, , NULL, NULL) //Creating table,Below

[sqlite] Array Accessing in SQLite

Hi, Can anyone let me know what is best way to handle C Array in SQLite3 database ? As of now I can think of creating multiple row for storing each array element. Thanks.. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Sqlite handler in trigger

capability & application logic!!! On Fri, Sep 6, 2013 at 10:34 AM, Igor Tandetnik <i...@tandetnik.org> wrote: > On 9/6/2013 12:51 AM, techi eth wrote: > >> I am not sure if my problem I have stated clearly,

Re: [sqlite] Sqlite handler in trigger

tion? Thanks.. On Thu, Sep 5, 2013 at 6:55 PM, Igor Tandetnik <i...@tandetnik.org> wrote: > On 9/5/2013 5:39 AM, techi eth wrote: > >> I have case where one process is updating data with his private handler >> but >> trigger on update is created by other process by his pr

[sqlite] Sqlite handler in trigger

Hi, I would like to check sqlite handler usability while using trigger: I have register one function to sqlite by sqlite3_create_function().Now I am creating trigger on update & selecting that function for callaback. In above scenario it is mandatory that sqlite3 handler used while create

Re: [sqlite] Table Creation Behaviour!!!

Thanks. What about INSERT query behavior. Is their any specific reason of allowing inserting same data set which is already present in database ? Cheers - On 8/30/13, Clemens Ladisch <clem...@ladisch.de> wrote: > techi eth wrote: >> I have open the connection, created the table

[sqlite] Table Creation Behaviour!!!

Query Regarding Table Creation : I have open the connection, created the table by using CREATE TABLE IF NOT EXISTS , doing some operation & closing the connection. If I again open the connection & try to do table creation again (With same table name & same database file) then what will be the

Re: [sqlite] Database File Size

I am holding open connection handler as long as i required in system. Thanks.. Cheers - Techi On 8/30/13, techi eth <techi...@gmail.com> wrote: > I am using Jffs2 file system. As of now I using all default from > sqlite3.I am not sure with this information it is possible to get some >

Re: [sqlite] Database File Size

of each page database file size is get calculated. What is default setting for max_page_count (I leanr Default for page is 1KB) Cheers - Techi On 8/29/13, Simon Slavin <slav...@bigfraud.org> wrote: > > On 29 Aug 2013, at 9:11am, techi eth <techi...@gmail.com> wrote: > >> 1

Re: [sqlite] Database locking Error

Thanks for suggestion. I will take it forward. locking will happen with two simultaneous processes accessing for read also? Thanks On 8/29/13, Simon Slavin <slav...@bigfraud.org> wrote: > > On 29 Aug 2013, at 6:48am, techi eth <techi...@gmail.com> wrote: > >

[sqlite] Sqlite3 on JFFS2 File System

Hi, Anybody have used Sqlite3 on JFFS2 file system with Journal_mode = WAL. I have found issue of I/O error. Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Database File Size

Database files size: 1) Is their any way I can calculate approx file size based on data. Ex : Let us say i am creating table with (row ID int ,Test Text). Each text string size is 10 byte. If I will create 100 row of this in database then what would be Max size of created database file.

[sqlite] auto_vacuum default setting

When I look through details about PRAGMA auto_vacuum,I think it is always beneficial to have auto_vaccum set to Full so that whenever delete happens we have shrink of size. http://www.sqlite.org/pragma.html#pragma_auto_vacuum I wanted to know is their any benefit to have this to none in default

Re: [sqlite] Database locking Error

I am checking for all the function.As of now i am not using sqlite3 time out but testing application will take decision accordingly to recall the operation based on type of error. On Wed, Aug 28, 2013 at 3:03 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 28 Aug 2013, at 9

Re: [sqlite] I/O error in sqlite3

Kindly let me know the reason for I/O error. WAL mode is creating problem on ARM target. Thanks.. On Tue, Aug 27, 2013 at 10:13 AM, techi eth <techi...@gmail.com> wrote: > I have got the reason for I/O error: > > It is due to PRAGMA journal mode WAL. If I run with defau

Re: [sqlite] Database locking Error

Yes, i am checking the return code. On Tue, Aug 27, 2013 at 5:09 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 27 Aug 2013, at 5:15am, techi eth <techi...@gmail.com> wrote: > > > For read operation i am doing _prepare(), _step(), _finalize(). > > For all

Re: [sqlite] I/O error in sqlite3

. On Tue, Aug 27, 2013 at 9:58 AM, techi eth <techi...@gmail.com> wrote: > What is possible cause of I/O error in sqlite3? > > My application is running fine on Desktop PC.Same application when I try > to run on ARM target it is giving I/O error. > > sqlite3 on Host : 3.7

[sqlite] I/O error in sqlite3

What is possible cause of I/O error in sqlite3? My application is running fine on Desktop PC.Same application when I try to run on ARM target it is giving I/O error. sqlite3 on Host : 3.7.9 sqlite3 on Target : 3.7.14.1 ___ sqlite-users mailing list

Re: [sqlite] Database locking Error

For read operation i am doing _prepare(), _step(), _finalize(). For all other operation i am doing _exec(). Do you see any issue ? Cheers - Techi On Mon, Aug 26, 2013 at 9:22 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 26 Aug 2013, at 9:02am, techi eth <techi...@g

Re: [sqlite] Database locking Error

database as a persistent property? Is their any issue if we set all option again with every new connection to same file? On Mon, Aug 26, 2013 at 2:40 PM, Kees Nuyt <k.n...@zonnet.nl> wrote: > On Mon, 26 Aug 2013 13:32:42 +0530, techi eth <techi...@gmail.com> > wrote: > > >

Re: [sqlite] Database locking Error

On Mon, Aug 26, 2013 at 12:14 PM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 08/26/2013 01:37 PM, techi eth wrote: > >> Hi, >> >> I come across database file locking error while trying below case with >> Update. >> >> Case: One process is upda

[sqlite] Database locking Error

Hi, I come across database file locking error while trying below case with Update. Case: One process is updating a Colum periodically & other process is selecting same Colum or other colum in table periodically for read. What is the best way to handle so that Update will not get locking error?

[sqlite] BLOB & Other Data Type

Hi, What is difference by using Colum data type as blob or Any other (Text,INT,REAL,NUMERIC) http://www.sqlite.org/datatype3.html According to above link I understand “The value is a blob of data, stored exactly as it was input”.I beleive that it what required. Ex : Please let me know

[sqlite] SELECT Count

Hi, What is the way to get number of possible count matching with criteria for SELECT? SELECT Colum from Table WHERE Criteria I tried with sqlite3_count_changes() & sqlite3_data_count() function but they are not returning actual value. Definitely getting Colum count by sqlite3_coloum_count ()

[sqlite] Number of Colum!!!

Is their any limit on number of Colum in SQLite3 table? Cheers - Techi ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite3 error string size!!!

Hi, What is the maximum size error string returned by sqlite3_errmsg() function ? Cheers – Techi ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Default Constraint Behaviour!!!

Is it possible to read default value of any Colum? Ex : Create table by adding default constraint to Colum & then read back the default constraint value before doing INSERT,UPDATE. Cheers - Techi ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Where Clause

t; -Ursprüngliche Nachricht- > Von: techi eth [mailto:techi...@gmail.com] > Gesendet: Freitag, 02. August 2013 13:13 > An: General Discussion of SQLite Database > Betreff: Re: [sqlite] Where Clause > > I was checking for Update only if condition will match. > > I

Re: [sqlite] Query on Update or Selective Insert

"variable"? > > -Ursprüngliche Nachricht- > Von: techi eth [mailto:techi...@gmail.com] > Gesendet: Mittwoch, 07. August 2013 10:50 > An: General Discussion of SQLite Database > Betreff: [sqlite] Query on Update or Selective Insert > > Query on Update or Selective Inse

[sqlite] Query on Update or Selective Insert

Query on Update or Selective Insert: I am trying to update 100 variables at a time & due to some of the reason 99 th or any mid index variable cause update to fail. In that case this query has to execute it again for the entire variable or only for failed variable. Cheers - Techi

Re: [sqlite] Where Clause

eem to be expecting that the field is changed also in records that do > not satisfy the condition. > > Or perhaps you really want something like: > > BEGIN; > SELECT COUNT() FROM WHERE ; > if count == 0 > raise exception > else > UPDATE ... >

Re: [sqlite] Where Clause

ion; > } else { > error = unlock( file ); > if (error) raise exception; > } > } > > HTH > Gunter > > -Ursprüngliche Nachricht- > Von: techi eth [mailto:techi...@gmail.com] > Gesendet: Freitag, 02. August 2013 1

Re: [sqlite] Query on database back-up:

Thanks.All cases clear except below What happen if other process is not able to complete operation within timeout duration? Cheers - Techi On Fri, Aug 2, 2013 at 2:28 PM, Clemens Ladisch <clem...@ladisch.de> wrote: > > techi eth wrote: > >> 1. "Any databas

Re: [sqlite] Where Clause

; Hi > Why do you think it should return error? > On Aug 2, 2013 1:15 AM, "techi eth" <techi...@gmail.com> wrote: > > > Come across one issue with conditional query execution. > > > > Query: UPDATE COMPANY SET Name= 'test' WHERE ID = 2; > >

[sqlite] Where Clause

Come across one issue with conditional query execution. Query: UPDATE COMPANY SET Name= 'test' WHERE ID = 2; According to my understanding if no ID = 2 is present in table then error should return but it return with SQLITE_OK however Name value is not changed. Cheers - Techi

Re: [sqlite] Query on database back-up:

Appreciate if I will get clarification. If any of the point out of the scope of mailing list then please mark. Thanks a lot!!! On Wed, Jul 31, 2013 at 6:53 PM, techi eth <techi...@gmail.com> wrote: > Thanks for answer. > > Let me put my query on point mentioned by compari

[sqlite] Transaction Handling

Is it possible to use Sqlite3 transaction capability based on actual return of individual transaction query execution? Example: BEGIN SELECT for reading the database (Here I will get data in my read call back function Based on data status I may initiate other transaction, like below Update)

Re: [sqlite] Query on database back-up:

the database file the backup database may be corrupted following system recovery" This is very useful benefit. What is the resulted outcome of power failure or OS failure if we use backup API? On 7/31/13, Simon Slavin <slav...@bigfraud.org> wrote: > > On 31 Jul 2013, at 12:56pm, tec

[sqlite] Query on database back-up:

Hi, Case: “I copied first five pages from database using online backup api & during sleep time other process write to database which is actually part of first copied five pages, In that case at the end of backup can I assure I will have my database backed up with latest changes. (Changes done

Re: [sqlite] Integrity Check Failure Handling

rote: > > On 29 Jul 2013, at 10:21am, techi eth <techi...@gmail.com> wrote: > > > Reference from below link gave me hint about integrity check failure case > > recovery by Export/Import of database. > > > > Please let me know is this is correct & way to hand

[sqlite] Integrity Check Failure Handling

Reference from below link gave me hint about integrity check failure case recovery by Export/Import of database. Please let me know is this is correct & way to handle integrity failure check. http://blog.niklasottosson.com/?p=852

Re: [sqlite] Access Permission on Table

set_authorization function. Appreciate if I will get link to example. Cheers- Techi On Mon, Jul 22, 2013 at 2:53 PM, Simon Davies <simon.james.dav...@gmail.com>wrote: > On 22 July 2013 10:02, techi eth <techi...@gmail.com> wrote: > > Is their any statement I can build using SQLite3,

[sqlite] Memory Access

I would like to check how we can restrict SQLite3 for more updating/dropping (I think this two will restrict flash life) based on memory life. If I say my flash will support ‘N’ Thousand access over the life time. Cheers- Techi ___ sqlite-users

[sqlite] Access Permission on Table

Is their any statement I can build using SQLite3, which will provide me access permission over table. Let us say I have 3 tables (table 1, table 2, table 3). Here I am looking Read permission for one->many but Write can be done by creator of table only. If other will try to access then they

Re: [sqlite] Trigger Logic!!!

t; PS: On Windows systems specifically you can also use the DDE service for > inter-application communications, it's a cheap and nasty solution, not my > favourite, but sometimes cheap and nasty is what is needed. Sockets work > cross-platform mostly and does not require much of an app

[sqlite] Trigger Logic!!!

I want to create a trigger on INSERT & in trigger logic I want to notify other running executable in system. Can I do this using trigger operation? Example: Create table (); CREATE TABLE test ( ID INT PRIMARY KEY NOT NULL, NAME TEXT NOT NULL, ); CREATE TRIGGER Event_test1 AFTER INSERT

[sqlite] Integer data type

Definition of integer data type will talk for signed integer. What about unsigned integer ?Are they also be part of same data type. *INTEGER*. The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value. http://www.sqlite.org/datatype3.html Bye

Re: [sqlite] SQLite3 : Corrupt/IO Error

wrote: > On Wed, Jul 17, 2013 at 12:55 PM, techi eth <techi...@gmail.com> wrote: > > 2) How do we make database safe from these error Or What is > Possibility to > > access database after error. > After error, as Stephan said you are out of luck. > > You shou

[sqlite] SQLite3 : Corrupt/IO Error

Hi, I have question on SQLITE_CORRUPT, SQLITE_IOERR occur during database access. Question 1) How to get generated this kind of error for testing. 2) How do we make database safe from these error Or What is Possibility to access database after error. Cheers- Techi

Re: [sqlite] Array Accessing in SQLite3

; array of records. > > Your example creates a table with two fields named 'test' and 'name' and > with declared datatypes of '10' and '50' respectively. > > -----Ursprüngliche Nachricht- > Von: techi eth [mailto:techi...@gmail.com] > Gesendet: Freitag, 12. Juli 2013

[sqlite] Array Accessing in SQLite3

I have query regarding accessing single & multidimensional array in SQLite3. Example: I have created table with (test [10] INTEGER, name [50] TEXT). How do I pass a value to insert each element of array? How do I read back? (I am using callback function for read back) Please cover answer by

Re: [sqlite] SQLite3 extended API usage

Yes, sqlite3_get_table() function works!!! Thanks. Better to update documentation accordingly. Cheers- eth On Mon, Jul 8, 2013 at 4:56 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 8 Jul 2013, at 9:21am, techi eth <techi...@gmail.com> wrote: > > > We a

Re: [sqlite] SQLite3 extended API usage

We arrive at same place were we start.I am using Sqlite3 version 3.7.9 & by refrence from below link i can use to get tabel function but i am getting undefined refrence error. http://www.sqlite.org/c3ref/free_table.html Is API still available with 3.7.9 version ? Or i want to use than what is the

Re: [sqlite] SQLite3 extended API usage

Thanks. I am using SQLite3 version : 3.7.9. Do i need to configure with some option to get linkage problem get resolved. On Sat, Jul 6, 2013 at 1:34 PM, Luuk <luu...@gmail.com> wrote: > On 06-07-2013 09:50, techi eth wrote: > >> Hi,When i try to use extended API like sql

[sqlite] SQLite3 extended API usage

Hi,When i try to use extended API like sqlite_get_table(), i am getting undefined reference to function. How do i get it resolve ? I am following below link for API reference. http://www.sqlite.org/c_interface.html Bye - ___ sqlite-users mailing list

[sqlite] Sqlite3 Affinity

Few Query : 1) Is their any function or Method to get Affinity type associated with colum. 2) I understand Integer,Text & Float could satisfy all data type requirement.In that case where i can use blob Or Numeric type. Cheers - Techi ___ sqlite-users