Re: Generic database management tool
I feel like these toolkit projects are probably more attuned to performance and stability issues, as they are being used for some fairly intense apps. Make no mistake, these tool kits (at least my ODBCMyAdmin) use a lot of Javascript, but what they produce is plain vanilla CFM and HTML code. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242313 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
On 6/4/06, Claude Schneegans [EMAIL PROTECTED] wrote: I feel like these toolkit projects are probably more attuned to performance and stability issues, as they are being used for some fairly intense apps. Make no mistake, these tool kits (at least my ODBCMyAdmin) use a lot of Javascript, but what they produce is plain vanilla CFM and HTML code. Understood...but the toolkits I was referring to in that message were the AJAX/DHTML javascript libraries like dojo and rico, not database toolkits like you are developing. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242316 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
There is also a cfmyadmin. Exact, although CFMyadmin is just PHPMyadmin rewriten in CF, and like PHPMyadmin, it only handles MySQL databases. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:24 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
That's an unfortunate restriction. When I started this project, Mozilla was still on the drawing board, and Netscape was definitely not able to do the job. Now it would just be a question of verifying all scripts for compatibility with Mozilla. I t is almost done actually. Mice are overrated. =) I use keyboard shortcuts all the time. You can use shortcuts when they helps, but most of the time with ODBCMyAdmin, you just drag'ndrop tables to create joins, you select fields in a table, etc. Shortcuts won't help. The great advantage is that you never have to type a table or column name, which you couldn't do with shortcuts either, and you never have a query that fails because of a spelling mistake. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242234 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Generic database management tool
Isn't that what he was asking? Or did I miss something...I am prone to brain farts these days hehe -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Saturday, 03 June 2006 06:30 To: CF-Talk Subject: Re: Generic database management tool There is also a cfmyadmin. Exact, although CFMyadmin is just PHPMyadmin rewriten in CF, and like PHPMyadmin, it only handles MySQL databases. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242237 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
Isn't that what he was asking? Actually, he didn't specify MySQL. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242238 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
On 6/2/06, Claude Schneegans [EMAIL PROTECTED] wrote: - advanced query buider à la Access, with all types of JOINS, GROUP, WHERE, HAVING etc. clauses; even UNIONs are supported (not in Access) Is this a web-based tool? I assumed so at first, but don't know how you'd tie that in with cfstudio. Of course, I never tried to extend studio, didn't know you could. I sorta lost interest when it became homesite, not sure why exactly. Sentimentality, I guess. Didn't cf deserve it's own editor? ;-) Eh. At any rate, I'd seen a nice, rich web-based query builder some time back, that never got released, I don't think, as I can't find it now. My clunky one sucks, so I've kept my eye out, sorta. If'n yers is web-enabled, Got any screen shots? Not that I know French... :D ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242244 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
Is this a web-based tool? Sure: 100% You just install it on your server, preferabilly on your development server. For CF5, you just have a CFX to install, for CFMX you don't need. Presently I have tested it for - Access, - MySQL - Oracle, - MS SQLServer, - Sybase For Access, there is also a Compact database utility. I assumed so at first, but don't know how you'd tie that in with cfstudio. You don't actually need CFStudio to run it, just call its home page, but it it easy to tie any web site as a Custom Button in CFStudio. It is just that I'always used CFStudio, and I'm still waiting to see any better product (call it Homesite if you like). I've tried CFEclipse, but CFStudio eclipses it ;-) Of course, I never tried to extend studio, didn't know you could. See Options - Customized - Add Custom Button,... I sorta lost interest when it became homesite, not sure why exactly. Actually, when it was first released by Ipswitch Inc. it was Homesite. Then Allaire bought the product. add the CF stuff in it, and called it CF Studio. Then Macromedia bought Allaire, may be they found that the name CFStudio was too much tied to CF, and it would outshine their own editor Dreamweaver, so they rebaptised it Homesite, but it is essentially the same product. Didn't cf deserve it's own editor? It sure does, and for me it has always been CFStudio! ;-) If'n yers is web-enabled, Got any screen shots? Not that I know French... I'll try to prepare some dynamic demo, note that the system is in English, it is just that if I write the docs and the online help in English myself, it will be kind of ... well, couci couça... ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242248 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
On 6/3/06, Claude Schneegans [EMAIL PROTECTED] wrote: Is this a web-based tool? Sure: 100% Does it run on linux based CF instances? I've tried CFEclipse, but CFStudio eclipses it ;-) Heh. That's totally alright, what's good for the goose don't mean it's good for the gander. Although another nifty feature, is that CFE supports various version of CF, as well as BlueDragon. Theoretically you could have one project in CF 5 and another in 7 and have the editor know what is available in each project. Good eat'n, I tell ya what. Actually, when it was first released by Ipswitch Inc. it was Homesite. Then Allaire bought the product. add the CF stuff in it, and called it CF Studio. Interesting backstory. I appreciate the name better now. And more becomes clear about IDEs and CF. I'll try to prepare some dynamic demo, note that the system is in English, it is just that if I write the docs and the online help in English myself, it will be kind of ... well, couci couça... ;-) What does couci couça mean again? It tickles some memory... your English seems fine to me... :D ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242252 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Generic database management tool
If your looking for a totally web based SQL Server database manager, try www.mylittletools.com -Original Message- From: Denny Valliant [mailto:[EMAIL PROTECTED] Sent: 04 June 2006 00:34 To: CF-Talk Subject: Re: Generic database management tool On 6/3/06, Claude Schneegans [EMAIL PROTECTED] wrote: Is this a web-based tool? Sure: 100% Does it run on linux based CF instances? . I've tried CFEclipse, but CFStudio eclipses it ;-) Heh. That's totally alright, what's good for the goose don't mean it's good for the gander. Although another nifty feature, is that CFE supports various version of CF, as well as BlueDragon. Theoretically you could have one project in CF 5 and another in 7 and have the editor know what is available in each project. Good eat'n, I tell ya what. Actually, when it was first released by Ipswitch Inc. it was Homesite. Then Allaire bought the product. add the CF stuff in it, and called it CF Studio. Interesting backstory. I appreciate the name better now. And more becomes clear about IDEs and CF. I'll try to prepare some dynamic demo, note that the system is in English, it is just that if I write the docs and the online help in English myself, it will be kind of ... well, couci couça... ;-) What does couci couça mean again? It tickles some memory... your English seems fine to me... :D ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242254 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
Does it run on linux based CF instances? With CFMX, I suppose, although I never tested. It only uses a CFC in Java. With CF 5 it needs a CFX (ODBCInfo) which won't run under Linux. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242263 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
If it's not out there, I'll make one somehow, I guess. dhtmlgoodies looks like it's got stuff to fit the bill, UI wise. If you haven't already, I'd take a look at dojo... http://dojotoolkit.org/ If I was going to do some intense AJAX/DHTML work, I'd look at using one of these toolkits (like dojo, or the one you previously mentioned...rico) rather than random scripts from something like dhtmlgoodies. I'm already a little dubious about using intense amounts of javascript processing in my pages (and the memory usage and crashes that I've seen with various AJAX calendars running at the same time as gmail seem to validate that). I feel like these toolkit projects are probably more attuned to performance and stability issues, as they are being used for some fairly intense apps...whereas a cobbled together group of scripts might have unintended consequences. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242291 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Generic database management tool
Is anyone out there using any kind of generic database management scripts...something that could be plugged in to a homegrown CMS to provide easy management of those other tables that must be dealt with? Basically something where you can define a schema, and it will produce the pages/forms to browse, edit, add, delete, etc. I've got one that I've been using for years which is kludgy and limited, but gets the job done...I was thinking about writing a new one, but I wanted to see what is out there first. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242062 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Generic database management tool
A lot of people rave about Doug Hughe's Reactor. I've never used it (although I mean to some day), but I think it does what I believe you are looking for. -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Friday, June 02, 2006 9:47 AM Is anyone out there using any kind of generic database management scripts...something that could be plugged in to a homegrown CMS to provide easy management of those other tables that must be dealt with? Basically something where you can define a schema, and it will produce the pages/forms to browse, edit, add, delete, etc. I've got one that I've been using for years which is kludgy and limited, but gets the job done...I was thinking about writing a new one, but I wanted to see what is out there first. This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242065 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
On Friday 02 June 2006 17:05, Munson, Jacob wrote: A lot of people rave about Doug Hughe's Reactor. I've never used it (although I mean to some day), but I think it does what I believe you are looking for. Reactor is a data layer you can build things on top of. I think Jim is after something that will auto-build a view layer as well. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. We are pleased to announce that Halliwells LLP has been voted AIM Lawyer of the Year at the 2005 Growth Company Awards ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242067 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
Sounds like Jim's after something kinda plum(ish) to me, unless I'm reading it wrong. www.productivityenhancement.com --Ferg Tom Chiverton wrote: On Friday 02 June 2006 17:05, Munson, Jacob wrote: A lot of people rave about Doug Hughe's Reactor. I've never used it (although I mean to some day), but I think it does what I believe you are looking for. Reactor is a data layer you can build things on top of. I think Jim is after something that will auto-build a view layer as well. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242068 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
Reactor is a data layer you can build things on top of. I think Jim is after something that will auto-build a view layer as well. Exactly...if I decide to build a new one, I may look at using Reactor as the data layer. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242069 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
On 6/2/06, Ken Ferguson [EMAIL PROTECTED] wrote: Sounds like Jim's after something kinda plum(ish) to me, unless I'm reading it wrong. www.productivityenhancement.com --Ferg Plum looks interesting, but it is more complicated than what I'm currently looking for. What I want is something that does for database editing what CFFM does for file management. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242070 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
Not sure if this is quite what you're looking for, but I use Navicat for my MySQL db management -- it's super dynamite! http://www.navicat.com $99 for Windows standard, it's a bargain. Does data transfer, automated backups, import/export, much more. -- Josh - Original Message - From: Jim Wright [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, June 02, 2006 9:41 AM Subject: Re: Generic database management tool On 6/2/06, Ken Ferguson [EMAIL PROTECTED] wrote: Sounds like Jim's after something kinda plum(ish) to me, unless I'm reading it wrong. www.productivityenhancement.com --Ferg Plum looks interesting, but it is more complicated than what I'm currently looking for. What I want is something that does for database editing what CFFM does for file management. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242072 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
If I'm not mistaken, joe's model-glue 2.0 unity framework will be entering beta soon. That has scaffolding of create/edit/delete/list interfaces for objects in the database (and uses reactor for the data layer by default). That might worth researchign more, though I don;t think it's publicly avaliable yet. Doug On 6/2/06, Josh Nathanson [EMAIL PROTECTED] wrote: Not sure if this is quite what you're looking for, but I use Navicat for my MySQL db management -- it's super dynamite! http://www.navicat.com $99 for Windows standard, it's a bargain. Does data transfer, automated backups, import/export, much more. -- Josh - Original Message - From: Jim Wright [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, June 02, 2006 9:41 AM Subject: Re: Generic database management tool On 6/2/06, Ken Ferguson [EMAIL PROTECTED] wrote: Sounds like Jim's after something kinda plum(ish) to me, unless I'm reading it wrong. www.productivityenhancement.com --Ferg Plum looks interesting, but it is more complicated than what I'm currently looking for. What I want is something that does for database editing what CFFM does for file management. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242079 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
Is anyone out there using any kind of generic database management scripts...something that could be plugged in to a homegrown CMS to provide easy management of those other tables that must be dealt with? Basically something where you can define a schema, and it will produce the pages/forms to browse, edit, add, delete, etc. I've got one that I've been using for years which is kludgy and limited, but gets the job done...I was thinking about writing a new one, but I wanted to see what is out there first. When you say, define a schema do you mean you want the tool to build the database for you as well? Or do you want a tool that you can point at an existing database that will examine its schema and give you a forms interface to it? Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242093 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
Or do you want a tool that you can point at an existing database that will examine its schema and give you a forms interface to it? This is what Plum does. Respectfully, Adam Phillip Churvis Certified Advanced ColdFusion MX 7 Developer BlueDragon Alliance Founding Committee Get advanced intensive Master-level training in C# ASP.NET 2.0 for ColdFusion Developers at ProductivityEnhancement.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242099 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
When you say, define a schema do you mean you want the tool to build the database for you as well? Or do you want a tool that you can point at an existing database that will examine its schema and give you a forms interface to it? Neither...assume the database is created, and I want a quick way to put up a form to edit a particular table. Right now, I have some scripts where I can define in a configuration file -the table I want to edit -a list of fields that should be shown in the list view -the fields that should be edited in the form view, and what type of field each is (which determines what type of form control to use, and simple validation) -labels that should be used for the fields above So then it provides and easy and quick interface to manage a table. This is usually used in the admin section of my homegrown CMS to manage tables which don't need much in the way of a pretty interface, but just need a quick and dirty way to edit data. I was planning on modifying this to include things like: -more complicated validation -sorting and filtering of the list view -paging through n records in the list view But I wanted to find out if anyone knew of anything similar out there, as I don't want to reinvent the wheel. -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242108 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
On 6/2/06, Jim Wright [EMAIL PROTECTED] wrote: -the table I want to edit -a list of fields that should be shown in the list view -the fields that should be edited in the form view, and what type of field each is (which determines what type of form control to use, and simple validation) -labels that should be used for the fields above Heh. I just whipped up something like this using the livegrid demo from openrico. I'm really loving that livegrid. The live search is really handy, and colum sorting etc.. Plus it does a nice fade from the list to the record. Heh. Gotta love those transitions. And it saves via ajax! O ;-) Still pretty ugly/customized, but I'm gonna post the code sometime... probably... *cough* -more complicated validation -sorting and filtering of the list view -paging through n records in the list view This is where the livegrid shines (not he validation, the other two). Really that's all I was trying out, the rest is pretty weak, but if you'd like to combine them (assuming you wrote the thing you're using), I can replace your list code with a livegrid, which is pretty slick. The livegrid is still in beta, and does leak memory, but I've found it takes a really long time to crash a browser, and it's handy enough I don't mind it one bit. Haven't checked openrico or the new 2.0 version, so maybe the memory issue has been addressed since I started playing with it. At any rate, woot! for more interactive stuff. :d ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242178 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
Is anyone out there using any kind of generic database management scripts. I have something like that presently on the back burner. It is called ODBCMyAdmin, although the name might change since is also handles JDBC databases now. The basic idea is PHPMyAdmin, although more powerful, written in CF and can handle any ODBC or JDBC datasource. The main features are: - All writen in CF and Javascript, compatible with IE. - 100% compatible CF 5 and CFMX, ODBC and JDBC; - all tables and column names drown from the datasource itself: no name to type; - can produce CFQUERY code for SELECT, INSERT, UPDATE DELETE on any table; - can generate CFQURYPARAM automatically, based on column types on request; - can produce a FORM using any fields on any table; some fields may be SELECT with options generated from any other table; all field length and maxlength suggested by default from info from the table specs in the datasource. - advanced query buider à la Access, with all types of JOINS, GROUP, WHERE, HAVING etc. clauses; even UNIONs are supported (not in Access) - Browse all tables, columns, queries; - direct acces to the tool from CF Studio; ALL above without using any key on your keyboard, only the mouse. - add, edit, delete columns in any table; - add, edit, delete indexes in any table; - add, edit, delete tables in any datasource; - and of course much more ! ;-) I use it a lot for myself; my only problem before I can release it are 1º time to finish testing and document it; 2º some native speaking fellow, fluent in French, who would help me with the docs and online help. May be some work for long nights, next winter... -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242192 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Generic database management tool
There is also a cfmyadmin. I don/t remember the addy, but if you google cfmyadmin, you will find it. It's basically the cf version of phpmyadmin Eric -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, 02 June 2006 20:54 To: CF-Talk Subject: Re: Generic database management tool Is anyone out there using any kind of generic database management scripts. I have something like that presently on the back burner. It is called ODBCMyAdmin, although the name might change since is also handles JDBC databases now. The basic idea is PHPMyAdmin, although more powerful, written in CF and can handle any ODBC or JDBC datasource. The main features are: - All writen in CF and Javascript, compatible with IE. - 100% compatible CF 5 and CFMX, ODBC and JDBC; - all tables and column names drown from the datasource itself: no name to type; - can produce CFQUERY code for SELECT, INSERT, UPDATE DELETE on any table; - can generate CFQURYPARAM automatically, based on column types on request; - can produce a FORM using any fields on any table; some fields may be SELECT with options generated from any other table; all field length and maxlength suggested by default from info from the table specs in the datasource. - advanced query buider à la Access, with all types of JOINS, GROUP, WHERE, HAVING etc. clauses; even UNIONs are supported (not in Access) - Browse all tables, columns, queries; - direct acces to the tool from CF Studio; ALL above without using any key on your keyboard, only the mouse. - add, edit, delete columns in any table; - add, edit, delete indexes in any table; - add, edit, delete tables in any datasource; - and of course much more ! ;-) I use it a lot for myself; my only problem before I can release it are 1º time to finish testing and document it; 2º some native speaking fellow, fluent in French, who would help me with the docs and online help. May be some work for long nights, next winter... -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242201 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generic database management tool
Claude Schneegans wrote: - All writen in CF and Javascript, compatible with IE. That's an unfortunate restriction. - direct acces to the tool from CF Studio; CF What? ;) ALL above without using any key on your keyboard, only the mouse. Mice are overrated. =) I use keyboard shortcuts all the time. I'll probably use one to send this message rather than click Send. - add, edit, delete columns in any table; - add, edit, delete indexes in any table; - add, edit, delete tables in any datasource; That's where the generic part gets hard because of the differences in column types from database to database. It's hard to be generic and yet more powerful. May be some work for long nights, next winter... All things considered, I'd still like to see it when and if you do get around to releasing it. Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242203 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54