Re: [sqlite] New word to replace "serverless"

2020-01-28 Thread Acer Yang
On Tue, Jan 28, 2020, 16:13 Cory Nelson wrote: > in-situ > > I think this distinguishes sqlite as being different from an "in-proc yet > separate server". > > On Mon, Jan 27, 2020 at 2:19 PM Richard Hipp wrote: > > > For many years I have described SQLite as being "serverless", as a way > > to

[sqlite] Prebuilt Windows x86 binary missing symbols per sqlite3.def

2017-06-03 Thread Acer Yang
Sqlite version is 3190220. x86 and x64 prebuilt Windows binaries are downloaded from https://www.sqlite.org/download.html I compared sqlite3.def files with sort and diff tools. Some missing symbols as of x86 def file are listed below. sqlite3_data_directory sqlite3_fts5_may_be_corrupt

[sqlite] SQLite custom function for regular expression using c/c++

2016-05-05 Thread Acer Yang
Hi Bhagwat, I try to accomplish that with sqlite3cpp ( https://github.com/yangacer/sqlite3cpp), a light wrapper of sqlite3 for C++. Hope it help :-) // Require sqlite3cpp to be installed from source. // Compile with: clang++-3.6 -g sqlite_re.cpp -lsqlite3cpp -lsqlite3 -std=c++11 //

[sqlite] sqlite3cpp, Yet Another C++ Wrapper of SQLite

2016-04-20 Thread Acer Yang
Dear SQLite users, If you are interested in using SQLite database in modern C++ way sqlite3cpp( https://github.com/yangacer/sqlite3cpp ) hope to be your favorite choice. The sqlite3cpp provides following features: 1. Query with range for-loop and typed parameter binding 2. Create SQL scalar

[sqlite] question for auto increament

2014-04-22 Thread Yang Hong
Hello, all: I am using VS2013 + sqlite.net for 4.5.1 with 32 bit. I have question for a primary key with auto increment. I can't figure out how to do it in C#. when I use sqlite datasource designer in VS2013. It has option to add identity checking, however, this feature doesn't work even I

[sqlite] SQL statements not captured by sqlite_trace or sqlite_profile?

2013-02-07 Thread 杨苏立 Yang Su Li
to be printed out by sqlite_trace or sqlite_profile. Does anyone have an idea about what went wrong here? Thanks a lot! Suli -- Suli Yang Department of Physics University of Wisconsin Madison 4257 Chamberlin Hall Madison WI 53703 ___ sqlite-users

[sqlite] Is there a way to measure query time in sqlite at runtime?

2012-11-17 Thread 杨苏立 Yang Su Li
, not just by replaying that statement in a shell afterwards? Could I just provide a plugin function for sqlite_profile? Thanks a lot Suli -- Suli Yang Department of Physics University of Wisconsin Madison 4257 Chamberlin Hall Madison WI 53703

Re: [sqlite] light weight write barriers

2012-11-15 Thread 杨苏立 Yang Su Li
On Thu, Nov 15, 2012 at 10:29 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 15 Nov 2012, at 4:14pm, 杨苏立 Yang Su Li <s...@cs.wisc.edu> wrote: > > > 1. fsync actually does two things at the same time: ordering writes (in a > > barrier-like manner),

Re: [sqlite] light weight write barriers

2012-11-15 Thread 杨苏立 Yang Su Li
On Thu, Nov 15, 2012 at 6:07 AM, David Lang wrote: > On Wed, 14 Nov 2012, Vladislav Bolkhovitin wrote: > > Nico Williams, on 11/13/2012 02:13 PM wrote: >> >>> declaring groups of internally-unordered writes where the groups are >>> ordered with respect to each other... is

Re: [sqlite] light weight write barriers

2012-11-10 Thread 杨苏立 Yang Su Li
On Fri, Oct 26, 2012 at 8:54 PM, Vladislav Bolkhovitin wrote: > > Theodore Ts'o, on 10/25/2012 01:14 AM wrote: > >> On Tue, Oct 23, 2012 at 03:53:11PM -0400, Vladislav Bolkhovitin wrote: >> >>> Yes, SCSI has full support for ordered/simple commands designed >>> exactly for that

Re: [sqlite] light weight write barriers

2012-10-11 Thread 杨苏立 Yang Su Li
I am not quite whether I should ask this question here, but in terms of light weight barrier/fsync, could anyone tell me why the device driver / OS provide the barrier interface other than some other abstractions anyway? I am sorry if this sounds like a stupid questions or it has been discussed

Re: [sqlite] Proper way to change temp directory

2011-11-20 Thread Yang Zhang
Cool beans, perhaps this should be added to the docs! On Sun, Nov 20, 2011 at 1:36 AM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 11/20/2011 04:00 PM, Yang Zhang wrote: >> >> Out of curiosity, what's the proper way to change the temp directory >> (say, to avoid &q

[sqlite] Proper way to change temp directory

2011-11-20 Thread Yang Zhang
e? Thanks. -- Yang Zhang http://yz.mit.edu/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Is this a bug? Can't tell from docs....

2011-11-18 Thread Yang Zhang
behavior.  Anyway, if this is intentional (as I'm guessing), I wouldn't have been able to tell from the docs - perhaps this would warrant special mention? Just thought I'd bring this to your attention. -- Yang Zhang http://yz.mit.edu/ ___ sqlite-users mailing

[sqlite] page cache vs OS cache

2010-11-19 Thread Yang
I wonder why we need page cache, since we already have OS file cache. in other words, if we simply set OS cache to be very large, would it have the same effect as page cache? thanks Yang ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] how can I use a larger cache ? "Application Defined Page Cache." ??

2010-11-19 Thread Yang
o use a very large cache, for example 1G Thanks Yang ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] creating a sqlite db on raw disk ?

2010-11-19 Thread Yang
our operating > system needs to be able to address your storage using file-system calls, not > storage-structure calls. ", that answers my question. On Fri, Nov 19, 2010 at 5:38 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 19 Nov 2010, at 7:04am, Yang wrote: >

[sqlite] creating a sqlite db on raw disk ?

2010-11-18 Thread Yang
".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table blah ( x int ); Error: disk I/O error note that I was able to create an e2fs on the same ramdisk Thanks Yang ___ sqlite-users mailing list

[sqlite] append to a column?

2010-11-18 Thread Yang
mit on how many columns each row could have, or any schema for columns, for that matter). But I can't find an off-the-shelf solution for sparse tables. (can't use Columnar DB, since my access pattern is still first based on rows) Thanks a lot Yang ___ sq

[sqlite] util.c compilation error in SQLite book

2009-07-26 Thread T.J. Yang
select.vcproj [tjy...@ibm capi]$ T.J. Yang _ Windows Live™ Hotmail®: Celebrate the moment with your favorite sports pics. Check it out. http://www.windowslive.com/Online/Hotmail/Campaign/QuickAdd?ocid=TXT_TAGLM_WL_QA_H

Re: [sqlite] Transaction isolation

2009-05-18 Thread Yang Zhang
Roger Binns wrote: > Yang Zhang wrote: >> Actually, this is only because Python 3 str is Python 2 unicode. Python >> 2 (which I'm currently using, and which I believe most of the world is >> using) str is a physical string of bytes, not a logical/decoded >> ch

Re: [sqlite] Transaction isolation

2009-05-18 Thread Yang Zhang
Igor Tandetnik wrote: > Yang Zhang <yanghates...@gmail.com> wrote: >> Pavel Ivanov wrote: >>> BTW, ACID that you mentioned has nothing to do with snapshot >>> isolation that you want to achieve. AFAIK only Oracle supports this >>> kind of statement isolat

Re: [sqlite] Transaction isolation

2009-05-18 Thread Yang Zhang
on. http://en.wikipedia.org/wiki/Snapshot_isolation And I certainly hope I did not convey that ACID implies snapshot isolation. -- Yang Zhang http://www.mit.edu/~y_z/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] Transaction isolation

2009-05-18 Thread Yang Zhang
Roger Binns wrote: > Yang Zhang wrote: >> I copied and pasted this code straight from my actual application, which >> uses blobs instead of integers, which I need to convert into strings >> (since Python interfaces with blobs using the `buffer` type, not `str`). > &g

Re: [sqlite] Transaction isolation

2009-05-18 Thread Yang Zhang
Yang Zhang wrote: > John Elrick wrote: >> Yang Zhang wrote: >>> Roger Binns wrote: >>> >>>> Yang Zhang wrote: >>>> >>>>> for i in (str(row[0]) for row in conn.cursor().execute('SELECT key >>>>> FROM shelf OR

Re: [sqlite] Transaction isolation

2009-05-18 Thread Yang Zhang
John Elrick wrote: > Yang Zhang wrote: >> Roger Binns wrote: >> >>> Yang Zhang wrote: >>> >>>> for i in (str(row[0]) for row in conn.cursor().execute('SELECT key FROM >>>> shelf ORDER BY ROWID')): >>>>

Re: [sqlite] Transaction isolation

2009-05-18 Thread Yang Zhang
Roger Binns wrote: > Yang Zhang wrote: >> for i in (str(row[0]) for row in conn.cursor().execute('SELECT key FROM >> shelf ORDER BY ROWID')): > > You are converting the key which is an integer into a string for no > apparent reason. I copied and pasted this code

[sqlite] Transaction isolation

2009-05-18 Thread Yang Zhang
(transaction-level) isolation. Thanks in advance for any answers! -- Yang Zhang http://www.mit.edu/~y_z/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Database open problem

2008-04-24 Thread Yang WenYuan
Hi, There is a very strange problem when I play with the sqlite-ce database. I put the database file and my application program together in the same folder. I call sqlite3_open(), the database can be opened properly. I call sqlite3_step(), it return SQLITE_ROW, that means it found the record

Re: [sqlite] WinCE Memory Problem

2008-04-09 Thread Yang WenYuan
ing it with the blob, why not with > the other fields? > > Mike > > > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag > von Yang WenYuan > Gesendet: Mittwoch, 9. April 2008 08:11 > An: General Discussion of

Re: [sqlite] WinCE Memory Problem

2008-04-09 Thread Yang WenYuan
call sqlite_step. > There's no need to call prepare, reset, finalize > inside the loop. If > chrPrintData doesn't change you can also move > bind_blob in front of the > loop. > > Mike > > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL

[sqlite] WinCE Memory Problem

2008-04-08 Thread Yang WenYuan
I use the Sqlite in the PDA which is WinCE OS. I need to add more than 200,000 records. I used sqlite3_prepare-> sqlite3_bind_blob->sqlite3_step->sqlite3_finalize to write each record in to Database. However, I found that after each record is inserted, the PDA memory became larger and larger. In