[sqlite] Understanding Sqlite

Dear Author/All, There are many things needs to understand from sqlite apart from RDBMS concepts. For example, pragmas, database connection in different scenarios, IPC, virtual tables..etc. Do sqlite team has any plan to start online university for training and issuing certificates? If

Re: [sqlite] Understanding Sqlite

On 2014/06/04 08:35, dd wrote: Dear Author/All, There are many things needs to understand from sqlite apart from RDBMS concepts. For example, pragmas, database connection in different scenarios, IPC, virtual tables..etc. Do sqlite team has any plan to start online university for

[sqlite] shell core dumps on incomplete init file

Hi List,   I noticed that the sqlite shell core dumps when it is started with an init file that ends with an incomplete statement.   Example: Init file called "my_init.sql"  with the following contents:     -- note that the line below is NOT a valid sqlite comment line, and hence an

Re: [sqlite] Application with 'grid' form for entering table data wanted

Stephen Chrzanowski wrote: > By the sounds of it, the OP wants a spreadsheet app, that isn't a > spreadsheet app, acts like a database, but isn't quite a database, looks > simple to use, but provide editable information in a reasonable format. > You're almost right. Many

Re: [sqlite] shell core dumps on incomplete init file

On 06/04/2014 05:06 PM, Rob Golsteijn wrote: Hi List, I noticed that the sqlite shell core dumps when it is started with an init file that ends with an incomplete statement. Example: Init file called "my_init.sql" with the following contents: -- note that the line below is NOT

Re: [sqlite] shell core dumps on incomplete init file

>Dan Kennedy Wed, 04 Jun 2014 03:56:33 -0700 >On 06/04/2014 05:06 PM, Rob Golsteijn wrote: >> Hi List, >> I noticed that the sqlite shell core dumps when it is started with an init >> file that ends with an incomplete statement. >> >> Example: >> Init file called "my_init.sql"

Re: [sqlite] Threads and System.Data.SQLite

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Simon Slavin > Sent: Tuesday, June 03, 2014 8:07 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Threads and System.Data.SQLite > > > On 3 Jun 2014,

[sqlite] How can I test test_onefile.c?

How can I test test_one_file.c or test_demovfs? I want to use Some VFS shims in website like test_demovfs.c or test_onefile.c . But I don't know how can I use them. Is there some documentation about using them? or Is there any tips for me? ___

Re: [sqlite] How can I test test_onefile.c?

Hi, You can test it in different way. Some help can be found directly inside (Luke, use the source :-)) test_vfstrace.c or in test_demovfs.c. Anyway, High level testing: 1. Compile and link your own vfs implementation with shell.c sqlite3.c and also with test_vfstrace.c provided here:

Re: [sqlite] Application with 'grid' form for entering table data wanted

I don't know php, but this sounds like what I think you want: phpGrid | PHP Datagrid Made Easy. phpGrid | PHP Datagrid Made Easy. phpGrid is a simple, powerful and fully customizable PHP component for generating PHP AJAX datagrid for create, read, update, delete (CRUD) records. View on

Re: [sqlite] Understanding Sqlite

On Jun 4, 2014, at 8:35 AM, dd wrote: > 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)? Master? In short time? Nope. If you don’t want to be a total phony, you

Re: [sqlite] Understanding Sqlite

What worked for me was, before starting to code with SQLite,  I read the first two books on this page http://www.sqlite.org/books.html cover-to-cover, and spent a lot of time reading various articles on the SQLite website.  I also find it useful to read the SQLite code itself. Peter On

Re: [sqlite] Application with 'grid' form for entering table data wanted

I know about that https://github.com/j4mie/idiorm no cargobay On Wed, Jun 4, 2014 at 7:08 AM, David Bicking wrote: > > I don't know php, but this sounds like what I think you want: phpGrid | > PHP Datagrid Made Easy. > > > phpGrid | PHP Datagrid Made Easy. > phpGrid is a