Hacker News·4ypocketbase/pocketbase: Open Source realtime backend in 1 file
PocketBase is an open source Go framework/toolkit that enables you to build your own custom app specific business logic. It embeds a realtime subscriptions database with backed-in files and users management. It has a simple REST-ish API and comes with unit and integration tests.
KDnuggets·4yThe 5 Hardest Things to do in SQL
The Cloud Data Warehouse offers the power of centralizing compute within the cloud. However, this comes with its own set of downsides. One of the primary drawbacks is that you must learn and execute queries in different languages, specifically SQL. The switch over to cloud data warehouses increases the utility of complex SQL versus python.
Tinybird·4yHow we recreated r/place with 10 lines of SQL
The 2022 r/place event was a social experiment where millions of users from across the internet vied for pixel dominance. In less than 45 minutes we used Tinybird and some Javascript to recreate the 2022 canvas, plus build a new canvas of our own. We recently shared 8 challenges building high-concurrency, low-latency data apps on massive-scale data.
ITNEXT·4yRepository Patterns: Databases Made Easy
The repository is the translator layer. You simply ask your repository to create an item to the datastore and the repository translates that request to SQL or to any other querying language. Your application does not need to know the type of the database or how to interact with it. It just communicates with the repository that translates the generic commands to the language the database understands.
Analytics Vidhya·4yTop 10 Mistakes to avoid in SQL Query
This article will describe all the common mistakes we can avoid by practicing SQL often and how to resolve them. It is a good practice to make mistakes but not repeat them in the future. The order of execution of a query should not be ignored at any cost. Don’t use the Distinct statement to find the unique rows corresponding to the selected columns.
Dev Genius·4ySQL for Product Managers
SQL for Product Managers Data is for a Product Manager what a good sword is to an assassin. The most important operation for you would be the ‘Retrieve’ operation to analyze existing data. The devs might also opt for a NoSQL database which scales better in some cases. You can create an ERD on www.