Oct 09
Overview of available type of indexes in different database engines and corresponding use cases. So, you have some data. Most likely you want to work with it – i.e. retrieve information according to some conditions = filtering what is important for you. Probably, even change the shape of this information – transform the data or …
Sep 16
My ultimate SQL Memo
LLM derive schema from unstructured data and build pyspark ETLs
still, understanding what you can do via plain SQL – allow you to choose what to ask and leverage insights from the data much more efficient
no magick wand – hard work 🙂
Aug 30
Use Postgres! Use whatever you have the most experience with! Every software design discussion should start with the game of questions to clarify what we are about to build. And what not. Boundaries are important to have a clear cut from a very shiny but probably too remote future with hundreds of thousands requests per …
Nov 02
hype wave, pragmatic evidence vs need to move fast Tech side of startups sometimes can be very fluid and contain a lot of unknowns. What tech stack to use? Which components might be overkill for now but worth keeping an eye for in the future? How to balance the pace of business features development while …
Feb 17
The cart goes nowhere because the swan wants to fly in the air, the pike wants to swim underwater and the crawfish wants to crawl backward. Cassandra is one of powerhorse of modern high load landscape – nosql database that can be pluged to Spark for distributed computing, Titan for playing with graph data representation …