Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
Treffynnon
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
6 ms
·
1.
▲
The lambda calculus for developers
(simonholywell.com)
2 points
by
Treffynnon
8y ago
|
0 comments
2.
▲
by
Treffynnon
10y ago
OK, so I think this might be a language/understanding difference here - perhaps what I have written isn't clear enough - not sure. The statement to some degree , in my opinion, doesn't imply that the key isn't actually
3.
▲
by
Treffynnon
10y ago
Well that's good seeing as though I wrote the guide in the first place. An illustration in bad pseudocode: PRIMARY KEY (account_number, transaction_date)
4.
▲
by
Treffynnon
10y ago
Have you read Celko's book? If not I suggest you do. As the guide states at the very top that is where you'll find the detail you're after.
5.
▲
by
Treffynnon
10y ago
This doesn't solve the problem at hand either unfortunately. You'll still have a hanging comma in front of `last_name`: SELECT -- first_name , last_name , email_address FROM users When parsed it wil
6.
▲
by
Treffynnon
10y ago
I think a lot of this comes down to what appears to be a simple misunderstanding. Avoid - in this context means that where it does not make sense (for performance, readability, etc reasons) then don't follow the guide. Follow it wher
7.
▲
by
Treffynnon
10y ago
Putting the comma before doesn't actually make commenting out columns easier - it just moves the problem to the other end of the list. Just try commenting out the first column in your SQL and you'll see what I mean.
8.
▲
by
Treffynnon
10y ago
I am totally lost when it comes to your comments on the second item. It seems you're trying to say that surrogate keys are easier to find or perhaps guess. The indexes set out against a table can generally be accessed with a query maki
9.
▲
by
Treffynnon
10y ago
Thinking multi-column indexes here.
10.
▲
by
Treffynnon
10y ago
Basically this is the answer - besides that bit about acquiescing to the demands of an ORM.
11.
▲
by
Treffynnon
10y ago
This seems to be a simple misunderstanding. Try - in this context means where it doesn't make sense (for performance, readability, etc reasons) then don't follow the guide. Follow it where possible and be mindful of when you dev
12.
▲
by
Treffynnon
10y ago
This is a pretty commonly asked question. The answer is two fold: 1. putting the comma before doesn't actually make commenting out columns easier - it just moves the problem to the other end of the list. Just try commenting out `first_
13.
▲
Simultaneously benchmark many URLs with ApacheBench and GNU parallel
(simonholywell.com)
1 points
by
Treffynnon
10y ago
|
0 comments
14.
▲
Intelligent Vagrant and Ansible files
(simonholywell.com)
2 points
by
Treffynnon
11y ago
|
0 comments
15.
▲
by
Treffynnon
11y ago
No, actually the collective of player isn't team in this case. Not all players will be on the same team, but they still participate in the league so I disagree with this example terminology shift. You would end up with a slightly more
16.
▲
by
Treffynnon
11y ago
This is an interesting idea. I will give it some thought as others have also suggested similar. Perhaps the guide could be relaxed a little to allow singular names. Someone mentioned that tables can be considered like types - another intere
17.
▲
by
Treffynnon
11y ago
When modelling data it should be the primary concern and not an ORM. Different applications will need access to the same information. ORMs are application specific and therefore should not determine how data is structured. As for the non-En
18.
▲
by
Treffynnon
11y ago
Amusing example however as you'll know following a style guide doesn't preclude one from using their own intelligence to choose sensible options rather than delving into the absurd.
19.
▲
SQL style guide – a consistent code guide ensuring legible and maintainable code
(sqlstyle.guide)
16 points
by
Treffynnon
11y ago
|
10 comments
20.
▲
Simultaneously benchmark many URLs with ApacheBench and GNU parallel
(simonholywell.com)
1 points
by
Treffynnon
11y ago
|
0 comments
21.
▲
Online regular expression builder, tester and debugger
(regex101.com)
1 points
by
Treffynnon
11y ago
|
0 comments
22.
▲
PHP function objects
(simonholywell.com)
2 points
by
Treffynnon
11y ago
|
0 comments
23.
▲
Functional Programming in PHP – The book
(simonholywell.com)
1 points
by
Treffynnon
12y ago
|
0 comments
24.
▲
HHVM vs Zephir vs PHP OPcache: The Showdown
(simonholywell.com)
2 points
by
Treffynnon
13y ago
|
0 comments
25.
▲
Reverse a git pull request on GitHub or any where really
(simonholywell.com)
1 points
by
Treffynnon
13y ago
|
0 comments
26.
▲
Conditionally loaded responsive content on the client side
(simonholywell.com)
1 points
by
Treffynnon
13y ago
|
0 comments
27.
▲
Timesaving crontab Tips
(krisjordan.com)
2 points
by
Treffynnon
13y ago
|
0 comments
28.
▲
Visual Event: View JS events and callbacks which are subscribed to DOM nodes
(sprymedia.co.uk)
2 points
by
Treffynnon
13y ago
|
0 comments
29.
▲
by
Treffynnon
13y ago
Perhaps because it was not built for the purpose of producing shot...
30.
▲
Idiorm and Paris 1.4.0 released - minimalist PHP ORM
(j4mie.github.io)
2 points
by
Treffynnon
13y ago
|
0 comments
More ›