dis-gps.com
> ** mail t...@qvgps.com<mailto:t...@qvgps.com>
> ** +264 (0)81 3329923Nam mobile
> ** +49 (0)175 7313081 D mobile
> ** +49 (0)6182 8492599 D office
> ***/
>
> _________
users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--- ---
Eduardo Morras
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
earth would you want to do that?
To write obfuscated code, perhaps for a prize or trojan, etc... development
> Eric
> --
> ms fnd in a lbry
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailm
ite with SQLITE_DIRECT_OVERFLOW_READ, with this, you blob
reads don't pollute sqlite cache,
- Compress the blobs with misc/compress extension while writing, less
you write, faster you read, see sqlar project (http://sqlite.org/sqlar).
HTH
--- ---
Eduardo Morras
Hello Dr. Hipps
There is a #define SQLITE_PREPARE_PERSISTENT x01 line in sqlite3 source code
for sqlite3_prepare_v3() flags.
Could you add SQLITE_PREPARE_NONE meaning no flag set?
Thanks
--- ---
Eduardo Morras
___
sqlite-users mailing list
ad speed is faster than XFS and UFS2.
You need to tune Sqlite to big databases and blob direct read (check the page
Dr. Hipps linked for compile options)
> ?(Sent this about 2 wks ago, but it never posted to the list and no
> moderator response either).?
--- ---
Eduardo Morras
is easy-medium.
Pass the connection string, user and password, and all queries to vtab
are redirected to the other dbms. I began with the csv file virtual
table and went from there.
Check SQL-MED standard and postgresql docs for syntax.
--- ---
Eduardo Morras
_
ting in this survey!
> --
> D. Richard Hipp
> d...@sqlite.org
--- ---
Eduardo Morras
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
what he?s doing.
>
> Simon.
P.S. I sent the mail from my current contractor mail, sorry for that.
--- ---
Eduardo Morras
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
insert AFTER INSERT ON table_name_to_watch_up
BEGIN
SELECT your_nigth_watcher();
END
HTH
>
> Thank you for your insights,
>
> Wout.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailing
ble 'fake' joined with the result itself,
LSOpenJobs.
SELECT max(edate) from LSOpenJobs AS I WHERE I.ProjID = O.ProjID AND
I.PSubClass = 'QuoteAppr'
You can try a WITH with the main query and subselect from it to get those two
values (max(edate) and min(edate))
HTH
--- ---
Eduardo Morras
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
problems.
Easy to backup, use fts on someones and can attach-deattach filesystems
db. One advice, increase sqlite internal cache, don't use its default
value.
>
> Jason
--- ---
Eduardo Morras
.
___
sqlite-users mailing list
sqlite-use
authier.
>
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--- ---
Eduardo Morras
___
sqlite
.sqlite.org/mmap.html it has disadvanteges too)
> Thanks,
>
> Gabriele
HTH
--- ---
Eduardo Morras
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
as you need.
For the network server code, repository has an example server
http://www.sqlite.org/src/artifact/a2615049954cbb9c and timeline at
http://www.sqlite.org/src/finfo?name=src/test_server.c
--- ---
Eduardo Morras
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
e could add database/schema
specific optimizations (Delete all rows in table tab where column value is
NULL, for example)
Thanks for the great work.
> --
> D. Richard Hipp
> d...@sqlite.org
--- ---
Eduardo Morras
___
sqlite-users mailing
is correct.
If writer safely forces a schema change, that's no real change to
schema, only an increase to schema_version pragma; the readers can
check that condition at sqlite3_step.
I don't know how to fire it, and changing directly pragma value is
discouraged.
>
? Increase cache with pragma in CLI.
Set it to 100-500MB for foo db, don't need to waste cache on destiny db
(where you insert the data). Change foo with the real origin db name.
pragma foo.cache_size=-50
Why don't use R*Tree virtual table? http://www.sqlite.org/rtree.html
--- ---
answers.
>
> Best regards
>
> Bob
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--- ---
Eduardo Morras
__
ched snapshot.
Sqlite maillist don't support attachment.
> regards,
>
> Maria Azevedo
> --
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-
export as csv and import them in sqlite.
> -
> Scott Doctor
> sc...@scottdoctor.com
> -----
--- ---
Eduardo Morras
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailin
use attached dbs and wal mode. If your use case is read heavy, use
wal.
I use (and develop) a diy filesystem over sqlite and has a similar scenario
with hundreds of GB of blobs on multiple databases. Those compile options,
tricks
and split metadata from data made a huge improvement.
> Any advice would be appreciated. Thanks, --DD
HTH
--- ---
Eduardo Morras
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
hnl3,kWhnl1,kWhnl2,
> kWhnl3,kVAh,kVAhl1,kVAhl2,kVAhl3,
> PFsys,PFl1,PFl2,PFl3,Wdmd,vardmd,VAdmd
> FROM hst_energy_d
> WHERE enflag = 0 ORDER BY recdate DESC, rectime DESC LIMIT 1;
You are querying with ORDER BY DESC, but indexes are created ASC,
convert them to DESC, ANALYZE and retry
u can predefine it (define before include sqlite3.h) with the value in bytes
you want, or set it to -1 to always store them in memory.
--- ---
Eduardo Morras
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
date a hidden column with the value can do the
trick at row level. It will make performance lower, undesired but expected
effect.
--- ---
Eduardo Morras
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite
an create a :memory: database with sqlite4. Doesn't it feed your
needs?
If you look at the Sqlite4 timeline, you'll see develop is a bit frozen. You
can try the lsm-vtab (http://www.sqlite.org/src/timeline?n=100&r=lsm-vtab) for
sqlite3, you need fossil-scm to download it and compile, but I don't know if it
works currently or not (last updated on Feb 2016)
HTH
--- ---
Eduardo Morras
indexes, select all data from tables and insert them in new db tables.
You don't write the indexes and should be faster. If you need the indexes, you
can create them later.
> Thanks
>
> Rob
--- ---
Eduardo Morras
-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--- ---
Eduardo Morras
__
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--- ---
Eduardo Morras
n SQL, you'll force the reverse engineer to learn this new
query language. You can automate the conversion from actuals SQL queries to
NewLang queries, even change the NewLang on each compile with different lemon
parser code. And yes, it's too complex and the time invested (I think) is ti
adata only when needed.
Of course, b) is unlikely, but a) is a real pita.
> Simon.
--- ---
Eduardo Morras
n every plate), create
a similar index to a) case, but rotating the letters on the string instead
reversing it.
You know your data structure and the queries, perhaps other data transforms may
create better indexs
> Selea s.r.l.
>
>
> Michele Pradella R&D
--- ---
Eduardo Morras
anguage you are programming, you can store the query result on
a table(Lua), dictionary(Python, Erlang and others) or create a specifc struct
for your query in C.
You can use the deprecated get_table and free_table to get a similar recordset
struct.
HTH
> Looping over a recordset twice is often useful.
>
> Sincerely
> Christian
--- ---
Eduardo Morras
etc... you should choose one or another.
> Any sugestion or comment are wellcome.
>
> --
> Adolfo J. Mill?n
--- ---
Eduardo Morras
s to Dr. Richard Hipps, Dan Kennedy and Joe Mistachkin for their
exceptional work, and other colisters for their time and help.
--- ---
Eduardo Morras
ger than 2GB, it's a 64bit integer. Try
to compile with -DSQLITE_MAX_MMAP_SIZE=21474836480 and use a copy or backup,
not the original database.
> Roger
--- ---
Eduardo Morras
_table(fts_virtual_table) VALUES('rebuild');" to reindex the FTS
virtual table.
And I say I wrote it too fast because a virtual table don't need to have an
internal index, depends on what is it for and its implementation.
> -Urspr?ngliche Nachricht-
> Vo
On Tue, 6 Oct 2015 15:39:08 +0100
Simon Slavin wrote:
> There are also things Virtual Tables can't do. For instance you
> cannot index a Virtual Table using SQL commands.
Does "SELECT reindex_virtual_table() FROM virtual_table" count as SQL command
only?
--- ---
Eduardo Morras
is opened, increasing each time
you open it and decreasing each time you close it.
>
> Michael
--- ---
Eduardo Morras
On Fri, 11 Sep 2015 17:12:50 +0300
Valentin Davydov wrote:
> On Thu, Sep 10, 2015 at 01:30:37PM +0200, Eduardo Morras wrote:
> >
> > Use gmake to compile.
>
> It didn't work either. Finally I've just installed some brand new
> linux on a nearby v
use sqlite3 as network db and it
is, besides cache_size and page_size, the most important pragma for improve
performance.
>ThanksMike
> ___ sqlite-users mailing
> list sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--- ---
Eduardo Morras
?has'.
>
>
> Thanks in advance
>
>
>
> Ing. H?ctor Fiandor
>
> hfiandor at ceniai.inf.cu
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--- ---
Eduardo Morras
es bundled with
> sqlite sources don't work.
Use gmake to compile. Note that there isn't a port, sqlite4 is in development
state and not a final product.
> Valentin Davydov.
--- ---
Eduardo Morras
On Wed, 9 Sep 2015 09:54:28 -0400
Igor Tandetnik wrote:
> On 9/9/2015 6:54 AM, Eduardo Morras wrote:
> > Yes, the comparison operators work correctly and the b-tree binary
> > search should give correct answers, the only tweak is in xCompare,
> > that returns 0 when lef
On Tue, 8 Sep 2015 15:42:28 -0400
Richard Hipp wrote:
> On 9/8/15, Eduardo Morras wrote:
> >
> >
> > Hello,
> >
> > I have a virtual table that implements query perceptual hashing data
> > [1]. Now I'm thinking about converting the virtual table
&
Hello,
I have a virtual table that implements query perceptual hashing data[1]. Now
I'm thinking about converting the virtual table implementation in a collation
on a normal sqlite3 table, but collation requieres that '=','<' and '>' be well
defined by obeying the rules cited on create_colla
s do, but it'll be a nice addition for debugging purpouses.
> Thank you for your assistance.
>
> --
> Gruesse,
> Jakub
>
--- ---
Eduardo Morras
o a process who runs sqlite on local, queues the queries, execute them in
order and return results to each user. It's a medium complex project and some
corner cases should be consider. I'll try postgres instead.
--- ---
Eduardo Morras
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--- ---
Eduardo Morras
onnection. I believe the case where
> SQLITE_BUSY is returned by sqlite_close() due to unfinalized prepared
> statements should be mentioned there.
Perhaps you forget to call sqlite3_finalize() on at least one query of your
code.
> Jeff
--- ---
Eduardo Morras
sqlite3.c:162240:17: fatal error: tcl.h: No such file
> or directory
> #include "tcl.h"
> ^
> compilation terminated.
>
> I have tcl.h here:
> /usr/local/include/tcl8.6/generic/tcl.h
> /usr/local/include/tcl8.6/tcl.h
Add the include path to /usr/loc
her threads that use temp
files will fail and may corrupt db file.
> - Howard
--- ---
Eduardo Morras
left over virtual tables from before and
> drop them.
>
> Any other ideas?
Modify the code of your virtual table or ask sqlite3 developers if it's one of
the virtual tables provided with sqlite3.
> - Andy
--- ---
Eduardo Morras
://unql.sqlite.org/index.html/wiki?name=UnQL
http://www.dataversity.net/unql-a-standardized-query-language-for-nosql-databases/
http://www.couchbase.com/press-releases/unql-query-language
>
> Sergej
--- ---
Eduardo Morras
ble in sqlite with data from a
Postgresql server.
--- ---
Eduardo Morras
mm and proper db maintenance should minimize the
vacuum space between tables.
HTH
--- ---
Eduardo Morras
e in some product I need the
formal grammar.
Learn by example means learn white rules (the dos), I need to know the black
rules too (the don'ts) to get full knowledge of the language.
> Regards
> David M Bennett FACS
>
> Andl - A New Database Language - andl.org
--- ---
Eduardo Morras
7;t modify the schema version. If you do
so, readers must call sqlite3_reset() and sqlite3_prepare() again.
--- ---
Eduardo Morras
, can you explain if virtual table index count for this limit?
> Eric
--- ---
Eduardo Morras
can't be called from other .c files. If you declare them as
static, you can't call them from any other .c files.
HTH
--- ---
Eduardo Morras
\n'. The chars between them
are the comment.
I thought you need it only for documentation purpouse and not automatic/dynamic
programming.
> Thanks,
--- ---
Eduardo Morras
rom sqlite_master where type='table' AND tbl_name='blob_table';
will return
CREATE TABLE blob_table (
ModelNo TEXT, -- e.g. S0-239
SerialNo TEXT, -- e.g. 101
VSWR BLOB -- double, e.g. x'feab12c'
)
(Note that ';' is deleted)
I check it in Firefox Sqlite3 Manager extension.
> Thanks,
> -Bill
--- ---
Eduardo Morras
d he cite some of the problems you may
encounter at "There are MANY things to be taken care of,.." paragraph.
--- ---
Eduardo Morras
e in multithread app, is sqlite own
code, don't need to reinvent the wheel.
Please, pay attention to my first two words, "I think", it shows my opinion
about the problem as is described, not a real solution to other problems.
> Simon.
--- ---
Eduardo Morras
7;t have the db while doing it at backup/restore db file
system cache has it. Try to do something like this:
%cat /path/to/db.file > /dev/null
> Thank you
>
> Jean-Marie
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--- ---
Eduardo Morras
>
> So, if there is such a driver I would be very interested in requesting
> it and evaluate it.
>
> Also it would be nice to know whether this driver is OK to use legally
> in the commercial app.
>
> Thank you for any info you can provide.
--- ---
Eduardo Morras
ds/ (Warning!! GPLv3 code)
[5] http://www.ranks.nl/stopwords/russian (Warning!! Unknow licence)
> Thank you.
HTH
--- ---
Eduardo Morras
overhead. SQLite itself will never use anything near
** this amount. The only way to reach the limit is with sqlite3_malloc() */
>
> Regards
> Dominique
--- ---
Eduardo Morras
rror.
> >
>
> I never saw a segfault in my case, though I never tried anything on
> any posix style system. It was strictly Windows.
Don't know if it's asked yet, but do you use a 64bit Windows or a 32bit version?
> --
> Scott Robison
--- ---
Eduardo Morras
te the tests you need for your use case.
--- ---
Eduardo Morras
nsitive information in
> them.
You can reference count the number of files it creates and deletes. If it
creates more files than it deletes, you have a problem. It doesn't involve big
changes in sqlite vfs code and even may be implemented in sqlite3 core code as
a debug feature.
>
> Simon.
--- ---
Eduardo Morras
gt; sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--- ---
Eduardo Morras
em is taken each
10-30 secs., you can go back in time and recover filesystem state from 2 days
ago (up to 6 months IIRC)
> I have read <https://www.sqlite.org/tempfiles.html>.
>
> Simon.
--- ---
Eduardo Morras
from 3.7.13 to 3.8.9)
>
> Thanks for your help,
>
> --
> Nicolas Boullis
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--- ---
Eduardo Morras
at in this case there is no winning for using a
temporal table intstead an IN, it should be faster when the temp table has more
columns used in the where clause or additional join restriction.
--- ---
Eduardo Morras
itting all advanced features (threading, fts, extensions,
foreign keys, etc...). You need to create a vfs too.
--- ---
Eduardo Morras
t; user actions needs to be "timely".
>
> I'll hold futher questions until after looking at the recommendations
> my by you kind people.
For zigbee devices I use contiki-os. I suggest you to use c only if your
devices are low power.
--- ---
Eduardo Morras
it.
There are others cms that can use sqlite as db, seredipity, Joomla, MediaWiki
you can play and test with.
>
> Olivier
--- ---
Eduardo Morras
FROM ordercallback
> WHERE cb_uuid=@CBUUID
> UNION ALL
> SELECT NULL -- at least one result
> LIMIT 1) -- at most one result
Shouldn't add an ORDER BY cb_seq_num to get the lower one?
...
WHERE cb_uuid=@CBUUID
ORDER BY cb_seq_num ASC
UNION ALL
...
>
>
> Regards,
> Clemens
--- ---
Eduardo Morras
On Tue, 3 Feb 2015 06:39:02 -0700 (MST)
Jan Slodicka wrote:
> Eduardo Morras-2 wrote
> > A ~8000MB db with app example data. More than 1000 query-corp
> > created as part of test driven development of the app. We have
> > precalculated the correct results in tables and its n
On Tue, 3 Feb 2015 02:43:00 -0700 (MST)
Jan Slodicka wrote:
> Eduardo Morras-2 wrote
> > I use a big test db to assure new versions of sqlite works
> > properly. With 3.7.15.2 it takes 43 minutes, with 3.8.8.2 on same
> > hardware 27 minutes, it's 16/0.43 = 37% less or
to assure new versions of sqlite works properly. With
3.7.15.2 it takes 43 minutes, with 3.8.8.2 on same hardware 27 minutes, it's
16/0.43 = 37% less or 27/0.43 = 63% improve.
--- ---
Eduardo Morras
___
sqlite-users mailing list
sqlite-users@sqlite
e Oracle but I just am holding onto sqlite3
> assuming it would help me solve our problem.
You can use PostgreSQL, using part of Oracle licence cost for better hardware
and a dinner for the team.
> Regards,
> Navin
>
> ___
> sqlite-use
4.4)
> made it larger but no faster.
>
>
> many thanks,
> adj
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--- ---
Eduardo Morras
___
th files
has the same corruption.
The mail list has attachment set to off, so they're deleted before remailed.
--- ---
Eduardo Morras
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
to
gzip or xz and use the compressed file for import again. Don't need full
compression to minimize the io, -6 for gzip and -3 for xz is enough.
>
> -j
--- ---
Eduardo Morras
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ld use a lot less pages, minimizing the I/O.
> Simon.
--- ---
Eduardo Morras
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ter? I would expect the
> unnecessary sort to be pure overhead.
If you insert in correct index order, the index update phase is faster because
it don't need rebalance the b-tree so often after each insert.
--- ---
Eduardo Morras
___
f.ex. batch writes sended by some threads to update the same row
multiple times, so only the last one was applied or apply them in one
transaction, which is faster than apply them one by one.
> ~Joe
--- ---
Eduardo Morras
___
sqlite-users mailing
e
> JOE>> fed by multiple File IO thread.
Yes and no, your app can be multithread, but if only one thread has the sqlite3
pointer, you can use single thread sqlite3. This way, you have multiple working
threads and one sqlite3 dedicated thread that recives the data to write and th
ad support.
b)Adjust the page size to fit in a hard disk cluster size (8KB IIRC) or the
multiply of it that allows integer number of rows fits in.
c)Disable autovacuum
> 2) Will ther be any write performance hit when the number of records
> in the DB increase?
>
> Thanks in adv
or tiny hardware, near
embedded, works.
A good file to start with, as I did, is in Sqlite repository, check
http://www.sqlite.org/src/artifact/a2615049954cbb9cfb4a62e18e2f0616e4dc38fe
a.k.a. src/test_server.c
But, as others aim and hit, you should use a
osure.c
HTH
>
> --
> Regards,
> Michael.j.Falconer.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--- ---
Eduardo Morras
___
sqli
On Wed, 27 Aug 2014 23:04:40 +0200
Petite Abeille wrote:
>
> On Aug 27, 2014, at 10:57 PM, Eduardo Morras
> wrote:
>
> > Sorry, don't understand why others will throw an exception in the
> > group by, perhaps I'm misunderstanding the group by, but that
SQLite as a precursor to a proper, more formalize,
> handling of analytic functions…. :)
--- ---
Eduardo Morras
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
or not, and run analyze or
make schema changes or whatever you want and update user_version.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--- ---
Eduardo Morra
> different field in the referenced enrolment record.
>
> Suggestions?
Check
http://www.sqlite.org/src/artifact/636024302cde41b2bf0c542f81c40c624cfb7012 for
parent-child relationship example, it's for in-table relation but the in-code
documentation is awesome, you can "steal" some idea
ying to use -DSQLITE_OMIT* with the amalgamation sqlite3.c or with
the full sqlite3 src? Most of -DSQLITE_OMIT* won't work if you use the
amalgamation.
--- ---
Eduardo Morras
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
tions, do you mean a call to sqlite3_openv2? Or cycle of
sqlite3_prepare_v2/step/finalize?
--- ---
Eduardo Morras
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
is really something I should
> do? I would prefer to open database only when it is needed, to avoid
> risk of file corruption on power loss. Is there any known issue with
> multiple open/close operations?
1020 simultaneus connections? Perhaps iOS exhausted del max. file descri
1 - 100 of 206 matches
Mail list logo