Tcl is really fine for web interfaces. Porting an almost 10 year old web
application to sqlite2 and sqlite3 was a charme. It is supporting Linux,
SunOS,Windows and maybe HP-UX so far. If you are interested in an
generic example using SQLite 3.1.3 (but also supporting 2.1.16) look at
APSW is not DBAPI compliant but it's close enough
Note that I do document how APSW differs from DBAPI.
http://www.rogerbinns.com/apsw.html#dbapinotes
APSW is very nice.
Thanks :-)
I've used it and PySQLite and I'd recommend APSW. It's "thinner".
Note that it is almost impossible to do a DBAPI
Eli,
I'd highly recommend Python. I've used Perl, PHP and Python. Python is
hands-down the winner. After getting ahold of the elegance of Python, PHP
feels like a hack job. Perl is "executable line noise". Python is very
mature and very nice. It has a far cleaner implementation of just
On Mon, Mar 07, 2005 at 04:22:50PM -0500, Eli Burke wrote:
> Ease of learning is a plus as I need to get something basic up and
> running fairly fast. I've heard good things about Python in that respect.
> Does anyone have alternative suggestions, or if you agree that Python Is
> Good, would you
Eli Burke wrote:
I've been working on a project using sqlite3 since last fall. At the time,
I knew that it would need a web-based front-end eventually. I have a very
small bit of experience with PHP, and I assumed that PHP would support
sqlite3 sooner or later. Well, it's later, and as far as I
I am getting this assert when I call my sqlite from a c++ program...
i have if def for c extern all of the files and everything compiles...
but I get this error...
main.c
Assert (iDb>=0 && iDbnDb)failed in file ../../sqlite/src/build.c at
line 2154
Anybody have any ideas... what my problem is.
On Mon, Mar 07, 2005 at 04:22:50PM -0500, Eli Burke wrote:
> So, I was wondering if any of the more opinionated among you would care
> to suggest an interface language. It'll be on a Linux box, presumably
I qualify as opinionated, so: Tcl. The fact that Dr. Hipp supports
Tcl directly for
On Mon, 7 Mar 2005 17:30:07 -0500
"Griggs, Donald" <[EMAIL PROTECTED]> wrote:
> Hi Gerald,
>
> I don't think attachments are allowed on the list.
Thank you, I noticed it only now.
> You may want to check
> the contributions section of the wiki, or perhaps the version tracking
> system.
I
I strongly suggest to use pysqlite. APSW may be more powerfull in some areas
but is not complaint with the python standard DB access API. If you will use
pysqlite: 1) you will learn Python standard DBAPI 2) you will able to easly
(relativly) migrate to another DB engine in future (mysql,
I suggest using a Perl 5.8 based solution. Perl is very mature and
has strong SQLite 3 support in its extensions (DBD::SQLite). This
will run on anything. It also isn't dependent on Microsoft
technology. There are a number of pre-existing solutions on CPAN and
elsewhere that you can look
I've been working on a project using sqlite3 since last fall. At the time,
I knew that it would need a web-based front-end eventually. I have a very
small bit of experience with PHP, and I assumed that PHP would support
sqlite3 sooner or later. Well, it's later, and as far as I know, PHP
is still
Naming the database ':memory:' (without the quotes) will not create a
file but place the database in memory.
Needless to say - it will not remember tables created their after
disconnection, and will use RAM up :-)
Eddy
jack wu wrote:
in the documentation: "Appropriate Uses For SQLite" it
says:
[EMAIL PROTECTED] wrote:
FYI:
The function, as defined in ANSI, you are looking for is COALESCE
select COALESCE(MAX(SubOrder), 0)+1 from Table1 where ...
This is supported in sqlite3 (and I guess sqlite2)
Eddy
What I want to do is:
select ISNULL(MAX(SubOrder), 0)+1 from Table1 where ...
What Platform are you on?
For UNIX platforms there may be a problem, see the comments in the
os_unix.c file in the source directory, or here
http://www.sqlite.org/cvstrac/getfile/sqlite/src/os_unix.c?v=1.41
Though reading through things, wrapping arounb a MUTEX should be OK
so long as
On Sun, 2005-03-06 at 23:36 -0800, Charles Mills wrote:
> Is there anyway to do 'pragma table_info' on a table in an attached
> database (even if a table in the main database has the same name). I
> guess I am wondering why this doesn't work:
> PRAGMA table_info(database_name.table_name)
>
> I
15 matches
Mail list logo