| Which database is MOST desirable/needed |
| Oracle |
|
0% |
[ 0 ] |
| MySql |
|
50% |
[ 5 ] |
| DB2 |
|
0% |
[ 0 ] |
| Generic ODBC interface (Linux/Unix/Windows) |
|
30% |
[ 3 ] |
| Postgres |
|
10% |
[ 1 ] |
| Microsoft Sql Server |
|
0% |
[ 0 ] |
| ProvideX file system |
|
0% |
[ 0 ] |
| BBx keyed files |
|
0% |
[ 0 ] |
| Thoroughbred keyed files |
|
10% |
[ 1 ] |
|
| Total Votes : 10 |
|
| Author |
Message
|
| Mike King |
 Posted: Sat Aug 04, 2007 12:27 pm Post subject: Which Database interface |
 |
|
Site Admin
Joined: 26 Jul 2007
Posts: 43
Location: Unionville, Ontario, Canada
|
Our current plans for MSB is to provide support for a number of database products along with its own keyed file system which itself we will be enhancing.
This poll is for which database interfaces to consider first. While all the databases on the list would be considered at some point, we are looking to determine which DB is at the TOP of the wish list. |
|
| Back to top |
|
 |
| sdevouard |
| Posted: Sat Aug 04, 2007 2:17 pm Post subject: |
|
|
User
Joined: 03 Aug 2007
Posts: 12
Location: Evry, France
|
Although the open source philosophy of MSB appeals for a direct interface to MySQL and Postgres, as other open source language/environment (PHP for example), I have voted for a Generic ODBC interface, as this would allow MSB to interface to any compliant database, thus the system would be more open and compatible with other applications right from the beginning.
I'm nevertheless giving an ordered list of what should be implemented IMHO :
1) Generic ODBC interface (Linux/Unix/Windows)
2a) MySql
2b) Postgres
=> For the open source philosophy
3) Microsoft Sql Server
=> For the Windows variations of MSB
4a) Oracle
4b) DB2
=> For people with lots of money 
5a) ProvideX file system
5b) BBx keyed files
5c) Thoroughbred keyed files
=> Last on my list because files from other Basics could be converted (even big ones) and maybe a system similar to what currently exists in PxPlus could be developed first (using a pipe connected to the other BB interpreter process)
_________________
Stéphane
aka PvxGuru |
|
| Back to top |
|
|
| John |
| Posted: Sun Aug 05, 2007 7:23 am Post subject: |
|
|
User
Joined: 05 Aug 2007
Posts: 18
|
I'm using the 'C' API connection to MySQL with the HTTP Basic interpreter application server project I'm working on. MySQL works well under Windows and Linux in the testing I have done.
There is nothing wrong with having a BB file system as the primary and using SQL as an add-on. If an add-on approach is taken then it opens the door for commercial plug-ins as well.
John |
|
| Back to top |
|
|
| MoJoPokeyBlue |
| Posted: Tue Aug 14, 2007 4:31 pm Post subject: Database choices |
|
|
User
Joined: 14 Aug 2007
Posts: 1
Location: Michigan
|
Mike,
From a development standpoint, what Database would be the easiest for you? Also, any guesses as to timeframes?
Eric |
|
| Back to top |
|
|
| Mike King |
| Posted: Tue Aug 14, 2007 4:35 pm Post subject: Re: Database choices |
|
|
Site Admin
Joined: 26 Jul 2007
Posts: 43
Location: Unionville, Ontario, Canada
|
| MoJoPokeyBlue wrote: |
| From a development standpoint, what Database would be the easiest for you? Also, any guesses as to timeframes? |
Eric
As we have access to the existing PxPlus MySql interface, this will likely be the first we implement. As for timeframe, we are targeting late fall to have the interface up and running -- ideally with the initial release.
Mike |
|
| Back to top |
|
|
|
|
