freeCodeCamp·4yHarvard CS50 – Free Computer Science University Course
Harvard CS50 is one of the most popular beginner computer science courses in the world. The course teaches students how to think algorithmically and solve problems efficiently. Topics include abstraction, algorithms, data structures, encapsulation, resource management, security, software engineering, and web programming.
Community Picks·4ySoftware Engineer Interview: The Interview Study Guide For Software Engineers
Ben Rogojan created a checklist on his last round of interviews that covers many of the popular topics. To help you keep track of your progress, we've compiled a comprehensive checklist of the same problems listed below.
Geekflare·4yUltimate SQL Cheat Sheet to Bookmark for Later [2022]
SQL is a set of commands for managing relational database operations like delete, create, update, read, and so on. There are four types of SQL commands: Data Definition Language (DDL), Data Manipulation Language (DML) and Data Control Language. The cheat sheet will help you quickly reference the required commands with the correct syntax.
Product Hunt·3yAI Query - Generate SQL Queries with AI in Seconds
The fastest way for engineers to generate queries using basic English and let AI do the heavy lifting for you. With AI Query anyone can create efficient queries, without even knowing a thing about it. AI Query is not rated yet. This is AI Query's first launch.
gitconnected·3yUltimate 10 Stages to Master Backend Development
Backend development refers to server-side programming in which a developer creates application architecture and business logic to process and store the data and output useful information. There are multiple backend programming languages, frameworks, and stacks like JavaScript, Python, PHP, Java, Ruby, etc.
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.
Honeypot·4yDolt - A SQL Database that Works like Git
Dolt is an SQL-based database that allows you to maintain your database like Git repositories. It combines all the great features of Git and SQL in order to give you an amazing experience. Dolt comes with a powerful CLI similar to Git, and you can apply your knowledge in Git to easily commit, merge, and push database changes. Earn Money from DoltHub Data Bounties.
DEV·4yDatabase GUIs in JavaScript
Traditional tools are often written in Java, C++ or Delphi and they use good old JDBC, ODBC or ADO.NET drivers for accessing database. Almost all tools are open-source. If you know about other tool not listed in this article, you could write about it in comments below. For SQLlite I actually use Firefox.
Pointer·4ybregman-arie/devops-exercises: Linux, Jenkins, AWS, SRE, Prometheus, Docker, Python, Ansible, Git, Kubernetes, Terraform, OpenStack, SQL, NoSQL, Azure, GCP, DNS, Elastic, Network, Virtualization. DevO
This repo contains questions and exercises on various technical topics, sometimes related to DevOps and SRE. There are currently 2292 exercises and questions. You can use these for preparing for an interview but most of the questions don't represent an actual interview. Join our DevOps community where we have discussions and share resources.
Three Dots Labs·3yThe Go libraries that never failed us: 22 libraries you need to know
Awesome Go contains over 2600 libraries, but popularity is not always the best indicator of library quality. It’s generally better to use libraries instead of frameworks for long-term projects. We’ve included some common anti-patterns to help you avoid making those mistakes.
SQL Shack·3y5 Best Practices for writing SQL queries
Queries are used to communicate with the databases and perform the database operations. We use the queries to update data on a database or retrieve data from the database. In addition to performing accurate database operations, a query also needs to be performance, fast and readable. Microsoft offers two different tools to develop queries.
CockroachDB·4ySQL Cheat Sheet – Quick and Easy SQL Command Reference Examples
This cheat sheet is designed to make it quick and easy to find that SQL command that’s right on the tip of your tongue. It’ll also be available in a printer-friendly, downloadable PDF form so that you can print it out and reference it easily from your desk.
Supabase·3yWhat's new in Postgres 15?
The Postgres community released version 15 (stable) in October 2022. The permission model is more secure permission is revoked from all users except the database owner. It makes permission assigning more tunable ( details) Sorting rows of data is a frequent operation inside the Postgres code.
Hashnode·4yNode.js ORMs overview and comparison
ORM is a library to access the database, high-level library where you can define models, relations. Ideal ORM allows to define queries and then combine and reuse them to construct more complex queries. I'll share my experience of working with 6 popular ORMs including knex which is query builder.
Fauna·3ySide-by-side comparison of serverless databases
Serverless databases make it easy to build and scale your application because they abstract away the underlying infrastructure and automatically scale to meet the need of your application. With MongoDB, you don’t have to manage any infrastructure by yourself. This article compares commonly used serverless databases so you can make an informed decision.
ITNEXT·4yTechniques for Optimising SQL Queries
The power of Explain will give a detailed information on what our query will do and how much it’ll cost in time when executed. This is one of the most common mistakes that I’ve seen a lot of people doing, regardless of their level of experience or years in the industry.
Hacker News·4ydolthub/dolt: Dolt – It's Git for Data
Dolt is a single 68 megabyte program. It can be used to run queries or update the data using SQL commands. All the commands you know for Git work exactly the same for Dolt. We also built DoltHub, a place to share Dolt databases. If you want to host your own version of Dolt, we have DoltLab.
Product Hunt·3yhubble - Github star manager
The best of Product Hunt, everyday Web3 Keep up to date with the latest in web3 Community Discussions Ask questions, find support and connect Stories Tech news, interviews and tips from Makers Changelog Release notes from the Product Hunt team Office hours Give feedback directly to our product team Visit streaks.
asayer·4yBuilding CRUD Apps with NextJs
A CRUD application refers to an app that can perform four simple functions: Creating, Reading, Updating, and Deleting data. For example, blog sites need dynamic content management for productivity. With CRUD functionality, we can carry out these functions in our application. Next.js as our case study to look at how CRUD implementation works.
Supabase·4ySupabase Vault
Supabase Vault is a Postgres extension for managing secrets and encryption inside your database. For self-hosting, pgsodium supports a variety of ways to place the root key into Postgres. To see the decrypted data, there is a special view created called vault. The actual raw key is not available to you in SQL, it is managed entirely outside of the SQL language in the Postgres server. If you take a backup or pause your project, that data remains encrypted.
