The following query computes an approximation of the Mandelbrot Set and outputs the result as ASCII-art That's the biggest nerd-out I've seen in weeks.
Nerds like weird tricks when they discover Turing-completeness in their favorite language.
SQLite now supports recursive CTEs
21–25 of 25 posts
Re: SQLite now supports recursive CTEs
#22This support was added in SQLite 3.8.3 and released in early February https://sqlite.org/changes.html
I've been using it in some internal code at work since late February. It works pretty well. I was surprised by how fast it is.
Re: SQLite now supports recursive CTEs
#23Earlier quoted context omitted.
So you run tests on SQLite and use Postgres in production? Sounds like a disaster waiting to happen, if it hasn't already.
Your CI server should be running a stack very similar to production, but there are excellent reasons to use SQLite/H2/etc. in dev. Being able to do a "git clone foo; cd foo; do my job" is a great way to start working, especially if you have struggled with front-end stylists using real data and back-end services, or any other specialised, possibly short-term, experts who are working on your project and don't have a ne…
[deleted]
Re: SQLite now supports recursive CTEs
#24Earlier quoted context omitted.
is postgres as quick as neo4j, in your use case? ive really been into neo4j lately, but im curious if postgres could also be used as a graph database.
Yes, on the queries that I've done (mostly friendship graphs, and doing queries like getting friends of friends) postgres was pretty much on par with neo4j. I'm way more familiar with tuning postgres though, so there's that. I really liked the cypher query language of neo4j, it was super easy to learn and is way simpler to express complex traversals across a graph. Writing a query in postgres to traverse a graph isn'…
i wasnt expecting that answer...
how large was your friends table? maybe it was quick when doing friends of friends because the friends table was already wholly loaded into memory?
i wonder if your relationship traversals spanned across different tables, if postgres would still be as quick?
Re: SQLite now supports recursive CTEs
#25The following query computes an approximation of the Mandelbrot Set and outputs the result as ASCII-art That's the biggest nerd-out I've seen in weeks.
Nerds like weird tricks when they discover Turing-completeness in their favorite language.
Free credits for the first person to port it to an embedded blinkenlights platform.