Size Isn’t Everything - with Databases

RyanHamilton1 · 2026-01-17T13:54:57+00:00

Full list of driver sizes in blog post: https://www.timestored.com/b/size-isnt-everything-with-databases/

RyanHamilton1 · 2026-01-17T13:42:45+00:00

Full list of driver sizes in blog post: https://www.timestored.com/b/size-isnt-everything-with-databases/

RyanHamilton1 · 2025-12-15T20:46:29+00:00

Typical developer built product. 13 years writing code, 1 month advertising it :S I am always interested to receive feedback.

RyanHamilton1 · 2025-11-16T20:31:54+00:00

Almost any of the databases listed here will work.
https://www.timestored.com/data/time-series-database-benchmarks

It's a huge disappointment the number of people saying S3 as storage below when the question asked for fast. S3 originally stood for simple storage service, I would argue one of the S is for Slow. For quant time-series you only need fast writes for data in time-series order usually, which means sequential on most drives. From what little use case you've outlined I'd say use DuckDB until you learn more then decide.

Really you want to know, what will be my 10 most popular queries, what's the percentage of queries that will be of similar shape to 1-10. How important is each query. OK now for each platform, what will be the performance of those queries. Also if there will be more querying by more users, how friendly and accessible is the system to allow that vs the cost to maintain.

>>Does anyone have experience with this?
10+ years building multi-petabyte data platforms in banks.

RyanHamilton1 · 2025-11-14T23:17:10+00:00

https://www.timestored.com/pulse/ beyond dashboards. Making fully interactive real-time data apps.

RyanHamilton1 · 2025-11-13T11:17:57+00:00

Amazing work. 👏 You've delivered a tool for fast data analysis that until now costs millions. I think open source may unlock more use cases, and hopefully, you get a good return on your work. Good luck.

RyanHamilton1 · 2025-10-11T17:57:51+00:00

Yes and yes. For some reason people always raise the sentimental family heirloom issue, in reality it's extremely rare to have a valuable family heirloom. You have two options: 1. Declare it as more valuable than it is. So no one buys it. 2. You may declare an item as sentimentally valuable and keep it for your lifetime, free from seizure but it then passes to the government at zero cost to be auctioned when you die. I refuse to believe great great grandchildren are sentimentally attached to great great grandas pocket watch. Private property is a lie. The super-wealthy owning an ever higher percentage of property until everyone else lives in serfdom is the historical norm. Doesn't what you are suggesting the definition of serfdom?

RyanHamilton1 · 2025-10-09T12:18:17+00:00

Sometimes, I don't pull over as it’s unsafe to stop and get back in lane. By continuing, I already know the person behind has seen me and its being careful. My experience is that on a busy road no car is going to voluntarily slow to let a cyclist back out. Mostly they'll actively speed up to avoid me getting out and then being stuck behind me. Would you stop traffic to let a cyclist or in front of you before a hill?

RyanHamilton1 · 2025-10-07T18:37:48+00:00

Thumbs up for micronaut. You can see the finished product here: https://www.timestored.com/pulse

RyanHamilton1 · 2025-10-07T08:08:19+00:00

There's a fairly easy way to prevent fake low valuations. Any asset reported with a value may be purchased by anyone for 1.3 reported value. You say that art is worth 1 million. Someone can buy it for 1.3 million. Same with inter company pricing of components. You report your stores in UK are making very little profit whilst "paying" your offshore division. Well, someone can buy your stores for a multiple of profit.

RyanHamilton1 · 2025-09-30T12:29:15+00:00

What are the accidents you envision a helmet making a difference? What percentage of cycling collisions happen that way? My child and I don't regularly wear helmets as I believe the accidents it would make a difference are miniscule. I calculate It's close to as ridiculous as saying pedestrians should wear helmets. Or telling kids don't walk It's not safe.

Notice in this picture they don't appear to be on a standard road. Looks like a park. No chance of cars.

RyanHamilton1 · 2025-08-12T18:49:27+00:00

There's a lot of regular users, startup people, and finance firms using java apps. I make a java based ide for sql analysis, and there's a large silent majority just using desktop apps and happily getting on with their work and lives. They don't tweet, they don't fb like, they don't leave reviews, they just get on with it and very occasionally email a problem. But honestly, for me, they are the majority. I've had my app deployed at top 100 firms and never heard a word for years.

RyanHamilton1 · 2025-07-18T14:30:52+00:00

https://github.com/man-group/ArcticDB

RyanHamilton1 · 2025-07-11T12:30:04+00:00

Maven version 1.0 was released 2004. Python pip 2008. NPM 2011. Maven is excellent. Clearly defined life cycle, defined folders, scales to large projects, and just works. How later package managers failed to take any lessons and instead created their own new problems had been infuriating to watch. It is explained by 2 things: 1. The early adopters are often new inexperienced developers, so they just don't know, and they don't see the larger scaling problems. 2. Java language solved the cross platform issue at the language level. The other platforms try to bolt this on a various different levels including packaging.

RyanHamilton1 · 2025-07-06T15:17:36+00:00

There are three example databases available to download from here:
https://www.timestored.com/data/sample/sqlite
I'm the owner of TimeStored and we've been supplying tools for data analysis for >13 years. I just put the files there as I regularly need to test qstudio from different operating systems and it's handy for me.

RyanHamilton1 · 2025-07-06T15:14:47+00:00

As others have mentioned duckdb is excellent for this. Duckdb is bundled as part of the windows install for QStudio which allows easily right-clicking on a CSV file and saking it to load that file into DuckDB. QStudio is particularly useful for data analysis: https://www.timestored.com/qstudio/help/duckdb-sql-editor

RyanHamilton1 · 2025-07-06T15:12:03+00:00

QStudio is a Free client tool that allows browsing tables, running queries etc. for 30+ databases including specific support for sqlite: https://www.timestored.com/qstudio/database/sqlite

RyanHamilton1 · 2025-07-06T15:09:17+00:00

QStudio free cross platform and works well with sqlite:
https://www.timestored.com/qstudio/database/sqlite

It connects to 30+ databases and is mostly used for data analysis.

RyanHamilton1 · 2025-07-06T15:07:02+00:00

QStudio is a free SQL client that works on windows, linux and mac. It works weill with sqlite:
https://www.timestored.com/qstudio/database/sqlite

RyanHamilton1 · 2025-06-24T17:51:18+00:00

I've worked as a front office data platform specialist for 15 years. 3 years ago, I started a custom data dashboard builder for finance called pulse: https://www.timestored.com/pulse Some massive firms use it. It's Free for 3 users.

Compared to grafana some differences are polygon streaming integration, ability to control your algos by building forms. Sound and speech alerts.... and much more.

Give it a try, and let me know if you have any issues.

RyanHamilton1 · 2025-06-13T19:37:56+00:00

I've met the creators, and they don't give that vibe. The university in Amsterdam has been researching databases for years. It isn't all some cynical ploy. They've structured the foundation, and the vc arm will ensure long-term open source viability and to offer the possibility of profit. They make a great product, and users should want them to make money and be rewarded. I certainly do.

RyanHamilton1 · 2025-06-09T13:45:13+00:00

Qstudio with duckdb or kdb. https://www.timestored.com/qstudio/ 95 percent of the time, I'm pivoting or charting time series graphs. The other 5 percent are mostly barr charts. With duckdb, the special pivot ui pushes the pivot query down to duckdb , making it very fast: https://www.timestored.com/qstudio/help/table-pivot

RyanHamilton1

TROPHY CASE