New Proggy Questions, DB Types and Features.

ShawnK

Okay I am in the final stages of creating a news proggy in PHP, currently it only supports mysql BUT i have built in the ability for multiple db types to be used using extended classes....does someone know of a detailed tutorial on porting over mysql to mysqlite, and what database types are the most popular that i should support.

ALSO

what features would you all like in a news scripts

i've already got the ability to read from phpBB and IPB forums :-D

bpat1434

Well, mysqli and mysql are so close that you could use the same queries on both.

The most popular databases would be:
MySQL
MySQLi
PostgresSQL
MSSQL
Oracle

There are others like Firebird and others. Do note that there are differences between SQL syntaxes and what's supported and what's not. MySQL is kind of unique in certain areas, and as usual, MSSQL follows it's own rules. Your best bet would be to make sure all queries are compliant with SQL '99 standard, as most if not all modern RDMSes stick close to that standard.

ShawnK

Now a so called "ethics" question, are all of these databases open-source...as my news script will be released under GPL 2, so you get what i mean?

bpat1434

Not really ethics, more legality 😉

The top 3 I posted are free (as mySQLi is just an extension of mySQL) and PostgreSQL is free too. MSSQL is a Microsoft product, and Oracle might be free, but I think you have to pay for it.

Check oracle out at Oracle Database 10g. Looks like they have a few that are free (standard and express) but the Enterprise might be pay. You'd have to ask them.