All you need to know is on the date documentation…
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…
Reading about date/time support in PostgreSQL…
Today I needed to figure out how to read some data from a URL that required HTTP Basic Auth. The solution was pretty simple, use file_get_contents and pass in a configured stream context. I found the following code on the stream_context_create documentation:
$cred = sprintf( 'Authorization: Basic %s', base64_encode( 'username:password' ) ); $opts = array( 'http' => array( 'method' => 'GET', 'header' => $cred ) ); $ctx = stream_context_create( $opts ); $data = file_get_contents( $url, false, $ctx );
I just bumped heads with a really gnarly problem. In fact it’s a miracle that I stumbled upon the solution, it could have gone unseen for a long time!
The root of the problem was that I used XHTML syntax in a HTML5 document, and I didn’t get what I expected. I’m still getting used to HTML5 and my understanding was that HTML5 was a superset of HTML4 and XHTML with some extensions. As such I expected XHTML syntax to be supported by HTML5 — but, not so!
I was trying to refactor my AngularJS app to use partial views that were embedded in <script> tags with the type ‘text/ng-template’ and an associated ID.
On my way I found this article on StackOverflow which said:
make sure that the inline script tags are children of the element that has the ng-app=”myApp” attribute.
That was actually a problem I had to solve, I think, because I’d put the ng-app directive on the <html> element not the <body> element. But things still weren’t working and my code looked like this:
So… have you spotted the problem? It’s a tricky one… the problem is with the ‘<div ng-view />’ element. This is being parsed as an open <div> with no closing </div> in HTML5. In XHTML this would be an opened and closed element. In HTML5 it’s ignoring the ‘/>’ and just opening a <div>! Hah! So the <script> partials are children on this <div> and not of the ng-app container, so they’re not being found by Angular!
The solution is now trivial. Just make sure we open and close our ng-view <div> like this:
Stumbled upon this article today: AngularJS – Sort, Filter and Paging – A Table Directive — and I’m reading it as we speak…
To create a database and user account for use on PostgreSQL:
root@devotion:~# su - postgres postgres@devotion:~$ psql psql (8.4.21) Type "help" for help. postgres=# create user "www-data" superuser; CREATE ROLE postgres=# create database mydb with owner "www-data"; CREATE DATABASE postgres=# \c mydb psql (8.4.21) You are now connected to database "mydb". ^ mydb=# alter user "www-data" with password 'secret'; ALTER ROLE