Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
tapoueh
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
4 ms
·
1.
▲
Cleaning Up Your Postgres Database
(info.crunchydata.com)
5 points
by
tapoueh
6y ago
|
0 comments
2.
▲
A history lesson on SQL joins (in Postgres)
(citusdata.com)
1 points
by
tapoueh
8y ago
|
0 comments
3.
▲
Scaling Python: A book about the performance of applications written in Python
(julien.danjou.info)
5 points
by
tapoueh
9y ago
|
0 comments
4.
▲
by
tapoueh
9y ago
The payment forms were in HTTPS from the beginning, but the webpages (hosted at GitHub Pages). Now it's all HTTPS with a proper domain certificate, thanks to CloudFlare. Enjoy!
5.
▲
by
tapoueh
9y ago
That's a good idea, unfortunately the providers don't know each other and don't make it as easy as it sounds. Given interest into that, I will see about making something happen, if possible. Thanks!
6.
▲
by
tapoueh
9y ago
You know what? Just buy the book and if you don't like it, tell me. I'll refund you. My guess is that you will like it ;-)
7.
▲
by
tapoueh
9y ago
Went to fast and fat-fingered it. Works now!
8.
▲
by
tapoueh
9y ago
Fixed now!
9.
▲
by
tapoueh
9y ago
I've setup an Offer Code for the next 48h guys. Feel free to use it! http://masteringpostgresql.com/#packages
10.
▲
by
tapoueh
9y ago
The book covers some theory when it's needed and comes with lots of practical examples, all using real world data sets to make them easier to understand and relate to. Using an ORM and how to best integrate “raw SQL” in your code is al
11.
▲
by
tapoueh
9y ago
Fixed now. I really should have had my reviewer work on the website too, not just the book itself. Thanks guys!
12.
▲
by
tapoueh
9y ago
The book contains references for every data source it uses, all of them are available as Open Data. So you can load all the data, and copy/paste all the SQL queries with just the Book Edition. The Full Edition isn't so much about
13.
▲
by
tapoueh
9y ago
The e-mail address is easily found in the paperback version, and I just added it to the FAQ as well, thanks for reporting the bug!
14.
▲
by
tapoueh
9y ago
Thanks, fixed now!
15.
▲
by
tapoueh
9y ago
Yes the book targets more the SQL beginners, which are in my experience developers of all levels, from beginners to experts. The title is inspired to a great deal by an idea of how to best learn new things, which is very nicely covered in t
16.
▲
by
tapoueh
9y ago
Mastering PostgreSQL in Application Development is meant to target any development environment, yet it does target some ecosystems: Python, PHP, Java and Go receive a special treatment, and I must confess Python is covered way more than the
17.
▲
by
tapoueh
9y ago
The book definitely go into advanced usage. If you're already fluent in LATERAL joins, GROUPING SETS, Arrays, and JSON techniques, you might get bored to some degree. Every single chapter has some beginner, then intermediate, then adva
18.
▲
by
tapoueh
9y ago
No, I don't address that point in this book. It gives you plenty SQL techniques to avoid ever having to LOOP in a PL/pgSQL function, and show how to use PL/SQL rather than PL/pgSQL each time it is possible, though.
19.
▲
by
tapoueh
9y ago
So that you can receive updates if I make some. You don't have to, though, read http://tapoueh.org/blog/2017/11/mastering-postgresql-in-appl... where you will find the full Table of Contents, or just buy