HNHacker News
TopNewBestAskShowJobs

jokull

690 karma · joined March 18, 2009

twitter: @jokull
submissionscomments
jokull··on Footguns with Postgres “at time zone 'UTC'”
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*".

jokull··on Is your Postgres migration safe or not safe?
Good feedback - I condensed the webpage
jokull··on Is your Postgres migration safe or not safe?
Very cool! I wrote a go library for this https://onwardpg.solberg.is
jokull··on Level S4 solar radiation event
Yes - not seen it this red though.
jokull··on Level S4 solar radiation event
As seen from my apartment in Reykjavík Iceland: https://ss.solberg.is/89N0qS7T
jokull··on Ask HN: Any example of successful vibe-coded product?
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."
jokull··on Show HN: SuperUtilsPlus – A Modern Alternative to Lodash
I recommend https://remedajs.com/ - they're always making the types more accurate too. Like groupby has nonempty lists.
jokull··on Boris Vallejo and the pixel art of the demoscene
Link to your wife's work?
jokull··on I’m writing a new vector search SQLite Extension
libsql (from turso) is also working on this - the more the merrier
jokull··on Lcl.host: fast, easy HTTPS in your local dev environment
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.
jokull··on Ask HN: Is Express still "de-facto" for building Node back ends?
No - please check out Hono https://github.com/honojs/hono
jokull··on Reflections on Migrating My SaaS to SvelteKit
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.
jokull··on Reflections on Migrating My SaaS to SvelteKit
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....
jokull··on Reflections on Migrating My SaaS to SvelteKit
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.
jokull··on Kysely: TypeScript SQL Query Builder
Love this library and use it with kysely-codegen and D1
jokull··on Using a framework will harm the maintenance of your software
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.

jokull··on Ask HN: So you moved off Heroku, where did you go?
They also have a migration guide and have even built some tooling around that process: https://render.com/docs/migrate-from-heroku
jokull··on Ask HN: Looking for Email Service Recommendations
Fastmail
jokull··on Ask HN: What is the best jurisdiction for internationally distributed teams?
To read a draft :) You can reach out to me here if you want jokull@solberg.is
jokull··on Ask HN: What is the best jurisdiction for internationally distributed teams?
Hey what's your email? I'm thinking about writing up a blog post with information in this AskHN
jokull··on Ask HN: What is the best jurisdiction for internationally distributed teams?
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?).
jokull··on Ask HN: What is the best jurisdiction for internationally distributed teams?
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.

jokull··on Ask HN: What is the best jurisdiction for internationally distributed teams?
Is there something stopping a US company from issuing equity to foreign citizens?
jokull··on Ask HN: What is the best jurisdiction for internationally distributed teams?
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.
jokull··on Ask HN: What is the best jurisdiction for internationally distributed teams?
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.
jokull··on Ask HN: What is the best jurisdiction for internationally distributed teams?
Delaware company and then all team members get set up as contractors in their country of residence. If they are in the EU they can contract from where they are from but live within the EU - more flexibility. But putting people on payroll has a huge overhead - better compensate employees to pay a local book keeper to invoice and process their payroll. Encourage people who have not contracted to research what contractor fee covers their salary. It will be tricky to compare apples to oranges when it comes to salaries, not just because of different rates in different places, but because salaries are quoted differently and have different insurances. Where I'm from there's a compulsory payment from employer to the employees pension fund of choice. Salaries are quoted to include this payment. And on and on ... very different across countries. Contractor fee "normalizes" this and places some burden on employees to research what their USD contractor fee is. Ask people to invoice a week ahead of international transfer and transfer 1-2 business days before month's end. This will result in monthly salaries being paid out on time.
jokull··on Pre-commit: framework for managing/maintaining multi-language pre-commit hooks
I suggest only doing pre-commit stuff for things that run really fast. Don't put your whole test suite in there.
jokull··on Modern Python full stack with asyncio, Mypy, Next.js 12 and GraphQL
Good question. Performance is only one aspect of asyncio. Being able to pass co-routines around, parallelize I/O and make use of things like Starlette's background tasks is the main reason in my mind. Performance is not an issue if you have a business to pay for 20-50% as many app instances. And I do believe the results of those benchmarks are contested, so asyncio can perform as well if not better.
jokull··on Async Python is not faster (2020)
Was already posted and discussed before: https://news.ycombinator.com/item?id=23496994
jokull··on React Aria: A headless UI component library
"Bring your own UI". You get the behavior from the library but they are completely unstyled or without the component layer where the styles live. Other libraries include Radix and HeadlessUI. Here's a presentation from one of the Radix library authors about how to build dropdowns in React, it serves as a good explainer about what goes into a headless UI library component. https://www.youtube.com/watch?v=lY-RQjWeweo
Page 1 of 13Next →