Re: [Radiant] Radiant and IBM DB2
Hi Anton, Thanks for your reply. The Ruby on rails book - the Pickaxe book - discusses how to use RoR with legacy databases. I'd recommend looking at that. You mean the Agile Web Development with Rails book? In short, the answer is YES, but you need to have some other database to act as a 'shim' of some kind. Could you explain that a bit further? Thank you! - Johannes -- Concern for people and their fate must always form the chief interest of all technical endeavors in order that the creations of our mind shall be a blessing, not a curse, to humanity. Never forget this amidst your diagrams and equations. -- Albert Einstein ___ Radiant mailing list Post: Radiant@radiantcms.org Search: http://radiantcms.org/mailing-list/search/ Site: http://lists.radiantcms.org/mailman/listinfo/radiant -- http://blog.springenwerk.com ___ Radiant mailing list Post: Radiant@radiantcms.org Search: http://radiantcms.org/mailing-list/search/ Site: http://lists.radiantcms.org/mailman/listinfo/radiant
Re: [Radiant] Radiant and IBM DB2
Johannes Fahrenkrug said the following on 01/13/2009 03:39 AM: Hi Anton, Thanks for your reply. The Ruby on rails book - the Pickaxe book - discusses how to use RoR with legacy databases. I'd recommend looking at that. You mean the Agile Web Development with Rails book? In short, the answer is YES, but you need to have some other database to act as a 'shim' of some kind. Could you explain that a bit further? I could copy out the section of the book ... but that gets into copyright violation issues. It may be that the DB2 tables don't have a field id. So how are you going to have ROR access them? You have a 'shim' database that works with id and maps that to the index of the DB2 table. -- Hackers: Self-righteous crackers -- CSO Magazine's The Devil's Infosec Dictionary ___ Radiant mailing list Post: Radiant@radiantcms.org Search: http://radiantcms.org/mailing-list/search/ Site: http://lists.radiantcms.org/mailman/listinfo/radiant
Re: [Radiant] Radiant and IBM DB2
Hi Davide, Wow, That's great information! Thank you so much. You know, I've just finished setting up DB2 on my Mac and I've just gotten my first Radiant app on DB2 up and running. That's really cool. I've written a short article about it here: http://blog.springenwerk.com/2009/01/ibm-db2-on-mac-with-ruby-rails-and.html Once again, thank you! - Johannes On Tue, Jan 13, 2009 at 1:05 PM, Panizzolo, Davide davide.panizz...@unitn.it wrote: Hi Johannes, in our Department we developed a Radiant application using DB2. We created a radiant application using the DB2 adapter and then we created some extensions to work with the DB2 legacy database. The main difficulty was that the DB2 adapter has some significant limitation (for example the rename_column do not work) and this was a problem especially for migrations. You need to start with the final version of the schema of your db, since changes are difficult. Of course this is a general RoR - DB2 problem. Except for this problem the application works fine. Davide ___ Radiant mailing list Post: Radiant@radiantcms.org Search: http://radiantcms.org/mailing-list/search/ Site: http://lists.radiantcms.org/mailman/listinfo/radiant -- http://blog.springenwerk.com ___ Radiant mailing list Post: Radiant@radiantcms.org Search: http://radiantcms.org/mailing-list/search/ Site: http://lists.radiantcms.org/mailman/listinfo/radiant
Re: [Radiant] Radiant and IBM DB2
Hi Anton, It may be that the DB2 tables don't have a field id. So how are you going to have ROR access them? You have a 'shim' database that works with id and maps that to the index of the DB2 table. Ok, I see. Yes, the missing id column problem will have to be solved. I think Dr. Nic has written a plugin to support multi-column primary keys. That might be what I'll need. - Johannes -- Hackers: Self-righteous crackers -- CSO Magazine's The Devil's Infosec Dictionary ___ Radiant mailing list Post: Radiant@radiantcms.org Search: http://radiantcms.org/mailing-list/search/ Site: http://lists.radiantcms.org/mailman/listinfo/radiant -- http://blog.springenwerk.com ___ Radiant mailing list Post: Radiant@radiantcms.org Search: http://radiantcms.org/mailing-list/search/ Site: http://lists.radiantcms.org/mailman/listinfo/radiant
Re: [Radiant] Radiant and IBM DB2
Johannes Fahrenkrug said the following on 01/13/2009 08:00 AM: Hi Anton, It may be that the DB2 tables don't have a field id. So how are you going to have ROR access them? You have a 'shim' database that works with id and maps that to the index of the DB2 table. Ok, I see. Yes, the missing id column problem will have to be solved. I think Dr. Nic has written a plugin to support multi-column primary keys. That might be what I'll need. I'd still consult the RoR book and other sources. I seem to recall viewing a podcast about this once but don't recall teh source. -- If you're not part of the solution, you're part of the precipitate. ___ Radiant mailing list Post: Radiant@radiantcms.org Search: http://radiantcms.org/mailing-list/search/ Site: http://lists.radiantcms.org/mailman/listinfo/radiant
Re: [Radiant] Radiant and IBM DB2
Johannes Fahrenkrug said the following on 01/12/2009 12:08 PM: Hi, I'm new to the list and relatively new to Radiant. I'm evaluating Radiant for a mid-sized customer project. The customer has a legacy DB2 database. Replacing it is not an option for the customer. So my question is: can I use Radiant with DB2? Does anyone have any experience doing this? The Ruby on rails book - the Pickaxe book - discusses how to use RoR with legacy databases. I'd recommend looking at that. In short, the answer is YES, but you need to have some other database to act as a 'shim' of some kind. -- Concern for people and their fate must always form the chief interest of all technical endeavors in order that the creations of our mind shall be a blessing, not a curse, to humanity. Never forget this amidst your diagrams and equations. -- Albert Einstein ___ Radiant mailing list Post: Radiant@radiantcms.org Search: http://radiantcms.org/mailing-list/search/ Site: http://lists.radiantcms.org/mailman/listinfo/radiant