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:
forming a SKU (1999)
RE: type 2 errors with ssl server (1997)
Hard Questions ? (1997)
WC1.6 to WC2 date formatting -FIXED! (1997)
Emailer Problem (1998)
Time since application launch (1999)
Selling? (2001)
WebCatalog can't find database (1997)
Tabled Discount (2003)
URGENT! ACGI Stopped!!!! (1997)
Closing Databases (1998)
fieldType=num (1997)
Smart caching problems with 2.1b3? (1997)
Webcat no longer supported? (2006)
Return records from another (1997)
New Site WebCat (1997)
Mac Vs WindowsNT (1997)
Filemaker Pro and [convertchars] (2000)
READFILE command? (1998)
Unanswered trigger questions ... (2003)