Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. The Hardest Part

The Hardest Part

Scheduled Pinned Locked Moved The Lounge
databasedesignxml
7 Posts 7 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • R Offline
    R Offline
    realJSOP
    wrote on last edited by
    #1

    ... of designing an app that has a significant and complex database back-end is coming up with a usable, yet maintainable schema... The next hardest part is presenting a UI that wraps the schema in a way that makes sense to joe-blow-idiot end user, and doesn't impede usability. Aurther C. Clark was right - "Any sufficiently advanced technology is indistinguishable from magic."

    ".45 ACP - because shooting twice is just silly" - JSOP, 2010
    -----
    You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
    -----
    When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

    G K L J L 6 Replies Last reply
    0
    • R realJSOP

      ... of designing an app that has a significant and complex database back-end is coming up with a usable, yet maintainable schema... The next hardest part is presenting a UI that wraps the schema in a way that makes sense to joe-blow-idiot end user, and doesn't impede usability. Aurther C. Clark was right - "Any sufficiently advanced technology is indistinguishable from magic."

      ".45 ACP - because shooting twice is just silly" - JSOP, 2010
      -----
      You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
      -----
      When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

      G Offline
      G Offline
      Gary Wheeler
      wrote on last edited by
      #2

      John Simmons / outlaw programmer wrote:

      "Any sufficiently advanced technology is indistinguishable from magic."

      I always liked the Engineer's Corollary to Clarke's Law: "Any developer of sufficiently advanced technology is indistinguishable from a magician."

      Software Zen: delete this;

      1 Reply Last reply
      0
      • R realJSOP

        ... of designing an app that has a significant and complex database back-end is coming up with a usable, yet maintainable schema... The next hardest part is presenting a UI that wraps the schema in a way that makes sense to joe-blow-idiot end user, and doesn't impede usability. Aurther C. Clark was right - "Any sufficiently advanced technology is indistinguishable from magic."

        ".45 ACP - because shooting twice is just silly" - JSOP, 2010
        -----
        You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
        -----
        When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

        K Offline
        K Offline
        KarstenK
        wrote on last edited by
        #3

        The art of database storage is to keep it simple and renundant. Raw data should be stored as raw as it gets in. Every processing should do the app. Be consequent in separate processing code and UI code. I had to re-write a lot because of that problems. Our coming project will have a shot with the MVVM architecture. I am fine with that because I am NOT the lead programmer. :cool:

        Press F1 for help or google it. Greetings from Germany

        1 Reply Last reply
        0
        • R realJSOP

          ... of designing an app that has a significant and complex database back-end is coming up with a usable, yet maintainable schema... The next hardest part is presenting a UI that wraps the schema in a way that makes sense to joe-blow-idiot end user, and doesn't impede usability. Aurther C. Clark was right - "Any sufficiently advanced technology is indistinguishable from magic."

          ".45 ACP - because shooting twice is just silly" - JSOP, 2010
          -----
          You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
          -----
          When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

          L Offline
          L Offline
          Lost User
          wrote on last edited by
          #4

          John Simmons / outlaw programmer wrote:

          joe-blow-idiot end user

          Does not sound like the kind of user that is proficient in SQL :rolleyes:

          Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

          1 Reply Last reply
          0
          • R realJSOP

            ... of designing an app that has a significant and complex database back-end is coming up with a usable, yet maintainable schema... The next hardest part is presenting a UI that wraps the schema in a way that makes sense to joe-blow-idiot end user, and doesn't impede usability. Aurther C. Clark was right - "Any sufficiently advanced technology is indistinguishable from magic."

            ".45 ACP - because shooting twice is just silly" - JSOP, 2010
            -----
            You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
            -----
            When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

            J Offline
            J Offline
            jschell
            wrote on last edited by
            #5

            If it is complex enough that the experienced designer has concerns with implementation design then using formal designs such as architecture with a minimal data model would seem to be warranted.

            1 Reply Last reply
            0
            • R realJSOP

              ... of designing an app that has a significant and complex database back-end is coming up with a usable, yet maintainable schema... The next hardest part is presenting a UI that wraps the schema in a way that makes sense to joe-blow-idiot end user, and doesn't impede usability. Aurther C. Clark was right - "Any sufficiently advanced technology is indistinguishable from magic."

              ".45 ACP - because shooting twice is just silly" - JSOP, 2010
              -----
              You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
              -----
              When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

              L Offline
              L Offline
              ledtech3
              wrote on last edited by
              #6

              You must also remember. "Never Trust user input" always validate what they are inputting.

              1 Reply Last reply
              0
              • R realJSOP

                ... of designing an app that has a significant and complex database back-end is coming up with a usable, yet maintainable schema... The next hardest part is presenting a UI that wraps the schema in a way that makes sense to joe-blow-idiot end user, and doesn't impede usability. Aurther C. Clark was right - "Any sufficiently advanced technology is indistinguishable from magic."

                ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                -----
                You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                -----
                When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

                P Offline
                P Offline
                PIEBALDconsult
                wrote on last edited by
                #7

                Design from the top down (with user input). Implement from the bottom up.

                1 Reply Last reply
                0
                Reply
                • Reply as topic
                Log in to reply
                • Oldest to Newest
                • Newest to Oldest
                • Most Votes


                • Login

                • Don't have an account? Register

                • Login or register to search.
                • First post
                  Last post
                0
                • Categories
                • Recent
                • Tags
                • Popular
                • World
                • Users
                • Groups