Welcome Guest, Not a member yet? Register   Sign In
Automatically Creating Database Tables
#10

[eluser]Pert[/eluser]
[quote author="nickaceph" date="1369391802"]is there any extension that parses Datamapper ORM through db->forge() to generate basic table base on
[/quote]

When writing this kind of solution, there are few things to keep an eye out for.

Not all hosting providers will allow PHP to modify databases - you should first try few commands on live server to make sure it's even technically possible, before writing full feature product.

It's usually disabled to limit damage malicious hackers might do if they do happen to get a hold of database connection details.

The best practise is to lock down MySQL as much as possible and allow structure changes to be run through DBMyAdmin or other similar tool.

There are ways to restructure your database in a way that you would not need to edit database structure.

If that is not an option, letting users alter tables on fly could be dangerous as data could be accidentally deleted.

Hope this helps.


Messages In This Thread
Automatically Creating Database Tables - by El Forum - 12-21-2010, 10:36 AM
Automatically Creating Database Tables - by El Forum - 12-21-2010, 11:24 AM
Automatically Creating Database Tables - by El Forum - 12-21-2010, 11:32 AM
Automatically Creating Database Tables - by El Forum - 12-21-2010, 11:33 AM
Automatically Creating Database Tables - by El Forum - 12-21-2010, 11:36 AM
Automatically Creating Database Tables - by El Forum - 12-21-2010, 03:23 PM
Automatically Creating Database Tables - by El Forum - 12-21-2010, 03:43 PM
Automatically Creating Database Tables - by El Forum - 12-21-2010, 04:00 PM
Automatically Creating Database Tables - by El Forum - 05-24-2013, 03:36 AM
Automatically Creating Database Tables - by El Forum - 05-24-2013, 05:04 AM



Theme © iAndrew 2016 - Forum software by © MyBB