|
|
Posted by webcm123 on 06/04/07 21:20
People say that structural programming isn't good for database
connection. I code fast-running structural oriented CMS and I don't
know what I should do. I use mysql connection using mysql_*. I want
also to use SQLite.
Can you give me some advices?
1. PHP4 is still used. I want to be compatible.
2. There are various methods - MySQL, MySQLi, SQLite, PDO... I have
noticed that PDO and MySQLi will be pervasive only in the future. One
of paid servers doesn't support MySQLi because of its platform -
CentOS.
3. I have read some notes and articles so I have stated that PDO isn't
perfect and MySQLi and MySQL are better interfaces.
4. Is SQLite3 only accessed from PDO?
5. Does procedural MySQLi use objected mechanisms?
6. I have read that OOP uses more computational power of CPU and uses
more RAM. Is it true? The main aim of this CMS is SPEED and little RAM
using. I might only use OOP for database connection like PunBB.
7. If there would be MySQL_* support, should be other function also
procedural? If a function return an object, will be it his copy or
only a reference?
Why do I need other functions? If I want to get data to an array, I
don't want to type so much code - but only call 1 function, e.g.
db_read(...)
The function would also add table's prefix to table name (as present).
Navigation:
[Reply to this message]
|