> let me see if I understand your situation- you want to replace the > frontend entirely, and keep your current backend tools. The front end > has a web interface, the back end is all command-line. > > You're thinking about redoing the front end completely, in Django, and > using the Django ORM interface in your existing backend scripts. > Absolutely- you've got it in one.
> For least pain, I'd use the existing database in the new Django app- > see http://www.djangoproject.com/documentation/legacy_databases/ - > and not worry about the ORM in your backend. When you need a new > table, create it in the frontend model, run manage.py syncdb once, and > there it is. If you start re-writing your backend to use an ORM, > you're "fixing what isn't broken". Django can't alter tables- add > columns, rename, add index, change type, etc, so won't help with many > common database admin tasks. (If you really want to use the ORM- how > about putting your backend into a maintenence section of your new > frontend, and calling it with "wget" or the like?) > Good points, unless you know: - the backend is a scheduler; it has to run continuously (it also checks the state of various boxes, does updates, all sorts of things...) - our current db access is done through a custom wrapper, which has 'issues'- so unfortunately it's not 'not broken' :-/ - our current db schema could benefit some re-work (no enforced unique id's/keys, among other things...) - we currently use MySql, but we're getting the impression that Postgres may be better; we've had people work on it over time that have suggested constraints could be used to make our lives easier. It's not a system that deals with millions of db hits, so we'd rather go for robust than fast. So a working abstraction layer may make this easier to achieve. Data migration is no huge issue- if worst comes to the worst, I write a dumb python script that reads row in old db, munges data, adds row to new db. Having said that, I appreciate the comment, I do tend to see shiny new things and want to play with them :-) Regards, Julian --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
