Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The fact that you're interested in <strong>low level</strong> control from <strong>the backend</strong> at <strong>run time</strong> is probably a show-stopper, unless you can accept lots of lag.</p> <p>It takes a lot longer to communicate between the server and client in the web world. In a desktop, the lags are not worthy of measurement, but on the web, with HTTP requests, the delays are real, highly variable and potentially UX-destroying. </p> <ol> <li>Client notices a user click and calls out to let the server know (+50-500ms to transfer)</li> <li>Server finds out, issues an instruction to animate a triangle (+100ms to process) (+50ms-500ms to transfer) </li> <li>Client gets instruction, animates triangle (<strong>user perceived lag: 200ms to 1100ms</strong>)</li> </ol> <p>So... I'm not sure the <em>exact</em> architecture you're thinking of is feasible on the web. </p> <p>If you revisit your assumptions a little, your options grow quite a bit. Removing the requirement to make roundtrips all the way to the backend for the application logic, for instance, would be very liberating. Try this interpretation of the desktop paradigm on for size:</p> <ul> <li>X-Windows &rarr; <em>The browser rendering engine (lowest level API, equivalent to hardware)</em></li> <li>WPF &rarr; <em>SVG, Raphael, jQueryUI etc. (higher level drawing APIs)</em></li> <li>C# application logic &rarr; <em>Client-side JS logic (<a href="https://developer.mozilla.org/en/Introduction_to_Object-Oriented_JavaScript" rel="nofollow">OOP style</a>)</em></li> <li>File system &rarr; <em>Web Server with DB</em></li> </ul> <p>Interesting question!</p>
    singulars
    1. This table or related slice is empty.
    1. POX Windows-esque JS UI Client
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USpeteorpeter
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POX Windows-esque JS UI Client
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTBountyClose
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COWell, you've got some solid points there. I really want the ability to avoid needing to code JS to make it all go (other than a base client that does some connections) because I've tried OOP style JS at least somewhat and I miss my C#. :D Also, it's much nicer from a security side to have a true thin client. However, if nobody else can come up with something better in a couple days, I think the points should go to you. By the way, have you seen this? It came up since I posted: http://blogs.gnome.org/alexl/2011/03/15/gtk-html-backend-update/
      singulars
      1. PO
      1. USJ Trana
    2. COInteresting link. Like VNC except rather than spitting raster images out to the client, it spits out HTML... I hope I *don't* get any points - I'd rather see an ingenius solution than somebody whining about how it shouldn't work!
      singulars
      1. PO
      1. USpeteorpeter
    3. COAlso, if you ignore the whole "UI model on the backend" issue, and were just concerned with abstracting the HTML/CSS/JS layers, you might take a look at http://www.openlaszlo.org/ - which uses a Flex-like markup language above it all.
      singulars
      1. PO
      1. USpeteorpeter
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload