Hi Guys
I want to write an application in kotlin which uses SQLITE.
Is there already a good Kotlin package which provides SQLITE services (I know
that there is one for Android development, but I’m not
developing on top of Android)
Thanks
___
sqlite-use
tions you can find here?
>
> http://www.tutorialspoint.com/sqlite/sqlite_java.htm
>
> Tal Tabakman wrote Sun, 15 May 2016 09:41:39 -0700:
>
>> ... open an sqlite DB , compressed with CEROD, using java?s sqlite JDBC
>> connection ?
>
> Kind regards | Vriendelijk
Hi
is there a way to open an sqlite DB , compressed with CEROD, using java?s
sqlite JDBC connection ?
thanks
Tal
Hi Simon
per your question
he question becomes "Are you running as root ? If so, do you have a
good reason to be running as root ?"
No, I am not running as root. I am running in one of those secure
chamber at customer site.can it be related ?
On Sat, Aug 16, 2014 at 10:01 PM, Ta
Hi Guys,
we have an application that generates database in sqlite format,
at customer, we saw while profiling that the geteuid() call done in
sqlite3.c is showing up rather high in our profiling report, any idea why ?
what is this used for ?
thanks
Tal
_
ir in which I generate the DB has more space in*
On Wed, Jan 1, 2014 at 3:19 PM, Tal Tabakman wrote:
> Hi guys
> what is the reason for getting errors of type "SQLite disk I/O error"
> when doing operation like insert on sqlite DB.
> seems like that the work dir in which I gen
Hi guys
what is the reason for getting errors of type "SQLite disk I/O error" when
doing operation like insert on sqlite DB.
seems like that the work dir in which I generate the DB has more space in
it.
any advice will be appreciated,
___
sqlite-users m
Hi all,
a user of mine (run under Linux) encountered SQLITE_IOERR_FSTAT error while
trying to use our application.
what could be the reasons for such an error ?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/l
Hi,
this is a copy paste from the sqlite3 heade
/**
** This file is an amalgamation of many separate C source files from SQLite
** version 3.7.9. By combining all the individual C code files into this
** single large f
Hi
I have a crash when running a sqlite based app on solaris machines in 64
bits mode. the crash is actually a bus error when executing an sqlite_exec.
As recommended in this forum ,when running with gdb, I found that the crash
is in this line:
pIndex->azColl[i] = zColl;
This is the stack in
Hi Guys,
I get a bus error while running a sqlite based app on sparc machine (64
bits mode)
here is my stack trace ,
74ab2dec sqlite3_set_authorizer + 505c
74adb8cc sqlite3_vtab_config + 99c0
74adc184 sqlite3_vtab_config + a278
74add0f4 sqlite3_vtab_c
Hi,
my SQLite based app is writing an database(single thread, no concurrency,
on top of NFS , network is involved)
when opening the database for read we get the following error "file is
encrypted or is not a database" when executing a simple pragma:
"PRAGMA cache_size=1;"
I would like to note t
Hi
I am writing an application which creates a db in runtime (i.e. only INSERT
queries are performed, indexing only by primary key...)
I am running with the following pragmas:
executeString("PRAGMA temp_store=MEMORY");
executeString("PRAGMA journal_mode = MEMORY;");
executeString("PRAGMA page_size
Hi Richard,
*Just for getting better understanding*
you wrote:
"
Consider using the "unix-dotfile" VFS instead of the standard "unix" VFS.
(Add the string "unix-dotfile" as the 4th argument to sqlite3_open_v2().)
The unix-dotfile VFS will use dot-file locking instead of posix advisory
locking.
Hi Simon
thanks for your prompt reply
answers for the below
1. The database is written by a single process who has an EXCLUSIVE LOCK
2. Only AFTER all data is being written, costumer can access it (read mode)
3. potentially, it is a single writer followed by multiple readers kind of flow
4. F
Answering your question below,
yes , I believe that the costumer is using network
On 16 Aug 2012, at 6:52pm, Tal Tabakman http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>> wrote:
>* we get the following error:*Error: database disk image is malformed*>*
>Extended
Hi.
we are writing an application that in runtime produces a sqlite database.
we are using this set of pragmas:( and also the CEROD extension for
compression purposes).
"PRAGMA cache_size=1;"
"PRAGMA synchronous = 0;";
"PRAGMA temp_store=MEMORY";
"PRAGMA journal_mode = MEMORY;"
"PRAGMA count_ch
Hi,
I am writing an application that performs a lot of DB writes. I am using a
lot of recommended optimizations (like using transactions and more...)
I want to improve my recording time by reducing the amount of I/O. one way
to do so is by compressing the data before dumping it to DISK.
I am evalua
Hi guys,
I have an application that perform a lot of insert operations to a table
(each raw contains one ~20 character string and 10 integers)
I have read a bit about insert performance and use transactions for my
insert operations
my question is: is there a rule of thumb regarding the optimal numb
) when I produce
database with file size of 64 M ?
cheers
Tal
On 13 Dec 2011, at 8:10pm, Tal Tabakman wrote:
>* I discovered that the problem was not in the index creation but in the*>*
>database creation.*>* *>* it seems that during DB creation, a certain commit
>failed du
this disk consumption problem I got.
a question I have, given the fact that I have a 64 M DB with a promary
key on an integer column (which means that implicit index is being
done), what are my overall disk requirements, any rule of thumbs here
?
many thanks
Tal
On 12/10/2011 06:01 AM, Tal Tab
me directory as the database
file. For this to work, your application and user must have enough
privilages to create a new file in that directory.
Simon.
On Sat, Dec 10, 2011 at 1:01 AM, Tal Tabakman wrote:
> Hi,
>
> thanks for the reply.
>
> so, I don't have TMPDIR defi
Hi,
thanks for the reply.
so, I don't have TMPDIR defined in my env. what is the behaviour of
sqlite in such cases ? is there a default ?
cheers
Tal
On 12/09/2011 04:02 PM, Tal Tabakman wrote:
>* Hi Guys,*>* I have an SQLITE database of 1.5 million rows in a single
>table*>
Hi Guys,
I have an SQLITE database of 1.5 million rows in a single table
each raw looks like:
149|25|439198507|-1|0|1|44954|24|17|31|9|9|-1|-1|
now, from the sqlite command line interface I am creating an on a sincle
integer column
CREATE INDEX IND1 ON ENTRIES (snum)
the result I get is:
for some reason other than ENOSPC - in other words, if the write failed
for some reason other than the disk being full.
On Mon, Nov 21, 2011 at 11:05 AM, Tal Tabakman wrote:
> As a continuation to the bellow:
> I am using linux RH5
> "uname -a" on my machine gives:
> Linux
As a continuation to the bellow:
I am using linux RH5
"uname -a" on my machine gives:
Linux vl-talt 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64
x86_64 x86_64 GNU/Linux
On Sun, Nov 20, 2011 at 6:53 AM, Tal Tabakman http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-us
in a continuation to the below, it seems I get the following extended err
code
SQLITE_IOERR_WRITE
what are the reasons for that one ? is it a symptom of mem blow-up ?
cheers
Tal
>* Hi Guys,*>* in which cases can I get sqlite3 error "disk I/O error", is it
>only when*>* disk is full ?*>* any other
in a continuation to the below, it seems I get the following extended err
code
SQLITE_IOERR_WRITE
what are the reasons for that one ? is it a symptom of mem blow-up ?
cheers
Tal
>* Hi Guys,*>* in which cases can I get sqlite3 error "disk I/O error", is it
>only when*>* disk is full ?*>* any other
Hi Guys,
in which cases can I get sqlite3 error "disk I/O error", is it only when
disk is full ?
any other reasons for getting this one ?
cheers
Tal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqli
Thanks,
FYI, while it was a bad code styling on my behalf (I just did it for
showing en example) this was not my problem .
creating 2 short strings does not takes 20 seconds :)
also note, that when avoiding sqlite3_reset and creating new sqlite3_stmt
every time (and still creating those redunda
; On Tue, Nov 1, 2011 at 6:25 PM, Tal Tabakman
> wrote:
>
> > I have a slowness problem when running sqlite3 based application.
> > I have a small db (500 K on disk, only 1 rows) and I have a loop that
> > perform 1 selections according to
> > the primary key
I have a slowness problem when running sqlite3 based application.
I have a small db (500 K on disk, only 1 rows) and I have a loop that
perform 1 selections according to
the primary key of a certain table.
for some reason in takes 15-20 seconds to run the loop below.
by experimentation I fo
32 matches
Mail list logo
