I started this blog to learn PostgreSQL primarily, but it ballooned into learning a couple other technologies and frameworks. The backend of this site is powered by a Node.js REST API (with ExpressJS) for querying my Postgres db server. The frontend site was developed with Next.js, which I chose because it seems to be the standard React framework at the moment. Next utilizes server side rendering (the JS is executed server side and the generated HTML is served to the browser), which makes sense for my use case. I think this also falls within my platonic ideal of what a webserver is; a server that sends a static webpage to a client. I've used PHP to build simple sites in the past, which one could say is inherently server side rendered, so I guess that's a neat feature for React to have :^)
I started my data career working with Microsoft SQL Server, which is a robust RDBMS by any definition, but I've been making efforts to become adept with the Free and Open Source offerings, which have been steadily growing in popularity. PostgreSQL was actually the first database system I installed for my homelab way back when I was first learning SQL and tech skills and general, so it's also a matter nostalgia. I'd also like to avoid giving Larry Ellison more money.
Postgres has a lot of interesting features to compare and contrast with SQL Server, so expect some articles of me exploring that, too.
The site is a bit barebones at the moment, but I'm looking to add some features in the near future. I'd like to add a way for viewers to subscribe and get email notifications for new posts. Similarly, I'd also like to add an RSS feed. I'll furthermore be writing some articles on the cloud infrastructure deployments and configurations I performed using Terraform and Ansible. Exciting stuff to come.
Until next time - Div