Re: [sqlite] Proposed incompatible changes to the SQLite VFS layer

2008-05-03 Thread D. Richard Hipp
On May 3, 2008, at 12:30 AM, Roger Binns wrote: > > I would like a #define of the current version number. http://www.sqlite.org/c3ref/c_version.html D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Recommended (Windows/Linux) SQLite utilities

2008-05-03 Thread Zbigniew Baniewski
On Wed, Apr 30, 2008 at 12:40:54AM -0400, [EMAIL PROTECTED] wrote: > Looking for recommendations for 3rd party SQLite utilities for browsing, > maintaining, importing/exporting and repairing SQLite database files. You can try "SQLite Studio" http://sqlitestudio.one.pl/ --

Re: [sqlite] SQLite & TCL: A "SELECT" from one-column table

2008-05-03 Thread Zbigniew Baniewski
On Sat, May 03, 2008 at 03:07:00PM -0400, D. Richard Hipp wrote: > > dbcomm eval {CREATE TABLE something( a_string VARCHAR(20) )} > > dbcomm eval {INSERT INTO something VALUES ('Version V8.5')} > > > > Now, if you want to retrieve the value: > > > > tclsh8.5 [~/tmp/tcltk]dbcomm eval "SELECT

[sqlite] Problems Using SQL Maestro's PHP Generator

2008-05-03 Thread Steve Roberts
I've been using SQLite on my windows box and wanted to move some things to the web. I found SQL Maestro's PHP Generator and it looked like it would be very useful. I downloaded and all seem to work as advertised for generating the php scripts. (In other words the utility recognized my database

Re: [sqlite] SQLite & TCL: A "SELECT" from one-column table

2008-05-03 Thread D. Richard Hipp
On May 3, 2008, at 1:52 PM, Zbigniew Baniewski wrote: > Take a look at following example: > > dbcomm eval {CREATE TABLE something( a_string VARCHAR(20) )} > dbcomm eval {INSERT INTO something VALUES ('Version V8.5')} > > Now, if you want to retrieve the value: > > tclsh8.5 [~/tmp/tcltk]dbcomm

Re: [sqlite] property/config file for SQLite

2008-05-03 Thread John Stanton
K.I.S.S. [EMAIL PROTECTED] wrote: > But the question is who the target audience for SQLite is? Is it > software developers or application users? If programmers can customize > SQLite by changing source code, then they are probably smart enough to > change property files. > I am not complaining

Re: [sqlite] property/config file for SQLite

2008-05-03 Thread Virgilio Alexandre Fornazin
The database contains all pragmas commands you had executed. Why keep storing in a configuration file, since it´s not a database server? Please keep in mind that SQlite is a general purpose 'embedded' database engine, not a DBA-managed database server. Also WHY SQlite should have a configuration

[sqlite] SQLite & TCL: A "SELECT" from one-column table

2008-05-03 Thread Zbigniew Baniewski
Take a look at following example: dbcomm eval {CREATE TABLE something( a_string VARCHAR(20) )} dbcomm eval {INSERT INTO something VALUES ('Version V8.5')} Now, if you want to retrieve the value: tclsh8.5 [~/tmp/tcltk]dbcomm eval "SELECT a_string FROM something" Version V8.5 Why so

Re: [sqlite] property/config file for SQLite

2008-05-03 Thread Shibu . Narayanan
But the question is who the target audience for SQLite is? Is it software developers or application users? If programmers can customize SQLite by changing source code, then they are probably smart enough to change property files. I am not complaining about the lack of a config file, just

Re: [sqlite] Proposed incompatible changes to the SQLite VFS layer

2008-05-03 Thread Shawn Wilsher
On Sat, May 3, 2008 at 12:30 AM, Roger Binns <[EMAIL PROTECTED]> wrote: > I'd also prefer the documentation to be in the wiki so people who use it > can update it as they discover various issues. The doc is currently > duplicated in http://www.sqlite.org/34to35.html and >

Re: [sqlite] property/config file for SQLite

2008-05-03 Thread John Stanton
Not only is it a feature, it is a blessing. One of the most endearing features of Sqlite is that one file encapsulates everything. The simplicity is no accident but rather the reward of plenty of design discipline. I can attest from experience to the improvement in software reliability

Re: [sqlite] property/config file for SQLite

2008-05-03 Thread D. Richard Hipp
On May 2, 2008, at 2:50 PM, [EMAIL PROTECTED] wrote: > > Is there a way to configure SQLite using a property/config file? SQLite has no configuration file. This is by design. SQLite is intended to be a "zero-configuration" database. See http://www.sqlite.org/zeroconf.html . The lack of

Re: [sqlite] property/config file for SQLite

2008-05-03 Thread Shibu . Narayanan
Nothing specific. Reading messages here gives me the impression that SQLite behavior can be modified only by changing the source code. Just wanted to confirm. Shibu Narayanan Consultant, PrimeSourcing Division, Investment Banking Group Tel.Office: 91-80-2208-6270 or 91-80-6659-6270 e-mail: