What are great resources for learning PostgreSQL from intermediate to advanced level? Official docs are very dense. (Or I'm approaching docs wrong way?)

There's also https://www.postgresqltutorial.com/, but I've read most of content here.

I’ve bought “the art of PostgreSQL”, it’s an interesting read. The reddit community is also super helpful if you have specific questions.

Whilst not PostgreSQL specific, it does have PostgreSQL examples, but this is a useful read: https://use-the-index-luke.com/

There is the #sql channel too 🙂

http://www.craigkerstiens.com/ of Citus data fame also has a nice blog

Happy Monday! What do Clojurians think about hiding the implementation of a data-structure vs "it's just data"? For example, the first chapter of Elements of Clojure has a moon map of the solar system: { :sol { :jupiter { :callisto { ... } }}} The author writes a function that effectively aliases get-in, introducing indirection:

(get-jovian-moon m :callisto)
vs
(get-in m [:sol :jupiter :callisto]) 

My object oriented brain tells me get-jovian-moon is great because Clean Code tells me to make as many small functions as humanly possible, using their names as self-documentation 😉

if the data organization is an implementation detail that is subject to breaking changes, but the API functions are stable, I think it's good to document that

sometimes I use .impl as part of the key names to indicate this key is an implementation detail

is it normal to have a canonical form of data that acts as an interface (and adheres to all the versioning/API stability rules that implies) in addition to .impl structures?

Is it just me thinking that the commonly seen clojars links are silly? I mean, it's an image of the text that I usually, want to copy, and I need to click it and then copy it from another page.

New community chat on Telegram https://t.me/Clojurasts intended to be like IRC just more async and mobile friendly. So you can chat on the go.

Hey friends, got tips for finding clojure gigs? Are there technologies that everyone wants to see on the resume? Concepts clojure veterans are going to look for that a reformed php dev might not have encountered yet? I'm pretty thrilled with clojure, coming from a 6 year php background, it's just such a joy to write in. I'm just shy of 200 commits into my genetic algorithm based game project I've been doing, but I'm not sure if that's considered much of a qualification by itself! Thanks!

#jobs-discuss is a good channel for those sorts of discussions, if you don't get much feedback here @doby162

Thanks, I'll at least join it for now

@pez I was super impressed by your thread on prime sieve: https://clojureverse.org/t/eratosthenes-party-time-a-k-a-feedback-wanted-on-this-implementation-of-eratosthenes-sieve/3801/7 I am now totally hung up on optimizing a prime factorization sieve: https://gist.github.com/Hindol/e2a3f724b19b07186945e981cdce3e15 You or anyone else want(s) to take a shot at it?

Haha, @hindol.adhya, it really is rabbit hole! I had so much fun with that. I hope we can inspire more people to have a go.