Re: [sqlite] unique with icu

Thanks a million Simon :-) On Sun, Oct 26, 2014 at 8:11 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 26 Oct 2014, at 6:00am, dd <durga.d...@gmail.com> wrote: > > > Application using sqlite database without icu extension. I am planning to > > add icu exte

Re: [sqlite] unique with icu

<jayare...@gmail.com> wrote: > On Sat, Oct 25, 2014 at 3:44 PM, Richard Hipp <d...@sqlite.org> wrote: > > > On Sat, Oct 25, 2014 at 7:09 AM, dd <durga.d...@gmail.com> wrote: > > > > > > > Hi, > > > > > > icu enabled for sqlite. I

Re: [sqlite] unique with icu

any inputs. On Sat, Oct 25, 2014 at 3:09 PM, dd <durga.d...@gmail.com> wrote: > Hi, > > icu enabled for sqlite. I didn't do any custom collations/like operator. > > CREATE TABLE test(id integer primary key autoincrement, t text collate > nocase, unique(t)); > > Ca

[sqlite] unique with icu

Hi, icu enabled for sqlite. I didn't do any custom collations/like operator. CREATE TABLE test(id integer primary key autoincrement, t text collate nocase, unique(t)); Case 1: When I try to insert 'd' and 'D', throwing constraint violation. (SUCCESS) Case 2: When I try to insert 'ö' and

[sqlite] How to enable icu for sqlite shell

Hi, I need to verify unicode stuff with shell. Is it possible? Tried with .load icu, thrown "icu.so cannot open...". Where can I find icu.so on sqlite.org? Thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] unicode case insensitive

typo: *I am summarizing options to support unicode* case-insensitive*: On Sat, Oct 25, 2014 at 10:34 AM, dd <durga.d...@gmail.com> wrote: > I am summarizing options to support unicode case-sensitive: > > 1. Richard Hipp: icu ext > 2. Aleksey Tulinov: https://bitbucket.org

Re: [sqlite] unicode case insensitive

option is suitable for my requirement. On Fri, Oct 24, 2014 at 11:51 PM, James K. Lowden <jklow...@schemamania.org> wrote: > On Fri, 24 Oct 2014 21:44:50 +0400 > dd <durga.d...@gmail.com> wrote: > > > >>Convert everything to upper (or lower) case brute forc

Re: [sqlite] how to store latin strings with no casae

Thank you. On Fri, Oct 24, 2014 at 11:24 PM, Constantine Yannakopoulos < alfasud...@gmail.com> wrote: > On Fri, Oct 24, 2014 at 9:40 AM, dd <durga.d...@gmail.com> wrote: > > > > > >>The SQLite source code includes an "ICU" extension that does thes

Re: [sqlite] unicode case insensitive

brute force. Perhaps tedious to set up, > but straightforward. > > Gerry > > > > On 10/24/2014 9:54 AM, dd wrote: > >> Hi, >> >> ö and Ö same character but case different. I dont want to allow to insert >> two entries for same data with different case. It works

[sqlite] unicode case insensitive

.t sqlite> .headers on sqlite> select * from test; id|t 1|a sqlite> insert into test(t) values('ö'); sqlite> insert into test(t) values('Ö');//issue: allowed to insert. Expects constraint failed err. But, not. sqlite> select * from test; id|t

Re: [sqlite] how to store latin strings with no casae

wrote: > On Thu, Oct 23, 2014 at 2:47 PM, dd <durga.d...@gmail.com> wrote: > > > Hi, > > > > database schema defined with collate nocase. It supports only for ascii > > (upper and lower). If I want to support db for other characters with > > nocase, wh

[sqlite] how to store latin strings with no casae

Hi, database schema defined with collate nocase. It supports only for ascii (upper and lower). If I want to support db for other characters with nocase, what steps I need to consider during schema design. for ex: *À Á Â Ã Ä Å Æ = * * à á â ã ä å æ * Thanks.

Re: [sqlite] Will collate binary supports like query

Thank you :-) On Tue, Sep 30, 2014 at 3:44 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 30 Sep 2014, at 12:32pm, dd <durga.d...@gmail.com> wrote: > > > My db already there in production. I have to do it programmatically. > > > > Can it be done

Re: [sqlite] Will collate binary supports like query

My db already there in production. I have to do it programmatically. Can it be done with any sqlite apis/pragmas. On Tue, Sep 30, 2014 at 3:19 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 30 Sep 2014, at 12:07pm, dd <durga.d...@gmail.com> wrote: > > >

Re: [sqlite] Will collate binary supports like query

? Thanks. On Tue, Sep 30, 2014 at 2:09 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 30 Sep 2014, at 7:03am, dd <durga.d...@gmail.com> wrote: > > > Needs to support case-sensitive for case-insensitive sqlite > > database field . To find exact case, COLLATE

Re: [sqlite] Will collate binary supports like query

@RSmith, yes. nice. Is it possible to change "collate nocase" to "collate binary" in schema for already existing db? On Tue, Sep 30, 2014 at 1:44 PM, RSmith <rsm...@rsweb.co.za> wrote: > > On 2014/09/30 09:03, dd wrote: > >> I just got below pragma:

Re: [sqlite] Will collate binary supports like query

I just got below pragma: pragma case_sensitive_like = true On Tue, Sep 30, 2014 at 10:03 AM, dd <durga.d...@gmail.com> wrote: > Hi, > > Needs to support case-sensitive for case-insensitive sqlite > database field . To find exact case, COLLATE BINARY, works very we

[sqlite] Will collate binary supports like query

Hi, Needs to support case-sensitive for case-insensitive sqlite database field . To find exact case, COLLATE BINARY, works very well. What is the work around for like queries. Needs to case-sensitive for like queries and lessthan, greaterthan operators. OR Is there anyway to change

[sqlite] How to control cpu usage while transaction in progress

queries? (for ex: delete * from emp where empname like "%a") Thanks, dd ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Understanding Sqlite

? If already there, please let me know. OR What is/are the best practice(s) to become master in sqlite in short period of time for new developers (i mean, new to sqlite not for programming)? Regards, dd ___ sqlite-users mailing list

Re: [sqlite] detach failed with error code 1

, Apr 20, 2014 at 9:16 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 20 Apr 2014, at 12:58pm, dd <durga.d...@gmail.com> wrote: > > > Given different database name for in-memory database for every > > iteration(looped for 1000 times). Still, it's throwing

Re: [sqlite] detach failed with error code 1

t;d...@sqlite.org> wrote: > On Thu, Apr 17, 2014 at 9:08 AM, dd <durga.d...@gmail.com> wrote: > > > Dear Richard, > > > > This is great api. > > > > output: > > > > (1) statement aborts at 5: [DETACH my_in_memory_db;] database > &g

Re: [sqlite] detach failed with error code 1

' AS my_in_memory_db;] database my_in_memory_db is already in use there is a detach for every attach. What could be the solution for this? Thanks, dd On Thu, Apr 17, 2014 at 2:58 PM, Richard Hipp <d...@sqlite.org> wrote: > Please turn on error logging (http://www.sqlite.org/er

[sqlite] detach failed with error code 1

for 100 times for empty database (/full/path). It's throwing sqlite error 1 at some random iteration. Is it correct way to implement attach and detach dbs? Thanks, dd. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] Improving Bulk Insert Speed (C/C++)

Did you see any improvement if application runs with high priority(nice)? (CPU and I/O) On Thu, Apr 3, 2014 at 12:56 AM, Kevin Xu wrote: > The app seems to use between 60-80% CPU while it is running (from Activity > Monitor) while disk use (using sudo iotop -P on OSX) seem

Re: [sqlite] Noticed crash on windows

Thank you all for your inputs. Let me check. On Wed, Mar 26, 2014 at 2:05 PM, Oliver Schneider wrote: > On 2014-03-25 18:52, Larry Brasfield wrote: >> Going in, it is best to not read too much into your code running >> "pretty well" on a Unix platform. Have you

[sqlite] Noticed crash on windows

: ntdll!RtlEnterCriticalSection+0x12 !winMutexEnter+0x13 !sqlite3_mutex_enter+0x19 !sqlite3_step+0x5e Is it known issue with 3.7.11 on Windows. Any idea? Thanks, dd ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] integrity check

Applied encryption on top of sqlite. Now, I suspect on encryption. Thanks for prompt response. On Thu, Jan 9, 2014 at 5:38 PM, Richard Hipp <d...@sqlite.org> wrote: > On Thu, Jan 9, 2014 at 8:29 AM, dd <durga.d...@gmail.com> wrote: > >> Hi all, >> >> Executed

[sqlite] integrity check

Hi all, Executed integrity check for database before application starts. Sometimes, it takes 1 minute. Other times, it finishes within 2 seconds. How integrity check works? can somebody explain why it takes less time. Thanks, dd ___ sqlite-users

Re: [sqlite] executing queries on normalized database

Got it. Can I conclude this way: Foreign keys works pretty well when application deals with parent keys only. But, application may need to execute more queries when dealing with child key/tables. Is it? Thanks, dd On Mon, Nov 11, 2013 at 5:35 PM, Simon Slavin <slav...@bigfraud.org>

Re: [sqlite] executing queries on normalized database

For first track to four tracks, it should not delete artist information from artist table. For fifth track, it should delete track information along with artist information. Is it possible to do with single query? On Mon, Nov 11, 2013 at 3:08 PM, dd <durga.d...@gmail.com> wrote: > Hi

Re: [sqlite] executing queries on normalized database

ON UPDATE CASCADE ON DELETE CASCADE); How do I insert trackname as "That's Amore" and artistname as "Dean Martin" with single query in artist and track tables? dd On Sun, Nov 10, 2013 at 6:45 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 10 Nov 2013, at

[sqlite] executing queries on normalized database

Hi, I have two tables in my database. After applying normalization, there are twelve tables with foreign key support. For insert/delete operations, it has to execute twelve queries instead of two. Is it recommended way? In delete case, do always need to check in parent table whether

Re: [sqlite] Need suggestion for database scheama

/album. Thanks for suggestions. dd On Fri, Nov 8, 2013 at 7:47 AM, James K. Lowden <jklow...@schemamania.org> wrote: > On Thu, 7 Nov 2013 14:50:44 +0400 > dd <durga.d...@gmail.com> wrote: > >> I am working on sqlite database schema for Music/Track files. I am >&g

[sqlite] tools list from sqlite.org

Hi, I used to include sqlite3.h/c files (from amalgamation) in application. I would like to know about tools from sqlite.org. What are all the tools available from sqlite.org? Where can I find the list of tools/utilities? any document? Thanks. ___

Re: [sqlite] Need suggestion for database scheama

It has to work with multiple devices in future. This is valid point for me. Thanks. On Thu, Nov 7, 2013 at 3:42 PM, Stephan Beal <sgb...@googlemail.com> wrote: > On Thu, Nov 7, 2013 at 12:15 PM, dd <durga.d...@gmail.com> wrote: > >> Thanks for pointing multimedia id, Step

Re: [sqlite] Need suggestion for database scheama

Thanks for pointing multimedia id, Stephan Beal. I missed it. I will ad this to my schema. On Thu, Nov 7, 2013 at 3:07 PM, Stephan Beal <sgb...@googlemail.com> wrote: > On Thu, Nov 7, 2013 at 11:50 AM, dd <durga.d...@gmail.com> wrote: > >> CREATE TABLE if not exists

[sqlite] Need suggestion for database scheama

in database? Any suggestions/improvements are welcome. Thanks in advance. dd ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] int stored as a string

Tandetnik <i...@tandetnik.org> wrote: > On 10/24/2013 9:46 AM, dd wrote: >> >> Sorry Igor. >> >> For ex, Employee has below columns: >> >> column details: >> 1. seq_id as integer prmary key, >> 2. emp_id as STRING >> 3. emp_mngr_id as ST

Re: [sqlite] int stored as a string

like to know about how sqlite maintains emp_id column. It always contains integers in string format. On Thu, Oct 24, 2013 at 4:49 PM, Igor Tandetnik <i...@tandetnik.org> wrote: > On 10/24/2013 8:39 AM, dd wrote: >> >>One of the column stores 'long long int'

[sqlite] int stored as a string

Hi, One of the column stores 'long long int' as string in database in production. Internally, sqlite maintains it as a integer or text? If Text, is there any performance overhead if I write a query based on this column? Can I get better performance If I write a query based on integer

[sqlite] Any tool to create erd from sqlite database?

I am looking for tool which generates er diagrams from existing database. Any suggetions? Thanks in advance. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] to encrypt sqlite db

Thank you for your quick response. I am looking for freeware. If freeware not available, I have to implement encryption support for sqlite on winrt. What is the procedure to implement encryption support on winrt? Thanks, dd On Sat, Aug 31, 2013 at 6:34 PM, Stephan Beal <sgb...@googlemail.

[sqlite] to encrypt sqlite db

Hi All, I have to encrypt sqlite database on winrt. What are all the necessary steps to do to encrypt sqlite database? Thanks in advance. Regards, dd ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] database design question

I got it. Thank you RSmith and Simon Slavin. On Wed, Jun 12, 2013 at 2:54 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 12 Jun 2013, at 11:14am, dd <durga.d...@gmail.com> wrote: > > > Yes Simon. I am looking for it. ON DELETE RESTRICT. > > > > I

Re: [sqlite] database design question

? On Wed, Jun 12, 2013 at 2:01 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 12 Jun 2013, at 9:49am, dd <durga.d...@gmail.com> wrote: > > >>> Book titles are not unique. > > I agree. 2. Books : columns(BookId_primarykey, > > Book_id_in_stri

Re: [sqlite] database design question

PM, Clemens Ladisch <clem...@ladisch.de> wrote: > dd wrote: > > my app need to delete author record from author table when author > > doesn't have any books. How to handle this? (I can verify in author > > table, whether this author belongs to any other book when book

[sqlite] database design question

Hi All, I am working on sample database application. I want to store book names and authors. Tables: 1. Authors: columns(AuthorId_primarykey, Name, SSN) 2. Books : columns(BookId_primarykey, Title)//Title is unique 3. Author_Books: columns(AuthorId_primarykey, BookId_primarykey) Here,

Re: [sqlite] hide sqlite database

I have backup of existing database. I just want to hide this backup database. On Thu, Mar 7, 2013 at 5:49 PM, Clemens Ladisch <clem...@ladisch.de> wrote: > dd wrote: > > I want to hide sqlite database file. > > If you hide it, SQLite will not be able to open it. > It

[sqlite] hide sqlite database

Hi all, Is there any flag to create sqlite database in hidden mode? (chmod, setfileattributes are os specific). I am looking for os independent. It runs on 3 major desktop oss. Thanks, dd. ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] Announcement of Copy - A cross platform syncing app, that uses SQLite as its backend

>>The integrity check just takes too long so we don't. pragma quick_check; doesn't take much tme. http://www.sqlite.org/pragma.html#pragma_quick_check On Sun, Mar 3, 2013 at 8:00 AM, Jason Dictos wrote: > >> . > > > > Thanks for the details. What programming

Re: [sqlite] like query

Igor/Clemen Ladisch, >>SELECT * FROM emp WHERE column_test BETWEEN "somedata/" AND "somedata/z" I want to replace z with 10 character. But, it's failed. what is the correct decimal value for that? On Tue, Feb 26, 2013 at 6:18 PM, dd <durga.d...@gmail.com>

Re: [sqlite] like query

, Clemens Ladisch wrote: > >> Igor Tandetnik wrote:> On 2/26/2013 2:39 AM, dd wrote: >> >>> SELECT * FROM emp WHERE column_test BETWEEN "somedata/" AND >>>> "somedata/zzz" >>>> >>>> This database has unicode strings(

Re: [sqlite] like query

t;slav...@bigfraud.org> wrote: > > On 25 Feb 2013, at 2:46pm, dd <durga.d...@gmail.com> wrote: > > > Table has string data type column. format of strings: > > somedata1/somedata2/somedata3 > > > > I have written query to search : select * from emp where c

Re: [sqlite] like query

Thanks Richard. On Mon, Feb 25, 2013 at 6:54 PM, Richard Hipp <d...@sqlite.org> wrote: > On Mon, Feb 25, 2013 at 9:46 AM, dd <durga.d...@gmail.com> wrote: > > > Hi, > > > > Table has string data type column. format of strings: > > somedata1/somedata

[sqlite] like query

Thanks in advance. Best Regards, dd. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] table backup

I am using SQLite version 3.7.14.1. On Wed, Dec 12, 2012 at 2:56 PM, dd <durga.d...@gmail.com> wrote: > Hi Michael > > I am using journal mode truncate. Explicitly, I am not running any pragma > for synchronous. (i think, it's default value is 2 - Full). > > Regards,

Re: [sqlite] table backup

igger the error > locally much more quickly with stack protection on then in a random system. > > > > > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of dd > Sent: Tuesday, December 11, 2012 1

Re: [sqlite] table backup

age 72 is never used Page 73 is never used Page 74 is never used Page 75 is never used Page 76 is never used Page 77 is never used Any inputs? On Tue, Dec 11, 2012 at 2:16 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 11 Dec 2012, at 7:00am, dd <durga.d...@gmail.com>

Re: [sqlite] table backup

-- > Hash: SHA1 > > On 09/12/12 21:44, dd wrote: > > Sometimes, sqlite databse corrupts. > > That is the problem you need to fix. If you have a system that is > unreliable then it will also corrupt your backups. > > http://www.sqlite.org/lockingv3.html#how_to_corrupt &g

Re: [sqlite] table backup

Sometimes, sqlite databse corrupts. So, I want to take online backup of specific table. Not entire database. Any best solution? On Sun, Dec 9, 2012 at 11:29 PM, Roger Binns <rog...@rogerbinns.com> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 09/12/12 10:3

Re: [sqlite] table backup

i mean, for every write operation in a table. On Sun, Dec 9, 2012 at 11:55 PM, dd <durga.d...@gmail.com> wrote: > Hi All, > > What is the best way to do online backup for a particular table for > every write operation in a sqlite db. Not entire database. >

[sqlite] table backup

Hi All, What is the best way to do online backup for a particular table for every write operation in a sqlite db. Not entire database. Best Regards, d ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] disk image malformed

I do Integrity check every often. On Sun, Dec 9, 2012 at 5:07 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 9 Dec 2012, at 12:44pm, dd <durga.d...@gmail.com> wrote: > > > Can I read the database when sqlite throws disk io or image malformed or > > ot

Re: [sqlite] disk image malformed

Can I read the database when sqlite throws disk io or image malformed or other critical errors first time. I cannot simulate these issues on my machine. So, I need your suggestion. On Sun, Dec 9, 2012 at 4:40 PM, dd <durga.d...@gmail.com> wrote: > Thank you Simon Slavin. > >

Re: [sqlite] disk image malformed

Thank you Simon Slavin. On Sun, Dec 9, 2012 at 4:27 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 9 Dec 2012, at 12:10pm, dd <durga.d...@gmail.com> wrote: > > > I have code in C++. Right now, I got this issue on Mac. > > Oh. Then you don't have to wo

Re: [sqlite] disk image malformed

I have code in C++. Right now, I got this issue on Mac. >>you still have faulty hardware or software faulty software means? (OS or sqlite version) On Sun, Dec 9, 2012 at 3:37 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 9 Dec 2012, at 7:34am, dd <durga.

Re: [sqlite] disk image malformed

integrity? I am using this database for "schengen countries" customers. Can sqlite handle these characters(special)? On Fri, Dec 7, 2012 at 5:51 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 7 Dec 2012, at 1:36pm, dd <durga.d...@gmail.com> wrote: > > &g

Re: [sqlite] just a test

Yes. Igor Tandetnik mails marked as a spam nowadays. I marked it as a NOT SPAM. On Sun, Dec 9, 2012 at 9:33 AM, Gabor Grothendieck wrote: > I am still having problems with Igor's gmail messages being marked as > spam in gmail but after the upteenth time declaring them

Re: [sqlite] disk image malformed

sizes? On Fri, Dec 7, 2012 at 2:06 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 6 Dec 2012, at 7:57pm, dd <durga.d...@gmail.com> wrote: > > > It's checking with OK, BUSY, 101 and some other errors. But not disk io, > > image malformed errors. How t

Re: [sqlite] disk image malformed

Databases integrity fine when application starts. These critical errors are introduced in run time. I cannot take backup of these databases also. space(memory) problem. On Fri, Dec 7, 2012 at 1:27 AM, dd <durga.d...@gmail.com> wrote: > It's checking with OK, BUSY, 101 and some oth

Re: [sqlite] disk image malformed

lav...@bigfraud.org> wrote: > > On 6 Dec 2012, at 7:47pm, dd <durga.d...@gmail.com> wrote: > > > No. I replaced with fresh database. I want to prevent these errors in our > > customers place for future purpose. > > Run the integrity check every so often and see if

Re: [sqlite] disk image malformed

No. I replaced with fresh database. I want to prevent these errors in our customers place for future purpose. On Fri, Dec 7, 2012 at 1:09 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 6 Dec 2012, at 7:30pm, dd <durga.d...@gmail.com> wrote: > > > My multi

Re: [sqlite] disk image malformed

for some records only. There was no other errors before disk io error. I suspect, after disk io error only these errors are introduced. Any ideas? On Fri, Dec 7, 2012 at 12:39 AM, dd <durga.d...@gmail.com> wrote: > No Robert. It's on same machine -- multiple threads within process, > T

Re: [sqlite] disk image malformed

No Robert. It's on same machine -- multiple threads within process, TRUNCATE mode. On Fri, Dec 7, 2012 at 12:38 AM, Robert Myers wrote: > One thing I haven't seen anyone ask yet - are you putting this on a > network drive? > On 12/6/2012 10:52 AM, Durga D wrote: > > Hi, >