Re: [Pythoncard-users] Python/PythonCard: live like HyperCard?

[Andy T. <an...@ha...>]

Kevin Altis wrote:
> On Apr 29, 2004, at 7:29 AM, RANDY BURNS wrote:
> 
>> There are some simple single user databases that are written in Python 
>> or Perl.
>> These are a bit more than what I think of as a "flat file" databases, 
>> and allow you to tie an associative array to a database. If you used 
>> one of those and thought the persistancy interface through early on in 
>> the process, I think it  would be pretty easy for someone to convert 
>> this tool to SQL databases early in the process.
>>  
>> >What I do know is possible and will probably do first is make a
>> >flatfileDatabase environment app which has some of the features of a
>> >full PythonCard environment. This is probably analogous to FileMaker or
>> >MS Access. The database app is started and then you can open, use,
>> >design, etc. various database templates which will all get some
>> >capabilities from the database app environment. The same thing would be
>> >possible for SQL databases, but I'll do it for flatfileDatabase first.
>> >If anyone else is interested, let me know and maybe work will get done
>> >on it before 1.0 is finished.
>>
> The flatfileDatabase module currently support pickle, XML, and MetaKit. 
> It should be relatively easy to have it support PySQLite and Gadfly. But 
> the other framework stuff is a higher priority item for me, so I don't 
> plan to spend any time on it until the other stuff is done, unless 
> someone else takes ownership and just needs a bit of input and 
> clarification from me on how particular bits work.
> 
> ka
> 
> 

I've already done most of the legwork, gadflyDatabase.py inherits from 
flatfileDatabase.py and replaces the file based interface with a DB-API 
one. Adding support for SQLite shouldn't be much more work.

Regards,
Andy
-- 
--------------------------------------------------------------------------------
 From the desk of Andrew J Todd esq - http://www.halfcooked.com/