jakozaur

9 ms·

91.
by jakozaur 2y ago
Looks like Snowflake was the first popular warehouse to have variant type which could put JSON values into separate columns. It turned out great idea which inspired other databases.
92.
by jakozaur 2y ago
It's good for small data, but the Iceberg format would be nicer for bigger data sets.
93.
by jakozaur 2y ago
A similar explanation could be applied to columnar vs row databases.
94.
by jakozaur 2y ago
Iceberg was acquired for $1Bln to create a similar standard called Iceberg. It's worth highlighting the pros/cons of this approach. Pros: + straightforward, no running metadata server needed, scales to zero compute + zero-copy clo
95.
SQL from a Programming Language Perspective – Part I(quesma.com)
1 points by jakozaur 2y ago|0 comments
96.
by jakozaur 2y ago
The title is misleading, it may suggest Harvard or MIT lost $800M. In fact, Harvard and MIT invested $30M each and sold EdX for $800M to 2U: https://www.edsurge.com/news/2021-06-29-2u-buys-edx-for-800m... So, likely, H
97.
The pancake SQL pattern: combine your SQLs into one for 50x better performance(quesma.com)
2 points by jakozaur 2y ago|0 comments
98.
Schema Migrations: Pitfalls and Risks(quesma.com)
2 points by jakozaur 2y ago|0 comments
99.
by jakozaur 2y ago
I co-founded a startup, Quesma, with one case to assist with database migrations. Big (e.g. move from tech X to Y) and small (schema change to add one column). I did a fair amount of customer research and noticed almost all successful migra
100.
by jakozaur 2y ago
It is very common that the majority of work happens during business hours. In some setups it's easy. It's better to get beefy instance during that time and avoid having it running all the time.
101.
by jakozaur 2y ago
Servers grow much bigger. 256GB of RAM is pretty much a standard rack server on a major cloud. On AWS, ultra memory with 24TB of RAM is one API call away from you :-). The article took note of that, but tooling on one node puzzles me. So, m
102.
What SQL Could Learn from Elasticsearch Query DSL?(quesma.com)
1 points by jakozaur 2y ago|0 comments
103.
by jakozaur 2y ago
The dispute happens only if one party owns the trademark and sends a Cease & Desist letter. Different companies have different approaches to aggression here. Second, it has to prove that it confuses customers (e.g. if you pick ten end u
104.
by jakozaur 2y ago
Sorry to say, but this looks like a trademark violation. Though the project may be cool, it immediately put me off: https://www.trademarkia.com/perplexityai-98400215 I'm not a lawyer, but trademarks are well protected.
105.
Elasticsearch and OpenSearch schema rough edges(quesma.com)
3 points by jakozaur 2y ago|0 comments
106.
by jakozaur 2y ago
Jakub Pachocki is amazing. He was in top 20 in Polish algorithm competition: https://oi.edu.pl/contestants/Jakub%20Pachocki/
107.
by jakozaur 2y ago
Amazon is an outlier, where each business runs its profit/loss, and higher-ups act as VCs. Wish more companies were like that, but you need to take a lot of bets to make that work. AWS worked, but the Fire phone turned out to be a writ
108.
by jakozaur 2y ago
It is tough to keep two widely different businesses under one roof. One is a mature, public B2C, and the other is a dev tooling startup. Spotify should spin off Backstage as a separate company, providing the initial IP and funding and being
109.
by jakozaur 2y ago
This is a more dramatic version but less accurate. The better take is on: https://forums.guru3d.com/threads/nvidias-aborted-nv2-chip-a... 1. Sega knew earlier that triangle architecture made more sense, but NVIDIA did
110.
by jakozaur 2y ago
Should we migrate to OpenTofu?
111.
Fair Use Wins: Court Sides with Cribl in Splunk's Lawsuit(globenewswire.com)
3 points by jakozaur 2y ago|0 comments
112.
by jakozaur 3y ago
Congratulations! Though I can't still wrap my head around it: 1. Terraform needs to produce hydrogen using electrolysis. Turning hydrogen into natural gas requires more equipment and energy. 2. Simultaneously, we transform natural gas
113.
by jakozaur 3y ago
I see a lot of these types of tools, each with some essential support, but usually they don't work. I would appreciate what is support what is not. Tried this tool: go run gitlab.com/dalibo/transqlate@v0.1-beta.2 select TRUNC
114.
by jakozaur 3y ago
Some observation: 1. Google Big Query is super powerful, but it's straightforward to shoot yourself in the foot and end up with a huge bill. I would agree that Big Query shines for advanced users. For regular, it's better to use t
115.
Full-text search X times faster: Inverted index vs. SQL OLAP(quesma.com)
3 points by jakozaur 3y ago|0 comments
116.
by jakozaur 3y ago
Congratulations! The FixIt seems a pragmatic feature. Any other ideas about where you plan to utilize LLM? E.g. - migrate from different SQL dialects (e.g. date functions) - make my queries nicer (e.g., rewrite them in shorter form or use b
117.
by jakozaur 3y ago
Dandelion Energy already uses sonic drilling for heat pumps: https://dandelionenergy.com/installing-geothermal-through-be... Dandelion Energy is a Google X spinoff. Quote "Dandelion developed an innovative and propriet
118.
by jakozaur 3y ago
Defaults. Either as a code or using click ops. Many companies run servers without considering AZ. Then you can get the "best" of the worlds: 1. Your service is down if either of AZs gets hiccups. 2. You pay network charges and lat
119.
by jakozaur 3y ago
S3 is a nice trick. More tricks: 1. Ask for discounts if you are a big AWS customer (e.g., spend $1mln+/year). At some point, they were huge for inter-AZ transfers. 2. Put things in one AZ. Running DB in "b" zone and your onl
120.
by jakozaur 3y ago
I wonder how it compares to mechanical air-purifying. Though certainly, we need more innovation in this area.

More ›