Re: [WebDNA] db admin tool
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 101478
interpreted = N
texte = --Apple-Mail-3--258680726 Content-Type: text/plain; charset=WINDOWS-1252; format=flowed; delsp=yes Content-Transfer-Encoding: quoted-printable But convention becomes something that infringes on the efficient =20 freedom inherent in WebDNA. Although it would make administrative tasks easier, the additional =20 restrictions and things you'd have to remember would probably be an =20 expensive trade-off, especially if you were dependent on the admin =20 tool at all. On Nov 19, 2008, at 8:25 PM, William DeVaul wrote: > 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
=20= > 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/ >> > --------------------------------------------------------- > 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/ --Apple-Mail-3--258680726 Content-Disposition: attachment; filename=smime.p7s Content-Type: application/pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGGTCCAtIw ggI7oAMCAQICEBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkEx JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA4MDkyNzAxMTg1M1oXDTA5MDkyNzAxMTg1 M1owPjEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEbMBkGCSqGSIb3DQEJARYMcG1A d2ViZG5hLnVzMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAtb7ZYYJV7sbgqxdgpBU/ qCRsIJYGNIo40L9odKmo6Y/mPBybeSry8KefqmuWoBXxc6xCvSSJDWFcb2sZ+TkedZrdxvtoL1pH NjDZNe2ow+RCNUvJcQd1+ASzh0J4QLHnNyoMY3zuCQwqM6hK5gU4AlpOSITekksSFuGXBdJTjSeI gIpZFTTrd1c/Zv7miT9gO5UmHiyDClKP8oX31YFlb3q9EM2p8WQzb2Ce2M9kokCs8ZnhT+fRNc/Q 9lc4RJtEuf3zynvg0cCbf71pgoC0Zepsop466jrvc08MsxxzRJDmjw20ci/3ltk+iAcD3TchYppw yX4HZhjrrZXcOMBMkQIDAQABoykwJzAXBgNVHREEEDAOgQxwbUB3ZWJkbmEudXMwDAYDVR0TAQH/ BAIwADANBgkqhkiG9w0BAQUFAAOBgQCBMxqOGsLwOxtLQ8YLvOQOym8UQyB0CiF0Dpd0oOA+hjD5 n9A1eileTd8OdkdPIb+der2Kw42N/UKARNSSkmn1hhKrgwTNYLyXFNlB+TJ2YvG13B27d4EaUdSn 2KWKDKG4w14lQSO9y+RTjMSuYi4kbeI50QHLZsTZDO3OhNcKjzCCAz8wggKooAMCAQICAQ0wDQYJ KoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNV BAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRp ZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVl bWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw0w MzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3 dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1h aWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKY8VXNV+065yplaHmjA dQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7dyfArhVqqP3FWy688Cwfn 8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUPSAR/p7bRPGEEQB5kGXJgt/sC AwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9j cmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWlsQ0EuY3JsMAsGA1UdDwQEAwIBBjAp BgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0xMzgwDQYJKoZIhvcNAQEFBQAD gYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYfqi2fNi/A9BxQIJNwPP2t4WFiw9k6 GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa9/eH1sYITq726jTlEBpbNU1341Yh eILcIRk13iSx0x1G/11fZU8xggMQMIIDDAIBATB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxU aGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJl ZW1haWwgSXNzdWluZyBDQQIQGa+8CDkvo9yUTyu7Cj+AxjAJBgUrDgMCGgUAoIIBbzAYBgkqhkiG 9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wODExMjAwNDUwMjJaMCMGCSqGSIb3 DQEJBDEWBBRvRixwCl+o4FcVFYmk6l6sbJv8HjCBhQYJKwYBBAGCNxAEMXgwdjBiMQswCQYDVQQG EwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhh d3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBmvvAg5L6PclE8ruwo/gMYwgYcGCyqG SIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcg KFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EC EBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEBBQAEggEAlJgyvb+5u2t4QP4Ppg8gj2z+nrTo iNB4Lt8gjzSU1QRQ5BWnXQE0kK7C7jRz3z5Y7yU5yu3H9NnUgJCXN3v8IDPn5t7WKtbfztwjQMNM 5W3DPgjfALuSCj6pYKZOHOEq1BcuOanuba0b7vuolLNyNToEzS4lDrQqvoX9l+NfYiq3MAAt5C6q jE9mhP2gkRojM6J4bV/rgZO4U2Fbhwy8LKau6poJ4tTG6Wu6grOoRuFAW+UfLqlzCH1UW4hRuQSW 8i0un1LtmZpVzlZZd6SvyF2CUVa5dvRl+s1j10KLBWTFSUovjJpIWxMXNaI73/tHR41yZTfuWUYx GeAvHzIoAQAAAAAAAA== --Apple-Mail-3--258680726--
Associated Messages, from the most recent to the oldest:
--Apple-Mail-3--258680726 Content-Type: text/plain; charset=WINDOWS-1252; format=flowed; delsp=yes Content-Transfer-Encoding: quoted-printable But convention becomes something that infringes on the efficient =20 freedom inherent in WebDNA. Although it would make administrative tasks easier, the additional =20 restrictions and things you'd have to remember would probably be an =20 expensive trade-off, especially if you were dependent on the admin =20 tool at all. On Nov 19, 2008, at 8:25 PM, William DeVaul wrote: > 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 =20= > 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/ >> > --------------------------------------------------------- > 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/ --Apple-Mail-3--258680726 Content-Disposition: attachment; filename=smime.p7s Content-Type: application/pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGGTCCAtIw ggI7oAMCAQICEBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkEx JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA4MDkyNzAxMTg1M1oXDTA5MDkyNzAxMTg1 M1owPjEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEbMBkGCSqGSIb3DQEJARYMcG1A d2ViZG5hLnVzMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAtb7ZYYJV7sbgqxdgpBU/ qCRsIJYGNIo40L9odKmo6Y/mPBybeSry8KefqmuWoBXxc6xCvSSJDWFcb2sZ+TkedZrdxvtoL1pH NjDZNe2ow+RCNUvJcQd1+ASzh0J4QLHnNyoMY3zuCQwqM6hK5gU4AlpOSITekksSFuGXBdJTjSeI gIpZFTTrd1c/Zv7miT9gO5UmHiyDClKP8oX31YFlb3q9EM2p8WQzb2Ce2M9kokCs8ZnhT+fRNc/Q 9lc4RJtEuf3zynvg0cCbf71pgoC0Zepsop466jrvc08MsxxzRJDmjw20ci/3ltk+iAcD3TchYppw yX4HZhjrrZXcOMBMkQIDAQABoykwJzAXBgNVHREEEDAOgQxwbUB3ZWJkbmEudXMwDAYDVR0TAQH/ BAIwADANBgkqhkiG9w0BAQUFAAOBgQCBMxqOGsLwOxtLQ8YLvOQOym8UQyB0CiF0Dpd0oOA+hjD5 n9A1eileTd8OdkdPIb+der2Kw42N/UKARNSSkmn1hhKrgwTNYLyXFNlB+TJ2YvG13B27d4EaUdSn 2KWKDKG4w14lQSO9y+RTjMSuYi4kbeI50QHLZsTZDO3OhNcKjzCCAz8wggKooAMCAQICAQ0wDQYJ KoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNV BAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRp ZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVl bWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw0w MzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3 dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1h aWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKY8VXNV+065yplaHmjA dQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7dyfArhVqqP3FWy688Cwfn 8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUPSAR/p7bRPGEEQB5kGXJgt/sC AwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9j cmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWlsQ0EuY3JsMAsGA1UdDwQEAwIBBjAp BgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0xMzgwDQYJKoZIhvcNAQEFBQAD gYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYfqi2fNi/A9BxQIJNwPP2t4WFiw9k6 GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa9/eH1sYITq726jTlEBpbNU1341Yh eILcIRk13iSx0x1G/11fZU8xggMQMIIDDAIBATB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxU aGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJl ZW1haWwgSXNzdWluZyBDQQIQGa+8CDkvo9yUTyu7Cj+AxjAJBgUrDgMCGgUAoIIBbzAYBgkqhkiG 9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wODExMjAwNDUwMjJaMCMGCSqGSIb3 DQEJBDEWBBRvRixwCl+o4FcVFYmk6l6sbJv8HjCBhQYJKwYBBAGCNxAEMXgwdjBiMQswCQYDVQQG EwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhh d3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBmvvAg5L6PclE8ruwo/gMYwgYcGCyqG SIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcg KFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EC EBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEBBQAEggEAlJgyvb+5u2t4QP4Ppg8gj2z+nrTo iNB4Lt8gjzSU1QRQ5BWnXQE0kK7C7jRz3z5Y7yU5yu3H9NnUgJCXN3v8IDPn5t7WKtbfztwjQMNM 5W3DPgjfALuSCj6pYKZOHOEq1BcuOanuba0b7vuolLNyNToEzS4lDrQqvoX9l+NfYiq3MAAt5C6q jE9mhP2gkRojM6J4bV/rgZO4U2Fbhwy8LKau6poJ4tTG6Wu6grOoRuFAW+UfLqlzCH1UW4hRuQSW 8i0un1LtmZpVzlZZd6SvyF2CUVa5dvRl+s1j10KLBWTFSUovjJpIWxMXNaI73/tHR41yZTfuWUYx GeAvHzIoAQAAAAAAAA== --Apple-Mail-3--258680726--
Patrick McCormick
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:
[WebDNA] SETCOOKIE (2009)
Temp DB (Was freeze) (2003)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
oops private message leaked into talk list (1997)
Nested tags count question (1997)
[WebDNA] [ipaddress] - [RealIP] - Not working properly (2016)
WebCat2 - storing unformatted date data? (1997)
tracking variables across a site... (2000)
Artwork (1997)
[convertchars] on potential malicious input even in a link? (2000)
Emailer problems. (1998)
test for John (1999)
Kaaaaahhhhhhhnnnnnnn! (1997)
Taxable Shipping (2003)
Web Developer Product Awards (1997)
Nested tags count question (1997)
Nested tags count question (1997)
encryption madness (2003)
Problems reading files created by WC (1997)
taxRate is fine but taxTotal isn't (1997)