AlisdairO

13 ms·

91.
by AlisdairO 9y ago
Thank you!
92.
by AlisdairO 9y ago
thanks :)
93.
by AlisdairO 9y ago
Glad you've found it useful! FWIW window functions are already covered in the Aggregation section. The rest of it, yeah, as you say it's not so great a fit.
94.
by AlisdairO 9y ago
Ah, I should have been clearer in my initial response. I actually have no opinion on whether zip codes are a number, as I'm from the UK and don't really know how they work :-). I was more responding to the idea that any numeric va
95.
by AlisdairO 9y ago
That wouldn't generally be my approach. In my view if something is a number it should be typed as such. That said, I recognise that there are pros and cons to this approach similar to those in strongly vs weakly typed PLs. My personal
96.
by AlisdairO 9y ago
grins for that I'll have to say that I'm from the UK and that situating the exercises in the US was probably an error :-)
97.
by AlisdairO 9y ago
Author here: out of curiosity, what would be your priorities for future exercises? Right now my list looks roughly like: - DDL - Advanced datatypes (JSON, arrays, etc) - GIS This order is partly informed by the current supp
98.
by AlisdairO 9y ago
Yeah, I have zero design sense and just went with the defaults of a bootswatch theme that I liked :-)
99.
by AlisdairO 9y ago
Author here - thanks a lot for the feedback, it's appreciated. You're right on the naming convention, it's very haphazard. I'll raise an issue on Github to revisit that - although it may take me quite a while to get to i
100.
by AlisdairO 9y ago
Author here: hope people find this useful. I've been very quiet on the site lately due to a serious of (mostly good) life upheavals. This update lays the technical groundwork for a bunch of future exercises, so I hope to have a little
101.
PostgreSQL Exercises adds DML exercises(pgexercises.com)
4 points by AlisdairO 9y ago|1 comments
102.
by AlisdairO 9y ago
> with just a little bit of will As a once-fat guy, it's truly frustrating to read this. If there's one thing I could drill into people observing this problem, it's that different things are hard for different people. For
103.
by AlisdairO 9y ago
I really liked this post. Obviously everyone has different motivations, but at its heart FOSS is an enormous collection of cooperative and/or charitable work, and the industry as a whole should be really, really proud of it. One other
104.
by AlisdairO 9y ago
[self plug] Take a look at https://pgexercises.com/ . It's a learn-by-doing set of SQL exercises. Focused on Postgres, but the large majority is standard SQL.
105.
by AlisdairO 9y ago
"These, of course, are pitiful numbers for a database. However, it’s important to note that these numbers are not representative of what real-world applications can expect to see from CockroachDB. First, this is a test in which the Jep
106.
by AlisdairO 9y ago
(self plug) for learning Postgres-flavoured SQL, take a look at https://pgexercises.com . Books-wise, Learning SQL is a great start. http://shop.oreilly.com/product/9780596007270.do The postgres docs themsel
107.
by AlisdairO 9y ago
Disclaimer: huge postgresql fanboy, use it whenever I get the chance A few things I've found great in Oracle that aren't (AFAIK) available in PG: - Straight better/more reliable performance on average - More advance
108.
by AlisdairO 10y ago
> In the past we've replaced unskilled labor with new unskilled roles, and I don't see those roles hanging around anymore. The sad reality is that there's a nontrivial chunk of the populace that isn't able to pick up
109.
by AlisdairO 10y ago
> Aurora is similar idea. Aurora isn't substantially more expensive than RDS Postgres. Caveat is that you can't run it on the really tiny instance sizes right now. On an r3.large with no reserve pricing you're looking at ~
110.
by AlisdairO 10y ago
> What if those in Culture B face problems? Should they not ask for change? What if those in the culture are citizens? The idea that people can't ask or demand for things just because they are of a different culture is ridiculous. S
111.
by AlisdairO 10y ago
Postgres uses process-per-connection. Usual model is to put it behind a connection pool like pgbouncer.
112.
by AlisdairO 10y ago
Not sure how it works on cloudformation, but in the console and API you have to explicitly skip the final snapshot.
113.
by AlisdairO 10y ago
You gave one example of each. That's a pretty painful definition of the word 'every'. On performance: Every database will have some areas where it performs better than others - Uber just happened to hit a case that MySQL is w
114.
by AlisdairO 10y ago
Thanks :-)
115.
by AlisdairO 10y ago
I'm fortunate in my career - while more money is always nice, I'm at the point now where it would have to be an awful lot to persuade me to take more time away from my (very young) family. I suspect all a patreon would accomplish
116.
by AlisdairO 10y ago
No worries - hope you find it useful.
117.
by AlisdairO 10y ago
Thanks, appreciate it :-)
118.
by AlisdairO 10y ago
Thanks - I'll try to get hold of an ios device to test it on. Sadly my webdev skills are fairly lol-worthy ;-)
119.
by AlisdairO 10y ago
No problem - it's really gratifying to know that it helped you. I'm not so interested in monetizing - I've received an awful lot from the wider OSS community, and I did the project as a way to give something back. That is a r
120.
by AlisdairO 10y ago
[self plug] On https://pgexercises.com I focus quite a bit on developing a mental model for SQL. I would suggest not skipping the easier exercises - even if you can do the SQL, you might find the explanations useful.

More ›