[futurebasic] Re: [FB] Database Front-End

Message: < previous - next > : Reply : Subscribe : Cleanse
Home   : January 2008 : Group Archive : Group : All Groups

From: Christopher Wyatt <poetcsw@...>
Date: Thu, 17 Jan 2008 22:42:10 -0600
For PostgreSQL the libpq C API is 800K -- source, headers, makefile,  
etc. It looks pretty clean (relatively) and well-maintained. It's in  
C, which seems ideal for a port to OS X. MySQL licensing is a tad  
messy, but they also have several C API models. The SQLite code is for  
embedding directly into an application.

The SQLite approach might be best, since that would let someone have a  
"database" without an external server. Downside is that it is single  
user. Benefit is that OS X uses SQLite in CoreData, so it's already a  
standard on the Mac.

- CSW


On Jan 17, 2008, at 9:00 PM, Brian Stevens wrote:

> As you may know, the new converter/compiler for FB (known as FBtoC)  
> creates C code and compiles it with gcc. While there might be better  
> methods ( and I would need to see and review the APIs at a minimum  
> before having a clue), it is possible to essentially passthrough  
> inline C code in an FB program when using FBtoC. FBtoC does not  
> translate it (because it isn't BASIC and doesn't require  
> translation) and just passes it to the compiler as is. I'm hedging  
> here about if this will work because this is all OTTOMH without any  
> research.
>
> BTW: database support is one area that would really increase the  
> broad appeal of FB and elevate it to more of an enterprise tool.   
> Anyone want to do the research?
>
>
> Brian S.
>
>
> On Jan 17, 2008, at 7:20 PM, Christopher Wyatt wrote:
>
>> Since the MySQL and SQLite API's in C/C++ are published, I would  
>> assume the C code could be used to add this functionality to FB?  
>> Any thoughts?
>>
>> On Jan 17, 2008, at 8:11 PM, Brian Stevens wrote:
>>
>>>
>>> On Jan 17, 2008, at 3:41 PM, Christopher Wyatt wrote:
>>>
>>>> My main task when programming is to create database front-ends.  
>>>> REALbasic is okay for this, certainly, and you can really do a  
>>>> lot with CoreData and Cocoa. Can I do anything with MySQL or  
>>>> SQLite using FB?
>>>
>>> If you mean does FB provide any official support specifically  
>>> aimed at MySQL etc., the answer is no. FB is a very flexible  
>>> language however, so with appropriate specs for the MySQL API, it  
>>> should be possible.
>>>
>>>
>>> Brian S.
>>>
>>> --
>>> To unsubscribe, send ANY message to: futurebasic-unsubscribe@...
>>>
>>
>> --
>> To unsubscribe, send ANY message to: futurebasic-unsubscribe@...
>>
>
> Brian S.
>
> --
> To unsubscribe, send ANY message to: futurebasic-unsubscribe@...
>