1
Programming using the Ultra Hal Brain Editor / Brain in SQLite?
« on: January 21, 2005, 06:05:09 pm »
Robert,
I am no programmer in any way, but may I suggest a different opensource database to take a look at? Our website is currently running on PostgreSql (http://www.postgresql.org/). I'd love to see if Hal can be ported to run on this database. I have a development server running if you need someone to test
)
As it stands now, we have the website and accounting running in PostgreSql, and it would be great to add Hal to this. Jim
Jim Ratte
Recreational Mobility
http://www.recreationalmobility.com
I am no programmer in any way, but may I suggest a different opensource database to take a look at? Our website is currently running on PostgreSql (http://www.postgresql.org/). I'd love to see if Hal can be ported to run on this database. I have a development server running if you need someone to test

As it stands now, we have the website and accounting running in PostgreSql, and it would be great to add Hal to this. Jim
Jim Ratte
Recreational Mobility
http://www.recreationalmobility.com
quote:
Originally posted by Medeksza
I've hired someone to work on moving Hal to a database engine. We hit a small snag. Originally I wanted to support Acess, MS SQL, Oracle and mySQL. Here's a quote from the developer:quote:
In order to count the number of words in one string that are contained in another string, a function is needed within the database (SQL language doesn't support this). Unfortunately (I never knew this before), you can't call a query that uses an Access VBA function in it from a VB application. Without that function, it is impossible to count the number of occurrences from SQL. This only leaves the option of returning them all and counting them the way that you are doing it now, which probably wouldn't be faster than it is now. This is only a problem with Access, and probably mySQL as well. SQL Server and Oracle support inline function calls from SQL Statements, so it would work on those systems, but that doesn't solve your problem.
We are now looking into the feasability of using SQLite since it is open source and we can add the required functionality to the engine itself.