Re: [WebDNA] db admin tool
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 101475
interpreted = N
texte = > 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=20 user can simply define these relationships the first time=20 it is used, and at any other time he feels like it. Then=20 the key fields and relationships (and other operating=20 parameters) can be stored in a toolprefs.db file for use=20 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 =E2=80=93 > 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=20 think I called it Ken's DB Admin. It did everything you=20 mentioned here and more -- including moving fields around=20 into different positions so you could change the field=20 order dynamically any time you felt like it ... :) But I used cookies to store the control parameters instead=20 of storing them in a separate preference file, and later I=20 learned that cookies aren't the best way to store this=20 data. Somehow they created an unusual situation where a=20 user would have to delete them to continue using the tool. =20 I never figured out why this happens but if I were to=20 rebuild it I would most definitely use a prefs file. But=20 back in the 90's I was determined to make this tool a "one=20 file" solution so I used cookies to avoid the need for any=20 additional files. =20 =2D----------------------- There's an important issue here that makes this kind of a=20 tool dangerous to use in some situations too unless you're=20 aware of it. I only learned this after I had finished=20 coding my db admin tool: When a db contains encrypted data you cannot edit that field=20 without screwing up that record or possibly trashing the=20 entire db. So if you use this kind of webdna tool you must=20 limit its editing use to only those fields that contain=20 non-encrypted data. Naturally the tool could be built to disable editing of=20 encrypted fields, but it cannot figure out which fields are=20 encrypted all by itself, so this is an important setting=20 the user must make in the prefs before the tool will=20 function properly -- just like setting the name of=20 the "sku" field in each db so it knows which field contains=20 a unique value in each record. Sincerely, Ken Grome
Associated Messages, from the most recent to the oldest:
> 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=20 user can simply define these relationships the first time=20 it is used, and at any other time he feels like it. Then=20 the key fields and relationships (and other operating=20 parameters) can be stored in a toolprefs.db file for use=20 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 =E2=80=93 > 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=20 think I called it Ken's DB Admin. It did everything you=20 mentioned here and more -- including moving fields around=20 into different positions so you could change the field=20 order dynamically any time you felt like it ... :) But I used cookies to store the control parameters instead=20 of storing them in a separate preference file, and later I=20 learned that cookies aren't the best way to store this=20 data. Somehow they created an unusual situation where a=20 user would have to delete them to continue using the tool. =20 I never figured out why this happens but if I were to=20 rebuild it I would most definitely use a prefs file. But=20 back in the 90's I was determined to make this tool a "one=20 file" solution so I used cookies to avoid the need for any=20 additional files. =20 =2D----------------------- There's an important issue here that makes this kind of a=20 tool dangerous to use in some situations too unless you're=20 aware of it. I only learned this after I had finished=20 coding my db admin tool: When a db contains encrypted data you cannot edit that field=20 without screwing up that record or possibly trashing the=20 entire db. So if you use this kind of webdna tool you must=20 limit its editing use to only those fields that contain=20 non-encrypted data. Naturally the tool could be built to disable editing of=20 encrypted fields, but it cannot figure out which fields are=20 encrypted all by itself, so this is an important setting=20 the user must make in the prefs before the tool will=20 function properly -- just like setting the name of=20 the "sku" field in each db so it knows which field contains=20 a unique value in each record. Sincerely, Ken Grome
Kenneth Grome
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:
I need a Smart-quote workaround (1999)
[ConvertChars] problem (1997)
Local redirects ... (2005)
Viewing Changes (1998)
Whats wrong with this code? (1998)
Problem getting shipping to calculate (2003)
[SearchString] problem with [search] context (1997)
syntax question, not in online refernce (1997)
WebCat2.0 [format thousands .0f] no go (1997)
[TaxableTotal] - not working with AOL and IE (1997)
FM and Webcat together? (1998)
Nested tags count question (1997)
Bug Report, maybe (1997)
[append] vs. [appendfile] delta + question? (1997)
mem leak: webcat (2001)
emailer (1997)
Webten + Webcat running smooth (1998)
Ticket Ordering Question (2003)
ODBC to WebCat (2000)
WebCatalog host... (2000)