Databases
StackOverflow2013
Usersdbo
USFaddishWorm
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USFaddishWorm
    primarykey
    data
    text
    plurals
    1. PO
      singulars
      1. PTAnswer
    2. POTricky little encoding issue with PHP and emails
      singulars
      1. PTQuestion
    3. PO
      singulars
      1. PTAnswer
    1. PO.BAT file to identify 64/32 bit system
      singulars
      1. PTQuestion
    2. PO
      singulars
      1. PTAnswer
    3. POSBJson parsing help iphone
      singulars
      1. PTQuestion
    1. VO
      singulars
      1. POHow do I create a QIcon from binary data?
      1. USFaddishWorm
      1. VTFavorite
    2. VO
      singulars
      1. POtomcat java.util.logging process
      1. USFaddishWorm
      1. VTBountyStart
    3. VO
      singulars
      1. POMYSQL - Database Design Large-scale real world deployment
      1. USFaddishWorm
      1. VTFavorite
    1. CO(1) No, only some things will be kept in history - and I database those in seperate tables through tomcat. (2) No history for config data is needed. (3) Yes there is commonality, in that each system will have most of the config keys, only the values will change in the key-value pairs. (4) 100 times a second may be an over-estimate, but If I aim to satisfy that then I know the server will stand up to almost anything.
      singulars
      1. POMYSQL - Database Design Large-scale real world deployment
      1. USFaddishWorm
    2. COI have been using it for years, but I use ext2js and it isn't set up properly. I use notepad++ And debug bar to trace, if you have non-minified code you can usually see the offending javascript. Although I would love to know if there is a better way.
      singulars
      1. POWhat's an IDE for a PHP + JS(extJS) development that supports ctrl+click?
      1. USFaddishWorm
    3. COI hadn't heared of memory tables before - they sound like a great solution to keep track of the current state. The current state is a list of unique song identifiers that make up a playlist. As songs play, the playlist changes so the state changes. There are other things that make up the current state like volume level for example. These need to be accessible at all times, and will change frequently. I think it is a great idea what you have posted, in that each configuration value will have its own entry, but with posttime as part of the primary key, is it possible to still do updates?
      singulars
      1. PO
      1. USFaddishWorm
 

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