Nikita Melkozerov
@meln1k
Followers
1,269
Following
205
Media
41
Statuses
506
Backend engineer by day, indie hacker by night. Buiding in my spare time.
Hamburg, Germany
Joined November 2009
Don't wanna be here?
Send us removal request.
Explore trending content on Musk Viewer
Chicago
• 373783 Tweets
Madrid
• 363183 Tweets
Flamengo
• 192433 Tweets
Allan
• 132424 Tweets
Mallorca
• 118114 Tweets
Botafogo
• 110006 Tweets
Rafael
• 50342 Tweets
O Tite
• 48420 Tweets
Doritos
• 44373 Tweets
Luciano
• 39440 Tweets
#ToneyForAlAhli
• 38057 Tweets
休み明け
• 34749 Tweets
連休明け
• 30290 Tweets
Ancelotti
• 27426 Tweets
Rossi
• 26233 Tweets
Wesley
• 22476 Tweets
Mendy
• 22051 Tweets
Léo Pelé
• 20628 Tweets
Léo Ortiz
• 19128 Tweets
ハイキューの日
• 18533 Tweets
Arrascaeta
• 17739 Tweets
Broncos
• 17154 Tweets
Bruno Henrique
• 16851 Tweets
東海大相模
• 11134 Tweets
#バイクの日
• 10925 Tweets
So I started using SQLite as a database for my side project, and I want to share my experience so far:
1. It is fast. Like really fast. My architecture is a monolith written in Go (this is intentional, I sacrificed scalability to improve my shipping speed), and this is where
98
139
2K
how I squeeze 60K RPS out of SQLite on a $5 VPS:
There are tons of tutorials on how to setup SQLite, and sometimes they contradict each other. Here is what worked for me.
1. Configuring PRAGMAs. We need to send the following PRAGMA commands right after opening the connection:
25
127
2K
@siyabuilt
It is really not. I'm thinking about writing a post, shall I do that?
I would cover:
1. securing ssh
2. setting up a firewall
3. configuring unattended upgrades
4. VPN access with tailscale
5. dashboards
6. GH actions for deploying to VPS
7. zero-downtime deploy via systemd
26
5
276
We all heard those stories. Netlify billed someone $104k for a static website. Cara got $96,280 bill from Vercel after going viral.
You want to be an indie-hacker, not an indie-bankrupt.
What if I tell you that a $5 VPS can serve 5K RPS? Here is how you can set it up yourself:
8
15
62
Important note: if you use synchronous = NORMAL with WAL your database won't be corrupted, but during a power loss the latest transactions could be rolled back.
To fix that use synchronous = FULL, you will lose around 30% in write performance, but sqlite will sync the WAL after
3
0
38
@StephanGarland
I’m not saying I completely avoid joins, sometimes it’s just way too tempting to filter in the application and then query one more time. It’s good to have flexibility knowing that n+1 is not going to slow you down that much.
1
0
31
I'm launching my blog today together with a new post about
@FoundationDB
cluster layout, classes, roles, and processes!
0
7
25
1
1
23
I've released a stable (means it won't corrupt your data if you mount a single volume concurrently) version of the Block device layer for
@FoundationDB
!
With it you can magically add replication to a legacy application that doesn't support it.
0
7
22
@NickLaptev
I like being independent from vendors. Also I won’t get a surprise bill if someone decides to DDoS me.
3
0
22
A month ago I started writing an interpreter from the using Rust (with zero prior Rust and interpreters knowledge), and today it became Turing-complete. Wow! What a journey! Thank you
@thorstenball
for writing this amazing book!
1
2
20
How I create UI for my side-projects with (almost) no JavaScript.
As a backend dev, I've never worked with modern Single Page Application (SPA) frameworks. They all seem to be way too complex for what I want. I don't want offline functionality. I don't want to have separate
2
1
20
@daniele_dll
True, there is no replication, but streaming backups with 1s lag are fine for a lot of cases. In the worst case I will just refund my customer.
2
0
17
Folks, keep your operating expenses low by hosting on a $5 VPS, and have a 9-5 job for infinite runway. Success is inevitable.
Fantastic lessons from
@harjtaggar
at the
@ycombinator
retreat. Let’s survive long enough and get lucky! 🚀
12
55
681
1
1
17
@AshConnell
I use systemd socket activation to buffer incoming connections while my service is restarted. Also graceful shutdown to finish with the existing requests.
1
0
15
@AhmedRouizi
Not a particular framework, just a bunch of Go libraries stitched together. For http routing I use echo, and templ for server side templating. Frontend is done with htmx, tailwind and alpinejs.
2
0
15
It was great to see so many people interested in Akka, Event Sourcing and how they play with
@FoundationDB
!
#ScalaConf2019
From a report by Nikita Melkozyorov
@meln1k
(
@MOIAmobility
) we learned why the akka-persistence-cassandra plugin is not perfect and what to do about it.
#ScalaConf2019
0
3
4
1
0
11
When I have go, tailwind, alpinejs and htmx in a single .templ file.
0
0
12
me: I'm going to build a new shiny NAS which will please my eyes every day.
expectations vs reality:
1
0
11
@rando_137
@StephanGarland
Very true, but chances are this will never happen and I move on to the next project. However, this is a nice problem to have in the first place.
3
0
11
@Blue0lemming
I think the main difference compared to a "traditional" db is that you can't talk to sqlite over the network. You need to have a direct access to the database file. That means you deployment is expected to fit on a single server. If this is not possible in your scenario, then
2
1
9
Finally I found a fix for all the MacBook keyboard problems:
1
2
9
@aguynamedben
Just go plus a bunch of libraries that I find useful. I like echo as an http router because of the amount of features available. I also use templ, htmx and alpinejs when it comes to UI.
0
0
9
@untalpablodz
I did some tests, and I have to say it works just fine. But I do the following: I keep two connections open: one for reads and one for writes. Then I set go's connection limit on the „write“ connection to 1, and keep the read limit as high as it gets. By doing this I offload
3
0
8
New blog post: Image Classification from scratch without a PhD.
If machine learning still seems like magic to you, then after you read this post, the problem of image classification will be completely demystified.
0
1
8
@Akshat_Giri
I prefer to keep things simple. I use GH actions that rsync the compiled binary to my VPS, and then systemd unit takes care of the restart process.
1
0
8
You don't need netlify/vercel/railway/render/fly/heroku to automatically deploy when you push to main.
All you need is:
1. a github action that builds your code and sends the artefacts to your VPS via rsync,
2. docker/systemd that restarts the application on update.
1
0
7
0
2
7
Going to purge the last bit of supabase auth (and supabase in general) from my project. Local SQLite on nvme with replication to S3 is sooo good.
1
0
7
ShipFast backend edition: Go monolith + SQLite + HTMX + Alpine + tailwind. Minimal complexity and friction.
Feels like the good old PHP days are back and launching in a weekend is possible again.
2
0
7
@pilotbob
There are many options, depending on what your architecture is and how much time you’re willing to spend on that. Random ideas from my head: shard by users, replicate the WAL to make read replicas, use mvsqlite, completely drop SQLite and use something like foundationdb and do a
1
0
6
storing json blobs in a database and de-serializing them with Go feels so good. every time I change the structure, nothing explodes in my face and then a default-initialized struct is returned. 10/10, period.
0
0
6
When ZIRP is over but you're still hoping to get a job to design data-intensive applications.
0
2
8
Claude enables ultra-fast MVP development for more languages.
Previously this was a niche occupied by Django, Rails, and Laravel because they have a nice CLI for generating CRUDs.
In 2024 you can promt a complete SaaS in Go and HTMX in almost no time. What a time to be alive.
0
0
6
Here's a sneak peek at what I've been working on lately - a service that creates promotional packets for software engineers to increase their visibility and chances of getting promoted.
1
1
6
@NickLaptev
Well, a fridge won’t suddenly change the monthly price, make a feature you rely on paid, or charge you 500 more for the electricity it consumes. The egress traffic costs of many serverless vendors are just ridiculously high, so you could get a hefty bill even on a moderate
1
0
6
It was a mistake to start reading on German legal entity structures, taxes, and law compliance. The whole day is gone, and no product improvements has been made :(
0
0
6
Devs, want a promotion? 🚀
I'm building a service to help you showcase your impact and achievements. With AI assistance, we'll create a polished promotional package for your next 1:1 with your manager.
Link in replies. 👇
Comment for free credits at launch!
5
2
7
the best boilerplate is not something you can buy, but rather one you build yourself, bit by bit, from your project launches
1
0
6
TIL: there is a thing called systemd socket activation, and it can buffer incoming connections while you're restarting your systemd unit. Zero-downtime deploys, yay!
0
1
5
writing documents for performance reviews was pretty tedious for me in the past, so I decided to change that.
dev folks, does it resonate with anything from your experience?
cc
@_buildspace
@_nightsweekends
1
0
5
Excited to start my first day at
@MOIAmobility
! The most important part, coffee machine is already figured out :)
3
0
5
Trained my first Atari 2600 agent with the help of
@huggingface
Deep Reinforcement Learning class!
Isn't it adorable?
0
1
5
just coded a persistent LLM prompt queue with rate limiting and load balancing across several inference providers. took 2 hours and 250 lines of code in total.
monoliths in Go give you hyper-productivity.
2
0
5
I reached the peak of server side templating today. I had go structs, arrays, html templates with HTMX and Alpine.js all in one .templ file. All type-checked. Locality of Behavior FTW!
2
0
5
Did you know that by hosting on you give them license to use your data (whatever that means)? Something that will not happen with a good old VPS.
2
1
5
I think that
@github
should have 2 different buttons for approving pull requests:
• One for "I don't see anything bad in this PR"
• Another for "I confirm that this PR is correct"
Although those statements might sound the same, there is a big difference between them.
0
0
5
I fear not the man who has tried 10,000 frameworks once, but I fear the man who had applied one framework to 10,000 projects.
1
0
5
@LotusHints
Pretty much the same. Works fine for a monolith! For something more complex you would need an online schema migration, e.g. read from the old and a new table while migrating the data in the background.
2
0
4
bought a domain name for my LLM wrapper. there is no way back now.
0
0
4
It seems like I’m going to ditch Llama 3 and go full anthropic. I really wanted llama 3 to work, but no matter how I changed the prompt, I couldn’t get the writing style feel right. It always looked fake and AI-generated. Not the case with sonnet 3.5 though.
0
0
4
Time spent reading docs: 1h
Time spent building the thing: 1h
Time spent writing React: 0s
0
0
3
I prepared 5 headlines for the landing page. Showed them to 10 friends, and next day deleted the messages. Asked my friends which one do they still remember. Almost everyone gave the same answer. Super cool trick by
@marc_louvion
0
0
3
How to accelerate turnover in your org:
1. Hire people from abroad and pay them a bare minimum above the visa requirements.
2. Wait until they realize that they have been treated unfairly cos the market salaries are 50% higher.
3. Tell them that "our max pay raise is 10% a year"
0
0
4
One of the best RoI skills to have as an indie-hacker might just be learning the basics of Linux admin.
Linux existed 30 years ago, available now, and will exist in 50 years, unlike the VC funded serverless offerings.
Bonus: you won't get a $100k invoice after a DDoS attack.
0
0
4
Never thought I'd need to implement a vector clock myself, but it seems the time has come!
1
0
4
@andrew_graaff
only vertically with more cores/ram. but that's more than enough to validate the idea and serve quite a few users already.
2
0
4
Is there a good UX/design book for a fellow backend engineer?
I can easily design and deploy distributed systems to k8s, but my UIs look like... made by an engineer and I don't know why.
Any hints highly appreciated!
2
0
4
@androo777
@minchoi
there is a thing called speed of light, not even starlink can help here if the remote worker is on the other side of the globe.
2
0
4
@ThePeterMick
My FE stack of choice is HTMX and Alpine.js. Very simple, gets things done without much pain, and plays well with server side rendering.
0
0
2
Akka streams discovery of the day: a really neat flatMapPrefix thing.
0
1
3
@jonny555333
@siyabuilt
I don’t deny that Vercel has better UX. But VPS gives you ownership and independence. You will only need 20-30 minutes to complete the list above, and you do it once during the server setup.
Also, if you write it as an Ansible playbook, you can spin up a new VPS in seconds.
1
0
3
@schrepfler
@FoundationDB
Yes, but unfortunately it is only available for those who bought the conference tickets. But I have the project on GH:
1
2
3
It’s not “if you build, they will come”, but “if you share valuable stuff, they might want to know your better, start trusting you, notice your product, and if they’re in the market they might even buy it“.
0
0
2
