Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Personally I believe you really need to check what your requirements are.</p> <p>Due to the dynamics of how the OS of your server works it is complicated to say that everything "immediately" goes to disk even when you tell it to. certainly I know ACID techs like SQL are vulnerable to partial corruption through unfinished business and losing operations within a specific window when a single server goes down, unfortunately this is one of the problems of using a single server; you have no choice but to accept it.</p> <p>I should note that a transaction does not ensure that your server will receive the entire data before failure ( <a href="http://en.wikipedia.org/wiki/Database_transaction" rel="nofollow">http://en.wikipedia.org/wiki/Database_transaction</a> ), I mean what if the server dies part way through a transaction?</p> <p>You can perform a safe rollback based on constraints with transactions but few databases will provide the ability to continue playing the transaction unless they have already received all necessary data for it (which isn't normally the case), by which time the data might even be stale anyway.</p> <p>In fact due to the weight of some transactions and the amount of queries performed within them I reckon you might get a greater window of operational loss using transactions than you might from the 60ms write to disk window on MongoDB at times. But of course that depends upon abuse, however, just like stored procedures, this abuse is common place.</p> <p>Transactions shine on cascading deletes and typical scenarios like transferring money in a bank account, however, cascadable deletes are normally better done (as most sites do) by a cronjob with the application marking the row as deleted (to avoid the rollback of a transaction showing the deleted data back to the user again); this way you can do a lot of stuff to ensure consistency that you cannot in real-time do while the user is using your application.</p> <p>So you should really question why you need a tech and what it will succeed in doing, atm the brevity of your question tells me your not sure about your requirements completely.</p>
    singulars
    1. This table or related slice is empty.
    1. POIs there a reliable (single server) MongoDB alternative?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USSammaye
    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. VTDownMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COA crashing MongoDB instance can cause data in the database to corrupt (as in half of the operations to do are executed, since it doesn't support multidocument transactions). As far as I know this isn't possible with PostgreSQL. This is what we need.
      singulars
      1. PO
      1. USTim
    2. CO@Tim True it isn't possible if you want your speed to crawl to a point where to won't scale beyond small sites, transactions were only really designed to be used for vital mission critical procedures really.
      singulars
      1. PO
      1. USSammaye
    3. CO@Tim Basically if you use anything but transactions and someone tells you you can't get corruption cos this database can defy the laws of computing is lieing. Even with using transactions there is a small chance the transaction can be corrupted
      singulars
      1. PO
      1. USSammaye
 

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