Re: [WebDNA] db admin tool

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 101476
interpreted = N
texte = It would be nice if this was done by convention and not configuration. For example, a products.db with fields id, maker_id and description would mean that maker_id refers to maker.db and the field id. This is a rails idiom and works nicely. It would mean all those non-conforming legacy databases would need renaming. I think of convention as everyone driving on the right side of the road. A lot of people go to work that way, but not race car drivers. They burn a lot of fuel to drive in a circle. On Wed, Nov 19, 2008 at 8:32 PM, Kenneth Grome wrote: >> Because there is no mechanism for structuring key fields >> and relationships between databases, it would be a huge >> task to write something that would figure all that out >> automatically. > > The tool doesn't have to figure it out automatically, the > user can simply define these relationships the first time > it is used, and at any other time he feels like it. Then > the key fields and relationships (and other operating > parameters) can be stored in a toolprefs.db file for use > again later. > >> I actually started building a modern, ajax driven db >> admin tool that is much more powerful than the one built >> in the 90s. Essentially it does everything you need =96 >> create a db, edit a db, remove fields, add fields, add >> records, remove records, edit records, search, delete db, >> backup dbs, restore dbs, etc. > > I did this many years ago too (not in ajax though) and I > think I called it Ken's DB Admin. It did everything you > mentioned here and more -- including moving fields around > into different positions so you could change the field > order dynamically any time you felt like it ... :) > > But I used cookies to store the control parameters instead > of storing them in a separate preference file, and later I > learned that cookies aren't the best way to store this > data. Somehow they created an unusual situation where a > user would have to delete them to continue using the tool. > > I never figured out why this happens but if I were to > rebuild it I would most definitely use a prefs file. But > back in the 90's I was determined to make this tool a "one > file" solution so I used cookies to avoid the need for any > additional files. > > ------------------------ > > There's an important issue here that makes this kind of a > tool dangerous to use in some situations too unless you're > aware of it. I only learned this after I had finished > coding my db admin tool: > > When a db contains encrypted data you cannot edit that field > without screwing up that record or possibly trashing the > entire db. So if you use this kind of webdna tool you must > limit its editing use to only those fields that contain > non-encrypted data. > > Naturally the tool could be built to disable editing of > encrypted fields, but it cannot figure out which fields are > encrypted all by itself, so this is an important setting > the user must make in the prefs before the tool will > function properly -- just like setting the name of > the "sku" field in each db so it knows which field contains > a unique value in each record. > > > Sincerely, > Ken Grome > > > > > > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] db admin tool (Kenneth Grome 2008)
  2. Re: [WebDNA] db admin tool (Donovan Brooke 2008)
  3. Re: [WebDNA] db admin tool (Patrick McCormick 2008)
  4. Re: [WebDNA] db admin tool (Patrick McCormick 2008)
  5. Re: [WebDNA] db admin tool ("William DeVaul" 2008)
  6. Re: [WebDNA] db admin tool (Kenneth Grome 2008)
  7. RE: [WebDNA] db admin tool ("Olin Lagon" 2008)
  8. RE: [WebDNA] db admin tool ("Michael A. DeLorenzo" 2008)
  9. Re: [WebDNA] db admin tool (Donovan Brooke 2008)
  10. Re: [WebDNA] db admin tool (Gary Krockover 2008)
  11. [WebDNA] db admin tool (Patrick McCormick 2008)
It would be nice if this was done by convention and not configuration. For example, a products.db with fields id, maker_id and description would mean that maker_id refers to maker.db and the field id. This is a rails idiom and works nicely. It would mean all those non-conforming legacy databases would need renaming. I think of convention as everyone driving on the right side of the road. A lot of people go to work that way, but not race car drivers. They burn a lot of fuel to drive in a circle. On Wed, Nov 19, 2008 at 8:32 PM, Kenneth Grome wrote: >> Because there is no mechanism for structuring key fields >> and relationships between databases, it would be a huge >> task to write something that would figure all that out >> automatically. > > The tool doesn't have to figure it out automatically, the > user can simply define these relationships the first time > it is used, and at any other time he feels like it. Then > the key fields and relationships (and other operating > parameters) can be stored in a toolprefs.db file for use > again later. > >> I actually started building a modern, ajax driven db >> admin tool that is much more powerful than the one built >> in the 90s. Essentially it does everything you need =96 >> create a db, edit a db, remove fields, add fields, add >> records, remove records, edit records, search, delete db, >> backup dbs, restore dbs, etc. > > I did this many years ago too (not in ajax though) and I > think I called it Ken's DB Admin. It did everything you > mentioned here and more -- including moving fields around > into different positions so you could change the field > order dynamically any time you felt like it ... :) > > But I used cookies to store the control parameters instead > of storing them in a separate preference file, and later I > learned that cookies aren't the best way to store this > data. Somehow they created an unusual situation where a > user would have to delete them to continue using the tool. > > I never figured out why this happens but if I were to > rebuild it I would most definitely use a prefs file. But > back in the 90's I was determined to make this tool a "one > file" solution so I used cookies to avoid the need for any > additional files. > > ------------------------ > > There's an important issue here that makes this kind of a > tool dangerous to use in some situations too unless you're > aware of it. I only learned this after I had finished > coding my db admin tool: > > When a db contains encrypted data you cannot edit that field > without screwing up that record or possibly trashing the > entire db. So if you use this kind of webdna tool you must > limit its editing use to only those fields that contain > non-encrypted data. > > Naturally the tool could be built to disable editing of > encrypted fields, but it cannot figure out which fields are > encrypted all by itself, so this is an important setting > the user must make in the prefs before the tool will > function properly -- just like setting the name of > the "sku" field in each db so it knows which field contains > a unique value in each record. > > > Sincerely, > Ken Grome > > > > > > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > "William DeVaul"

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Bug when including a db file & [platform] (2000) WebCatalog vs. Cold Fusion (1998) Error Lob.db records error message not name (1997) Clean Code: Rules for inserting keyboard returns? (1997) Add a field to the error log? (1997) Secure Server (1999) turning every 5th line red (1998) Can you do this??? and other stuff (1997) WenDNA infinite loops (1 issue solved) (2004) [OT] HTML TAB CODE (2002) Re:Help name our technology! (1997) auction system w/ Web Cat (1999) RE: protect tag not working (1998) Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997) [WebDNA] Search comparisons in 8.6.1 (2019) Cart questions (1997) CMSBuilder (2004) Linux Beta4 Problem (2000) RE: New WebCatalog Version !!! (1997) The beginning (1997)