User:Lluad

From PostgreSQL wiki
Revision as of 20:02, 5 August 2019 by Lluad (talk | contribs) (tute notes)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Some notes on a maybe future tutorial:

lluad, if you were making a "green field" tutorial, what would it contain?

<lluad> I have thought about this. :) <lluad> There are several branches of that. <lluad> The first is an online playground - more like play.golang.org than sqlfiddle - that lets people use it and run basic sql without installation. <lluad> (Making the examples in the docs self-contained and runnable and CI-ing them would be another aspect of that) <davidfetter_work> I love it. <lluad> The next branch would be a "choose your own adventure" style doc for installing (an appropriate variant of) PostgreSQL on your OS of choice, and some sort of client. <lluad> The next, next branch would be a postgresql-specific "intro to sql". Create a table, select from it, SQL for Dummies sort of stuff. <lluad> The next, next branch would be "An intro to using it in production" that would talk about users, roles, access controls, security, just an intro level. <lluad> And then there'd be the reference docs. <lluad> So, uh, something like that. :) <davidfetter_work> lots of those are independent of each other :) <lluad> Yeah. They can certainly be created independently, but breaking it up like that reduces the the overlap and makes them work together. <davidfetter_work> Is "install PostgreSQL" still the barrier it used to be? on OSX, it's "use the (home)brew, Luke" <davidfetter_work> on Ubuntu, it's pretty straightforward <lluad> macOS is the hardest to install on. <davidfetter_work> if that's the hardest, I'm gonna call it P3 <lluad> There are like seven different options and if you install more than one of them you risk them stepping on eahch others toes. <davidfetter_work> that's true of any set of packaging systems on any OS <lluad> I tend to push people away from Homebrew. If they're using it for development then Postgres.app is better in some respects. <lluad> Oh, yeah. Another fork of the tutorial: "How to connect to PG from your language of choice, including a hello world example." <lluad> Installing PG on Windows still seems to be fraught with pain and permissions issues, but much less than it used to be. <lluad> Actually, getting psql and libpq packaged in a .msi would be a really good idea, now, 'cos we can tell them "Just run the server on WSL". <lluad> And I just got my MS code signing certificate and packaging farm ... <davidfetter_work> Do it!