Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I apologise if this might be a little off topic, but it's too big to fit as a comment, so advance warning, if others don't think it helps the topic I'll delete it.</p> <p>A key question is if <strong>you and your application own</strong> and are the <strong>only client</strong> that accesess the database.</p> <p>If you need to work around an existing database, then out of the block, generating the database from the Model is probably out of the question.</p> <p>If created by your system or not, it will be accessed by other systems (which means you can't just randomly change the database to implement logic, or even more extreme, other fields/tables might be added to faciliate the 3rd party applications), then you need to think about what workflows will allow you to abstract the database details from your implementation to prevent you having to do major rewrites.</p> <p>These requirements might change throughout the projects lifespan, as you might start off as the sole consumer and in the future other applications might access the same database directly. This might be where you have a "Entity Based" workflow as you call it, where you have a layer that represents the actual DB tables, and a Models that represents your data used in your system are abstracted from any changes to these.</p> <p>And sometimes needs change, thus the ORM and workflow you use should be mindful and at least partially capable of surviving in a future that might be out of your hands. Imagine an enterprise (aka political) environment. One day a DBA turns up and says, "all data access is now through SPROCs". These type of situations push you towards the "Mapping" as you called it.</p>
    singulars
    1. This table or related slice is empty.
    1. POWhich ORMs Support which workflow styles
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USJames Harris
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

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