This is handy: PHP type comparison tables.
And this is interesting: List of Parser Tokens.
Tag Archives: table
MySQL Table Locking Issues
Today reading about MySQL Table Locking Issues. Of particular interest were the HIGH_PRIORITY and SQL_BUFFER_RESULT SELECT Statement options.
Making vertical-align work for table cells
See Understanding vertical-align, or “How (Not) To Vertically Center Content”. Just in case this ever vanishes it is cached here: https://www.jj5.net/file/2018-08-09-193156/vertical-align.html
HTML <table> CSS width not working
If your table isn’t automatically adjusting to the width specified by your CSS, make sure you haven’t set display: inline-block; on the <table> element.
Administering PostgreSQL
Reply
So I found this article which said:
$ sudo -u postgres psql
postgres=> alter user postgres password 'apassword'; postgres=> create user your-user createdb createuser password 'passwd'; postgres=> create database your-db-name owner your-user; postgres=> \q
Note: to enable password logins for the ‘postgres’ admin account, edit: /etc/postgresql/9.4/main/pg_hba.conf and after this line:
local all postgres peer
Add this line:
local all postgres md5
Add Column BEFORE/AFTER another column in PostgreSQL
I wanted to add a new column to my table after the first column, like you can in MySQL. Turns out you can’t do that…
AngularJS – Sort, Filter and Paging – A Table Directive
Stumbled upon this article today: AngularJS – Sort, Filter and Paging – A Table Directive — and I’m reading it as we speak…
Align an HTML table in the center of the page
Today I found this discussion which showed how to align a table in the center of the page in HTML:
table {
width: 50%;
margin-left: auto;
margin-right: auto;
}
or:
table {
width: 200px;
margin-left: auto;
margin-right: auto;
}
MediaWiki sortable tables
A pretty nifty feature of MediaWiki tables is the class=”wikitable sortable” specification. Adding the ‘sortable’ class automatically makes the table sortable. Handy!
I’ve updated our Members table as well as a few other tables on the wiki to use the ‘sortable’ feature.