Mastering PostgreSQL in Application Development • Hacker News Board

Re: Mastering PostgreSQL in Application Development

#11

Post by tapoueh » Mon, Nov 06, 2017, 2:41 PM UTC

aidos wrote: post #6

@tapoueh what level is this targeted at? It looks like it starts from a relatively basic level and covers pg usage fairly broadly. Would you recommend it to advanced users, or does it not go too deep into advanced usage?

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 advanced topics covered, so I think everybody should have some of the right content, really. I tried and paid attention!

Re: Mastering PostgreSQL in Application Development

#12

Post by alpos » Mon, Nov 06, 2017, 2:42 PM UTC

Not really feeling sold on this.

It's called "Mastering PostgreSQL" but the site reads like it's trying to convince beginner programmers that SQL iteself is useful.

Even the case made here: http://tapoueh.org/blog/2017/11/mastering-postgresql-in-appl... seems like it would only be convincing to someone who has never had to write much SQL and also has not already had to do a pattern like that in an API call.

Re: Mastering PostgreSQL in Application Development

#13

Post by tapoueh » Mon, Nov 06, 2017, 2:43 PM UTC

pletnes wrote: post #10

Does it cover development in some particular language? E.g python+sql?

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 other choices.

Re: Mastering PostgreSQL in Application Development

#14

Post by tapoueh » Mon, Nov 06, 2017, 2:47 PM UTC

alpos wrote: post #12

Not really feeling sold on this. It's called "Mastering PostgreSQL" but the site reads like it's trying to convince beginner programmers that SQL iteself is useful. Even the case made here: http://tapoueh.org/blog/2017/11/mastering-postgresql-in-appl... seems like it would only be convincing to someone who has never had to write much SQL and also has not already had to do a pattern like that in an API call.

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 the following Ted Talk: https://www.ted.com/talks/sal_khan_let_s_teach_for_mastery_n...

Re: Mastering PostgreSQL in Application Development

#15

Post by djklanac » Mon, Nov 06, 2017, 2:48 PM UTC

tapoueh wrote: post #9

djklanac wrote: post #7

I didn't see any reference to PL/pgSQL in the table of contents. Does your book go into common strategies with stored procedures (e.g. When to LOOP to build a temp table vs. using table joins)?

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.

Sweet. I'll give your book a read then. Gaining a more solid SQL foundation to avoid LOOP in the first place is what I need.

Re: Mastering PostgreSQL in Application Development

#16

Post by spacemanmatt » Mon, Nov 06, 2017, 3:03 PM UTC

alpos wrote: post #5

tapoueh wrote: post #3

Earlier quoted context omitted.

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 the book ;-)

Best not to sneak an email collection scheme in on people even if it really is only for your newsletter. Most people have more than enough spam in their inbox already, if someone wants to get updates it's very easy for them to just click a button that says "Click here to get updates".

Email for updates being a foot in the door for further communications is pro forma and legally regulated. I think you're unnecessarily suspicious.

Re: Mastering PostgreSQL in Application Development

#17

Post by _joel » Mon, Nov 06, 2017, 3:06 PM UTC

I don't know how much cross-browser testing you do, but the site looks completely broken in Firefox, renders fine on Chrome.

EDIT, I tried adding https to check (cert is wrong too, however) and it looks better. Be aware the link posted (for some reason) is HTTP only.

Re: Mastering PostgreSQL in Application Development

#18

Post by qaq » Mon, Nov 06, 2017, 3:20 PM UTC

craigkerstiens wrote: post #8

As someone that cares greatly about the Postgres ecosystem there aren't nearly enough books out there, so really excited to see this one come to life. Instead of targeting DBAs the focus on app devs is very refreshing so that people can start to leverage more of the awesome in Postgres. I haven't yet read the book myself but absolutely will. If you're curious to read some of Dimitri's writing ahead of time his blog i…

I think it's to a degree a function of significant volume of high quality material available in the open. It's hard to sell a book when you can go to Bruce Momjian's site https://momjian.us and get access to a ton of information and that is just one resource.

Re: Mastering PostgreSQL in Application Development

#19

Post by nicholas79000 » Mon, Nov 06, 2017, 3:20 PM UTC

COMPOSITE HACKS

• If Truly you Are In Need Of A PROFESSIONAL LEGIT HACKER Who Will Get Your Job Done Efficiently With Swift Response, Congratulations, You Have Met the Right HACKERS

We are a group Of Professional HACKERS , a product of the coming together of Legit Hackers from the Dark-Web, (pentaguard ,CyberBerkut , RedHack , Black Hat, Anonymous ) we have been existing for over 12 years, our system is a very loose and decentralized command structure that operates on ideas rather than directives. you can also find us on the dark web at :http://my7cic3ax7oznkvu.onion (Tor Only)

Frankly speaking, I always give a 100% guarantee on any job i am been asked to do, because we have always been successful in Almost all our jobs for over 12years and our clients can testify to that . To hack anything needs time though, but we can provide a swift response to your job depending on how fast and urgent you need. Time also depends on what exactly you want to hack and how serious you are. Enough time with social engineering is required for hacking. So if you want to bind us in a short time, then just don't contact us because We can't hack within one hour,sorry. Basically, time depends on your luck. If its good luck, then it is possible to hack within one hour but, if its in the other way round, it would take few hours. I have seen FAKE HACKERS claiming they can hack in 1hr , but there is no REAL HACKER who can say this (AVOID THEM).

- Please Note : we have only one contact email : compositehacks@gmail.com we will be happy to have you join over 2000 satisfied clients around the world to use our services.

We provide prove of job before payment We offer services like: Hacking Whatsapp account giving you access to the person's whatsapp messages and history . You can check out our Latest Whatsapp Hack video https://www.youtube.com/watch?v=7_LtFUVMcxY Initiating Bank Wire Transfers at a resonable fee and completely untracable . Hacking any smart phone giving you access to all activities on the phone like , text messages , call logs , instant messenger chats and other information.(you can use this to spy on your spouse to know if he/she is cheating on you) Hacking Facebook , Instagram , Twitter and every other social network Accounts. Hacking Websites to deface , retrive information, edit information or give you admin access . Hacking into school's websites (server) to change grades without any trace . . Hacking any email service provider like Gmail , Yahoo, Comcast , Aol , Hotmail any others . Location Tracking. Hacking and selling credit cards , amazon , walmart , paypal , bank logs . Selling of untracable phones (even the pentagon can not track our phones). . Selling of Tutorial packs for Beginner Ethical Hackers You can also contact us for other Cyber Attacks And Hijackings, we do almost All.

Contact us: compositehacks@gmail.com

Re: Mastering PostgreSQL in Application Development

#20

Post by infinisil » Mon, Nov 06, 2017, 3:22 PM UTC

_joel wrote: post #17

I don't know how much cross-browser testing you do, but the site looks completely broken in Firefox, renders fine on Chrome. EDIT, I tried adding https to check (cert is wrong too, however) and it looks better. Be aware the link posted (for some reason) is HTTP only.

The linked version works fine for me, Windows 10, Firefox 56.0.2