From: Jerry Schwartz (jschwartzthe-infoshop.com)
Date: Thu Jul 31 2008 - 11:14:24 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

>-----Original Message-----
>From: Martijn Tonies [mailto:m.toniesupscene.com]
>Sent: Thursday, July 31, 2008 10:37 AM
>To: mysqllists.mysql.com
>Subject: Re: Re-arranging fields
>
>> >> [JS] I added a dozen or so columns for a special purpose, and
>although
>> >MySQL
>> >> doesn't care I wanted them in a certain order that would be
>intuitive
>> >to a
>> >> user / programmer.
>> >
>> >Why is a user looking at your database?
>> >
>> >This is a security breach. Users should only have access thru
>> >pre-defined SQL statements.
>> >
>> [JS] Users will have read-only access through MS Access, and have to
>filter
>> on various fields.
>>
>> If we weren't trying to make our database designs somewhat intuitive,
>we'd
>> name all of our fields x1, x2, x3 ....
>
>There's actually companies that do -almost- just that.
>
[JS] I've had to work with programs written like that, and cursed the
original author most soundly. Personally, I don't mind the extra typing to
give things suggestive names. It's been a very long time since I had to
worry about the size of a symbol table.

>Either way, the -order- has nothing to do with readable names. If you
>filter
>on fields, can't you order the list to filter on? Or do you simply fetch
>them from
>the db and that's that?
>
[JS] Typically I just have them link to the table and "filter by form". Then
they usually copy and paste into an Excel spreadsheet.
>
>Martijn Tonies
>Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB,
>Oracle &
>MS SQL Server
>Upscene Productions
>http://www.upscene.com
>My thoughts:
>http://blog.upscene.com/martijn/
>Database development questions? Check the forum!
>http://www.databasedevelopmentforum.com
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=jschwartzthe-
>infoshop.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]