Mostly watching other people write code, sometimes writing my own.
Christchurch
Joined November 2007
- Tweets170
- Following35
- Followers286
- Likes652
Daniel Fone retweeted
It turns out, beating AI is extremely easy... you just have to ask it to roleplay sci-fi tropes:
Daniel Fone retweeted
This is crucial. Understand these two facts:
1. Once you pick a DB, you're unlikely to leave that for another DB. So don't worry about portability of your code. Thus....
2. Use every feature of your DB and learn to optimize queries for it. You can save days of time.
Daniel Fone retweeted
If I was looking to invest in magic numbers that go up for no reason I'd put my money in z-index
Daniel Fone retweeted
👀 “…the event of your death… coming later this year.” apple.com/macos/monterey/
Daniel Fone retweeted
we have replaced
the features
that were in
your macbook
and which
we had removed
because
we could
forgive us
we did not expect you’d hang on
to that 2015 from ebay
as long
as you have
Daniel Fone retweeted
The VALUES table-construction statement of #PostgreSQL and #SQLServer offers a brilliant way to construct, troubleshoot, and debug complex SQL queries.
Daniel Fone retweeted
Y'all this new JSON subscript syntax in Postgres 14 is sweet. Super excited to see Postgres just getting better bit by bit - blog.crunchydata.com/blog/be…
Daniel Fone retweeted
🚀🚀🚀💎💎💎 I’m incredibly excited to announce this new @rubygems feature.
From now on, you can review changes in the releases of gems by clicking on the "Review changes" link. There's much more to it and you can read about it here: mensfeld.pl/2020/10/diffend-… #ruby #security
Daniel Fone retweeted
"So you know when you’re flopping about at home, minding your own business, drinking from your water bottle in a way that does not possess any intent to subvert the Commonwealth of Australia?"
mango.pdf.zone/finding-forme…
Daniel Fone retweeted
Most of all deployments out there that use PostgreSQL + memcache/redis and even elasticsearch to write non relational data in whatever form: Could likely just use PostgreSQL and its non relational features.
Daniel Fone retweeted
Learning how to pivot data with Postgres (tablefunc + crosstab) is a hidden super power. vertabelo.com/blog/creating-…
Daniel Fone retweeted
The secret to making your website feel like a native app
#javascript #100DaysOfCode
ALT window.onerror = window.close
Daniel Fone retweeted
There's much more to SQL than what you learned in college or on W3Schools, like:
- Window Functions
- CTE and Recursive CTE
- JSON processing
- PIVOT and UNPIVOT
- Lateral Join and Cross Apply
- Merge and Upsert
Investing time in learning SQL is definitely going to pay off.
Daniel Fone retweeted
How much better than JPEG can a neural network be at image compression? A lot. Like, a lot a lot. hific.github.io/ The site has an interactive comparison of their method vs JPEG so you don't need to know/care much about ML to see the difference.
Daniel Fone retweeted
I'm saving bits of audio to a BLOB column in Postgres. Because I plan to put a CDN in front of the controller that serves them, I wanted to asset fingerprint the "filename". Then I thought "can Postgres 12 generated columns build a filename for me?"
Yup! Worked on the first try!
ALT generated column definition that reads: alter table recordings add column file_name character varying GENERATED ALWAYS AS (item_id::text || '_' || encode(digest(data, 'sha256'), 'hex')::text) STORED
Daniel Fone retweeted
ENJOY : RELEASE of TALKS @ ParisRB 2020 : youtube.com/watch?v=9TB_EM9I… @TheDanAbrams @yukihiro_matz
Daniel Fone retweeted
Today I was dealing with polymorphic associations in PostgreSQL and needed to guarantee that my `reports` table contains exactly one association to either `videos` or `comments`. I used constraint with coercion trick that solves this elegantly
#PostgreSQL #polymorhism
