On 9/30/2019 12:55 PM, andrew fabbro wrote:
On Mon, Sep 30, 2019 at 9:57 AM Ralf Quint <freedos...@gmail.com
<mailto:freedos...@gmail.com>> wrote:
SQLite by default is using 2000 pages of 4096 bytes as caching buffer
(that's 8MB, in older versions the default page size was 1024
bytes). I
am not aware of a SQLite port for plain DOS (not newer Windows
command
line!), but that certainly is far more RAM than a normal DOS can
provide
(AFAIK, this has to be REAL RAM, not XMS/EMS).
I'm probably not appreciating your point, but FreeDOS 1.3 ships with
SQLITE.EXE, installable via fdimples. It's SQLite 3.5.6.
Well, and what application is using it? Btw, 3.5.6 is one of the "older"
versions, the switch to 4KB page size came in 3.12.0, current version is
3.29.0...
And beside the RAM requirements, disk I/O speed is probably far more
important than in which kind of CPU code (16bit/32bit) is written.
Not
to mention that SQLite is a library to be included/linked into
your own
application, while dBASE and derivatives are applications (which
can be
programmed with their own language) all by themselves...
sqlite (regardless of platform) also includes a CLI version which can
process SQL commands from stdin or files, but you're right that its
primary purpose is to as an embedded SQL engine, whereas dBASE and its
ilk were more application platforms.
You can maybe do some basic SQL maintenance with SQLite this way, but
that would be even more of a stretch to compare this to dBASE/FoxPro...
Let's just say this might be another fine example of something that is
technically possible, but not practically feasible...
Ralf
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
_______________________________________________
Freedos-user mailing list
Freedos-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/freedos-user
