News for hackers. Stuff that matters.

jokull

I think poster overfits the postgres wiki advise. The thing is, most timestamps are not "UTC". That's only when you want to print an epoch value human readable you need some timezone and UTC is the most neutral. That doesn't mean you should opt for zoned timestamps in columns.

Because of this overfitting OP lands on exactly the wrong advice. Unfortunately the quoted line is "Even Postgres Wiki says: Don't use timestamp without time zone" but wiki says "Don't use timestamp (without time zone) *to store UTC times*".

Re:Is your Postgres migration safe or not safe? on Saturday September 26, 2026 @01:09PM (#49858493)
Good feedback - I condensed the webpage
Re:Is your Postgres migration safe or not safe? on Saturday September 26, 2026 @05:13AM (#49854688)
Very cool! I wrote a go library for this https://onwardpg.solberg.is
Re:Level S4 solar radiation event on Tuesday January 20, 2026 @04:56PM (#46698260)
Yes - not seen it this red though.
Re:Level S4 solar radiation event on Tuesday January 20, 2026 @06:16AM (#46690603)
As seen from my apartment in Reykjavík Iceland: https://ss.solberg.is/89N0qS7T
Re:Ask HN: Any example of successful vibe-coded product? on Tuesday December 30, 2025 @01:38PM (#46436427)
Keep in mind that a lot of vibe-coded software is flying under the radar because it’s being built to replace SaaS and bring workflows in-house. We often judge success by public launches or ARR, but the real "killer app" for this methodology right now is internal tooling for small teams. For example, instead of spending developer bandwidth integrating Salesforce into first-party data, teams are increasingly just vibe-coding a bespoke CRM or CMS as an appendage to their existing database. It’s complex software (state, auth, heavy logic), but it will never be on Product Hunt because it's purely for internal utility. The success metric here isn't "did we get 10k users," it's "did we avoid a $50k contract and weeks of integration hell."
I recommend https://remedajs.com/ - they're always making the types more accurate too. Like groupby has nonempty lists.
Re:Boris Vallejo and the Pixel Art of the Demoscene on Tuesday October 01, 2024 @03:07PM (#41712822)
Link to your wife's work?
Re:I'm writing a new vector search SQLite Extension on Friday May 03, 2024 @03:22PM (#40251295)
libsql (from turso) is also working on this - the more the merrier
Re:Lcl.host: fast, easy HTTPS in your local dev environment on Wednesday March 20, 2024 @05:25PM (#39772189)
I just use cloudflare tunnels (cloudflared) - don't have to install any certificates, it's all handled by cloudflare. Yes, it exposes globally, but that's often convenient to share a link to my dev with colleagues. And it has been fast enough. Downside is that you need internet connectivity.
No - please check out Hono https://github.com/honojs/hono
Re:Reflections on Migrating My SaaS to SvelteKit on Wednesday April 26, 2023 @04:21AM (#35710833)
Very different. Svelte has magic event bindings and compiles `.svelte` files. Their learning material is interactive and worth going through just to see some new ideas.
Re:Reflections on Migrating My SaaS to SvelteKit on Wednesday April 26, 2023 @04:20AM (#35710824)
For what it's worth there's a good library to load markdown with Svelte components mixed in. Here's how I'm loading it: https://github.com/jokull/blog/blob/master/src/lib/getPosts....
Re:Reflections on Migrating My SaaS to SvelteKit on Wednesday April 26, 2023 @03:41AM (#35710598)
SvelteKit is a very complete and well designed solution. Routing, data loading, forms, SSR, caching, dealing with environment variables - all very nice. The only "drawback" is Svelte - I just don't like the data binding thing and prefer working with React components and hooks. Maybe that's just because I've spent so much time in React/Next. Well written React code is actually quite easy to debug, reason about and debug. I find it super annoying to refactor Svelte code because every time I want to extract some code into a component it can't be a function in the same file before it becomes a whole new file. It has to be a file. Also haven't found anything nearly as nice as Framer Motion and Radix in Svelte land.
Re:Kysely: TypeScript SQL Query Builder on Wednesday January 25, 2023 @04:21PM (#34524364)
Love this library and use it with kysely-codegen and D1
Re:Using a Framework will harm the maintenance of your software on Thursday October 13, 2022 @06:57AM (#33189440)
The criticism is mainly on last-generation frameworks that came around before React and the like. They bundled together an all-in-one approach to writing web apps. Django comes with an admin tool!

The world has largely moved to richer frontends so stacks are more flexible.

Re:Ask HN: So you moved off Heroku, where did you go? on Tuesday October 04, 2022 @10:02AM (#33080535)
They also have a migration guide and have even built some tooling around that process: https://render.com/docs/migrate-from-heroku
Re:Ask HN: Looking for Email Service Recommendations on Sunday September 25, 2022 @02:38PM (#32974491)
Fastmail
To read a draft :) You can reach out to me here if you want [email protected]
Hey what's your email? I'm thinking about writing up a blog post with information in this AskHN
In my country it is but you have to pay a fair salary and only expense strictly business related things. At the end of the month it's not illegal to have some funds remaining - as it can be because of irregular income, a business reality for many (most?).
The issue here is not calculating a fair salary - and its an insanely popular way to avoid taxes all over the world. Tax authorities turn a blind eye, I suspect because the practice is just too common among politicians and their friends.

This might not be an issue if the corporate income tax + financial gains tax comes out the same as payroll tax. The bigger issue here is that you can use the remaining funds to invest and losses form a tax deduction base. More commonly however people just cram as much personal consumption inside the companies before paying out the salary, even things like travel and dining out. In the EU, VAT is commonly quite high and you get refunds on that if the expenses are on the company.

Is there something stopping a US company from issuing equity to foreign citizens?
The way I do it, I set up a limited liability company that is just my own name. I then charge for services rendered and income goes into a company in my sole ownership. I then pay salary to the only employee (me). This is common and completely legal.
Just went through this. I ended up setting up as a contractor sending invoices quoted in the contract USD monthly number. I had to be careful to ensure I was covering all fees, including my coworking space rent and book keeper. They agreed to cover any future travel expenses though, which makes sense but better clarify it up front.

Older »