>> From: Peter <xxxxxx@gmx.net> >> Date: Saturday, September 14, 2019 12:41 PM > >> Just for reference, I have implementations of the following for >> Chez and MIT, based on the ffi: > >[...] > > for SQLite (libsqlite3), postgres (libpq), mysql (mysqlclient) and > Oracle (ocilib). Depending on the database, they do a bit of > automatic conversion to the relevant Scheme types. They all work > ok. The biggest problem is Oracle, as you need to register to > actually get the driver files from the website. Does that include legal exposure to an audit as the license for Oracle Database Express Edition does: https://www.oracle.com/downloads/licenses/db18c-express-license.html > Upon 45 days written notice Oracle may audit the use of the > program. You agree to cooperate with Oracle's audit and provide > reasonable assistance and access to information. You agree that > Oracle shall not be responsible for any of your costs incurred in > cooperating with the audit. On the other hand, if the driver files are in the 2.5/2GB Linux or Windows distributions of this edition, it appears no registration is required, and you can redistribute them (or the whole database package), provided the recipient agrees to the same license terms. Note roughly this has been an Oracle policy for a *long* time, freely distributing a version like this, for development, or lots more in this edition. Looks like Microsoft has something like this as well: https://www.microsoft.com/en-us/sql-server/sql-server-downloads Only 10GB of data instead of the 12GB limit for Oracle, and half the CPU threads and RAM (1 vs. 2), but either are a whole lot nowadays. The above link also has a "full-featured" free edition of SQL Server for development and test only. Woah, below there's "Install SQL Server 2017 on Linux or in Docker! The former a limited number of systems, Red Hat Enterprise Linux 7.3, Ubuntu Linux 16.04, SUSE Linux Enterprise Server v12 SP2. The Docker version is based on that Ubuntu release. Back to you, after a big snip: > I agree that at least SQLite, postgres and mysql should be > targetted, but the commercial ones are useful to have too (I need to > connect to our Oracle cluster almost every day, and am happy to be > able to do it from Scheme). I have no objections to supporting commercial databases including Oracle, I like the technology modulo all the moving parts of an installation, but the company is another matter, the above exposure as Oracle has turned its junkyard dog aggression up to 11.... SQL Server on the other hand, I have a friend who uses that on and off at work, and he's just now getting into Docker.... - Harold
