Back-end to Front-end: a SQL developer’s perspective

More SQL than Python-related, but in fact the immediate inspiration came from this month’s PyMag, which is a bit database-oriented. In his article on good practice in database design, Brian Jones touches on an issue which I’ve felt many times before. There are, let us say, two kinds of developer: those who are primarily interested in the front-end and for whom a database is merely a convenient back-end store; and those who are primarily interested in the data, and for whom any front-end is merely a means to view that data. Obviously I’m polarising the positions here, but it’s surprising how often you can look at a third-party app and get an idea of which camp its developers belong to.

I style myself a database developer. This doesn’t mean I despise front-ends and prefer to look, Neo-like, at streams of data falling in green down my screen. (Although sometimes…) Rather, it means that I’m much more concerned about the data structures and their interactions at the database level, and keen that the UI do a good service by the data. This may of course reflect my almost complete lack of visual design flair: the best thing you can say about my interfaces is that they are workmanlike and competent, conforming as far as possible to established UI guidelines. They certainly don’t have any kind of panache.

To some extent this also reflects in my slowness to take up the various ORMs on offer, although I have recently started using Elixir for a personal project, and found it very workable. In general, though, I prefer my data raw, not cooked, and the typical examples of ORMs tend to be aimed at people who find data a bit of an embarrassment and want to get it out of the way as quickly as possible :)

3 Comments so far »

  1. richard rabins said,

    Wrote on March 17, 2008 @ 3:13 am

    I have to violently agree with you:)

    Let me explain.

    we make a product called Alpha Five www.alphasoftware.com which is a RAD tool for building web (including ajax) and desktop database apps quickly against any SQL database - BUT our tool is only as good as the underlying database structure.

    If the effort is not put into getting the data structures right - even the best front end/IDE/RAD tool in the world - is not going to be that useful.

    Bottom - line - Put in the effort to think through the data structures upfront. If you do that your app development projects will be able to benefit from the really potent front end tools that are emerging. If you dont first focus on the data structures - then all bets are off.

    btw the first 5 developers who email me at richard@alphasoftware.com will be entitled to a NO charge copy of Alpha Five v8 (retails for $349)

  2. Nandprasad Joshi said,

    Wrote on May 28, 2008 @ 3:16 am

    Hi, i just wanna check is there any difference between Oracle Backend Development and SQL Backend Development. I am a recuiter needs to find people on SQL Developer. Please guide me what exactly i must see with one for this typical technical skill (SQL Developer)

    Please guide me……

    Thanks

    Nand Joshi
    +6592387626

  3. Karunakar Rao.Y said,

    Wrote on August 29, 2008 @ 4:14 am

    I want clarification about front-end-tool and back-end-tool in dataware housing

Comment RSS · TrackBack URI

Leave a Comment

OpenID

Sign in with your OpenID ?

Anonymous

Name: (Required)

E-mail: (Required)

Website:

Comment: