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
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 wrote:
> On Thu, Jan 9, 2014 at 8:29 AM, dd wrote:
>
>> Hi all,
>>
>> Executed integrity check for database before application
stack:
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/cg
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 run your code with
>> Valgrind (or
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 to suggest about
> 20
bove three queries in loop 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
H DATABASE '/full/path/info.db' 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 wrote:
> Please turn on error logging (http://www.
Hipp wrote:
> On Thu, Apr 17, 2014 at 9:08 AM, dd wrote:
>
> > Dear Richard,
> >
> > This is great api.
> >
> > output:
> >
> > (1) statement aborts at 5: [DETACH my_in_memory_db;] database
> > my_in_memory_db is locked
> >
>
&
, Apr 20, 2014 at 9:16 PM, Simon Slavin wrote:
>
> On 20 Apr 2014, at 12:58pm, dd wrote:
>
> > Given different database name for in-memory database for every
> > iteration(looped for 1000 times). Still, it's throwing Database Locked at
> > least once on Windows, no
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
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
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
I just got below pragma:
pragma case_sensitive_like = true
On Tue, Sep 30, 2014 at 10:03 AM, dd wrote:
> Hi,
>
> Needs to support case-sensitive for case-insensitive sqlite
> database field . To find exact case, COLLATE BINARY, works very well.
>
>
>
> What is
@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 wrote:
>
> On 2014/09/30 09:03, dd wrote:
>
>> I just got below pragma:
>> pragma case
?
Thanks.
On Tue, Sep 30, 2014 at 2:09 PM, Simon Slavin wrote:
>
> On 30 Sep 2014, at 7:03am, dd wrote:
>
> > Needs to support case-sensitive for case-insensitive sqlite
> > database field . To find exact case, COLLATE BINARY, works very well.
> >
> >
> &
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 wrote:
>
> On 30 Sep 2014, at 12:07pm, dd wrote:
>
> > Hi Simon,
> >
> >>> However, frequent use o
Thank you :-)
On Tue, Sep 30, 2014 at 3:44 PM, Simon Slavin wrote:
>
> On 30 Sep 2014, at 12:32pm, dd wrote:
>
> > My db already there in production. I have to do it programmatically.
> >
> > Can it be done with any sqlite apis/pragmas.
>
> Sure. But you do ne
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,
> >
> > Is it possible
e 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 wrote:
> No Robert. It's on same machine -- multiple threads within process,
> TRUNCATE mode.
>
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 wrote:
>
> On 6 Dec 2012, at 7:30pm, dd wrote:
>
> > My multithreaded application do all read/write operations. For each
gt;
> On 6 Dec 2012, at 7:47pm, dd 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 the problem occurs
> again. Make sure that your pr
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 wrote:
> It's checking with OK, BUSY, 101 and some other errors. But not disk io,
sizes?
On Fri, Dec 7, 2012 at 2:06 AM, Simon Slavin wrote:
>
> On 6 Dec 2012, at 7:57pm, dd wrote:
>
> > It's checking with OK, BUSY, 101 and some other errors. But not disk io,
> > image malformed errors. How to handle these errors in run time? these
> > databases
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 not to be
> spam google fin
other database 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 wrote:
>
> On 7 Dec 2012, at 1:36pm, dd wrote:
>
> > Thank you Simon.
> >
> > S
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 wrote:
>
> On 9 Dec 2012, at 7:34am, dd wrote:
>
> > I have 10 databases.
Thank you Simon Slavin.
On Sun, Dec 9, 2012 at 4:27 PM, Simon Slavin wrote:
>
> On 9 Dec 2012, at 12:10pm, dd wrote:
>
> > I have code in C++. Right now, I got this issue on Mac.
>
> Oh. Then you don't have to worry about Windows codepages. All your text
> is al
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 wrote:
> Thank you Simon Slavin.
>
>
> On Sun, Dec 9, 2012 at 4:
I do Integrity check every often.
On Sun, Dec 9, 2012 at 5:07 PM, Simon Slavin wrote:
>
> On 9 Dec 2012, at 12:44pm, dd wrote:
>
> > Can I read the database when sqlite throws disk io or image malformed or
> > other critical errors first time. I cannot simulate these iss
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
http://sqlite.org:8080/cgi-bin/mailman/listinf
i mean, for every write operation in a table.
On Sun, Dec 9, 2012 at 11:55 PM, dd 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.
>
>
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 wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 09/12/12 10:35, dd wrote:
> > i mea
> 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
> http://www.sqlite.
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 wrote:
>
> On 11 Dec 2012, at 7:00am, dd wrote:
>
> > I don't have any clue. Two
r 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:00 AM
I am using SQLite version 3.7.14.1.
On Wed, Dec 12, 2012 at 2:56 PM, dd 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,
> d
>
>
&
Thanks in advance.
Best Regards,
dd.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Thanks Richard.
On Mon, Feb 25, 2013 at 6:54 PM, Richard Hipp wrote:
> On Mon, Feb 25, 2013 at 9:46 AM, dd wrote:
>
> > Hi,
> >
> > Table has string data type column. format of strings:
> > somedata1/somedata2/somedata3
> >
> > I have written
wrote:
>
> On 25 Feb 2013, at 2:46pm, dd wrote:
>
> > Table has string data type column. format of strings:
> > somedata1/somedata2/somedata3
> >
> > I have written query to search : select * from emp where column_test
> like
> > "somedata/%";
&g
gt;> 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(chinese/japanese/...**et
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 wrote:
> 10 d
>>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 language do you use? (Dropbox
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
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 wrote:
> dd wrote:
> > I want to hide sqlite database file.
>
> If you hide it, SQLite will not be able to open it.
> It would be easier to ju
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,
thor 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
deletion. If no, delete from author table. I am not happy with this
solution )
On Wed, Jun 12, 2013 at 12:37 PM, Clemens Ladisch wrote:
> dd wrote:
> >
PM, Clemens Ladisch 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
> > deletion.
>
Wed, Jun 12, 2013 at 2:01 PM, Simon Slavin wrote:
>
> On 12 Jun 2013, at 9:49am, dd wrote:
>
> >>> Book titles are not unique.
> > I agree. 2. Books : columns(BookId_primarykey,
> > Book_id_in_string_format_like_guid)
>
> I’m not sure why you
I got it.
Thank you RSmith and Simon Slavin.
On Wed, Jun 12, 2013 at 2:54 PM, Simon Slavin wrote:
>
> On 12 Jun 2013, at 11:14am, dd wrote:
>
> > Yes Simon. I am looking for it. ON DELETE RESTRICT.
> >
> > I got the answer.
> >
> > Should I enab
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
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 wrote:
> On Sat,
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
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
c
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 wrote:
> On 10/24/2013 8:39 AM, dd wrote:
>>
>>One of the column stores 'long long int' as string in database in
Igor Tandetnik 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 STRING
>> 4. emp_
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
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 wrote:
> On Thu, Nov 7, 2013 at 11:50 AM, dd wrote:
>
>> CREATE TABLE if not exists AllFilesTbl (Id INTEGER PRIMARY KEY
>> AUTOINCREMENT,
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 wrote:
> On Thu, Nov 7, 2013 at 12:15 PM, dd wrote:
>
>> Thanks for pointing multimedia id, Stephan Beal. I missed it. I will
>> ad this to my
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.
___
#x27; and add plural for track/album.
Thanks for suggestions.
dd
On Fri, Nov 8, 2013 at 7:47 AM, James K. Lowden
wrote:
> On Thu, 7 Nov 2013 14:50:44 +0400
> dd wrote:
>
>> I am working on sqlite database schema for Music/Track files. I am
>> posting few tables schema her
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
chi
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 wrote:
>
> On 10 Nov 2013, at 10:54am, dd wrote
ack. 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 wrote:
> Hi,
>
> Thanks Si
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 wrote:
>
> On 11 Nov 2013,
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.
wrote:
> On Thu, Oct 23, 2014 at 2:47 PM, dd 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, what steps I need to consider du
QUE constraint failed: test.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 e
t 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 well with ascii
>>
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 wrote:
>
> >
> > >>The SQLite source code includes an "ICU" extension that does these
> > overloads.
> &g
oint which option is suitable for my requirement.
On Fri, Oct 24, 2014 at 11:51 PM, James K. Lowden
wrote:
> On Fri, 24 Oct 2014 21:44:50 +0400
> dd wrote:
>
> > >>Convert everything to upper (or lower) case brute force.
> >Sorry. I am not clear. C
typo:
*I am summarizing options to support unicode* case-insensitive*:
On Sat, Oct 25, 2014 at 10:34 AM, dd wrote:
> I am summarizing options to support unicode case-sensitive:
>
> 1. Richard Hipp: icu ext
> 2. Aleksey Tulinov: https://bitbucket.org/alekseyt/nunicode#markdown-
>
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
http://sqlite.org:8080/cgi-bi
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 'Ö'
any inputs.
On Sat, Oct 25, 2014 at 3:09 PM, dd 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));
>
> Case 1: When I try to
stice
wrote:
> On Sat, Oct 25, 2014 at 3:44 PM, Richard Hipp wrote:
>
> > On Sat, Oct 25, 2014 at 7:09 AM, dd wrote:
> >
>
>
> > > Hi,
> > >
> > > icu enabled for sqlite. I didn't do any custom collations/like
> > operator.
> &g
Thanks a million Simon :-)
On Sun, Oct 26, 2014 at 8:11 PM, Simon Slavin wrote:
>
> On 26 Oct 2014, at 6:00am, dd wrote:
>
> > Application using sqlite database without icu extension. I am planning to
> > add icu extension. for schema, add new column and index with lower.
76 matches
Mail list logo
