Re: [WebDNA] Can WebDNA corrupt a db?
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108065
interpreted = N
texte = I frequently cry and suck my thumb when I edit a db. It's scary, or = maybe its just my lack of confidence... The topic was about corrupting db files. I wasn't trying to imply text editors are bad and that it means = automatic failure. I started out with this method and will continue to = use this tool when necessary.=20 I personally love the webdna flat-file dbs. They are plain text files though, so in theory, there are definite = possibilities for human error when managing files manually. =20 I rebuilt a bilingual site last year that had been developed by 2 or 3 = other dna programmers in the previous years. Some databases, which were = also large, contained all sorts of data including tons of HTML markup = from both textareas and WYSIWYG editors including several special = characters. Many of the dbs and files were in different encodings as = well. To me, using a text editor or excel is an undesirable way to edit = a database like that. But I could tell it had been done previously, and = although there wasn't any obvious corruption per se, the client = complained that the database was sketchy. After converting everything = to UTF8, I replicated the problematic dbs with webdna and from that = point, everything has been working great. =20 Even if my assertions about webdna are completely wrong, why is it such = an inane suggestion to ensure consistent encodings, line endings, etc.? = Or to perhaps rebuild a db if there is any question to its integrity? Its simply my personal preference to make practice of using webdna = first, and text editors second. One of the other beauties of webnda is = that you can build db admin tools, or use something like Olin's library. = I know that some programmers here have come up with clever ways to = automatically generate the form inputs and interface for = view/append/replace/delete of records. Plus, one could use a = combination of webdna and javascript for all varieties of data = validation. Its not so much a matter of being afraid to use a text = editor, its just that great utilities can eliminate most of the need for = it. You don't have to open ftp and/or a text editor, you get a GUI, = likely save time, and you reduce the potential for human error. Since I = switched to this method, I've been able to do 99% of all db admin = through a webnda GUI, and have had zero problems with databases. I = think its a useful idea, but then again there I go with my moronic = ideas. =20 On Jan 10, 2012, at 5:19 PM, Michael A. DeLorenzo wrote: > Don't forget about the "DBAdmin" utility Olin uploaded years ago. It = works > well. I always keep it on hand just in case I need to do emergency CPR = on a > DB. >=20 > Best thing is that it's only one little file you can FTP into your DB = folder > and then delete when you are finished using it. >=20 > Mike >=20 > -----Original Message----- > From: Kenneth Grome [mailto:kengrome@gmail.com]=20 > Sent: Tuesday, January 10, 2012 12:41 PM > To: talk@webdna.us > Subject: Re: [WebDNA] Can WebDNA corrupt a db? >=20 >> I appreciate that some people are afraid to directly edit >> DB files, but it's unfair to try to scare everyone else >> out of doing so. >=20 > Agreed. =20 >=20 > I've been editing my dbs with a text editor every since I=20 > started using the software and have never had a problem. =20 >=20 > Be scared all you want, just don't tell others that they=20 > should avoid it because you lack the confidence or the=20 > ability to do it yourself. >=20 > Sincerely, > Kenneth Grome >=20 >=20 >=20 > --------------------------------------------------------- > 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 > Bug Reporting: support@webdna.us >=20 >=20 >=20 >=20 > --------------------------------------------------------- > 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 > Bug Reporting: support@webdna.us
Associated Messages, from the most recent to the oldest:
I frequently cry and suck my thumb when I edit a db. It's scary, or = maybe its just my lack of confidence... The topic was about corrupting db files. I wasn't trying to imply text editors are bad and that it means = automatic failure. I started out with this method and will continue to = use this tool when necessary.=20 I personally love the webdna flat-file dbs. They are plain text files though, so in theory, there are definite = possibilities for human error when managing files manually. =20 I rebuilt a bilingual site last year that had been developed by 2 or 3 = other dna programmers in the previous years. Some databases, which were = also large, contained all sorts of data including tons of HTML markup = from both textareas and WYSIWYG editors including several special = characters. Many of the dbs and files were in different encodings as = well. To me, using a text editor or excel is an undesirable way to edit = a database like that. But I could tell it had been done previously, and = although there wasn't any obvious corruption per se, the client = complained that the database was sketchy. After converting everything = to UTF8, I replicated the problematic dbs with webdna and from that = point, everything has been working great. =20 Even if my assertions about webdna are completely wrong, why is it such = an inane suggestion to ensure consistent encodings, line endings, etc.? = Or to perhaps rebuild a db if there is any question to its integrity? Its simply my personal preference to make practice of using webdna = first, and text editors second. One of the other beauties of webnda is = that you can build db admin tools, or use something like Olin's library. = I know that some programmers here have come up with clever ways to = automatically generate the form inputs and interface for = view/append/replace/delete of records. Plus, one could use a = combination of webdna and javascript for all varieties of data = validation. Its not so much a matter of being afraid to use a text = editor, its just that great utilities can eliminate most of the need for = it. You don't have to open ftp and/or a text editor, you get a GUI, = likely save time, and you reduce the potential for human error. Since I = switched to this method, I've been able to do 99% of all db admin = through a webnda GUI, and have had zero problems with databases. I = think its a useful idea, but then again there I go with my moronic = ideas. =20 On Jan 10, 2012, at 5:19 PM, Michael A. DeLorenzo wrote: > Don't forget about the "DBAdmin" utility Olin uploaded years ago. It = works > well. I always keep it on hand just in case I need to do emergency CPR = on a > DB. >=20 > Best thing is that it's only one little file you can FTP into your DB = folder > and then delete when you are finished using it. >=20 > Mike >=20 > -----Original Message----- > From: Kenneth Grome [mailto:kengrome@gmail.com]=20 > Sent: Tuesday, January 10, 2012 12:41 PM > To: talk@webdna.us > Subject: Re: [WebDNA] Can WebDNA corrupt a db? >=20 >> I appreciate that some people are afraid to directly edit >> DB files, but it's unfair to try to scare everyone else >> out of doing so. >=20 > Agreed. =20 >=20 > I've been editing my dbs with a text editor every since I=20 > started using the software and have never had a problem. =20 >=20 > Be scared all you want, just don't tell others that they=20 > should avoid it because you lack the confidence or the=20 > ability to do it yourself. >=20 > Sincerely, > Kenneth Grome >=20 >=20 >=20 > --------------------------------------------------------- > 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 > Bug Reporting: support@webdna.us >=20 >=20 >=20 >=20 > --------------------------------------------------------- > 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 > Bug Reporting: support@webdna.us
aaronmichaelmusic@gmail.com
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:
TCP Connect (2000)
WCS Newbie question (1997)
Extended [ConvertChars] (1997)
Moving Webcatalog folder? (2001)
PCS Frames (1997)
Mac Vs WindowsNT (1997)
problems with 2 tags shakur (1997)
vs (1997)
Database Locking?!? (2000)
WebMerchant 2.1.2 (1998)
Max connections exceeded clarification please (2002)
BUG in [showif] using ^ (contains) (1997)
sort problems....bug or brain fart? (1997)
First postarg not taking in $Commands (1997)
WebCat2 - [format thousands] (1997)
WC1.6 to WC2 date formatting (1997)
Separate SSL Server (1997)
download database (2000)
RE: includes and cart numbers (1997)
F2 to F3 rocky transition (1997)