DevDojoĀ·5yš The Missing SQL Basics Crash Course
This guide is suitable for anyone working as a developer, system administrator, or a DevOps engineer and wants to learn the basics of SQL. We will first learn how to install the free, open-source, and widely used database service, MySQL. Then we will create our first database using the command line.
SweetcodeĀ·5yTop 10 SQL Commands Everyone Should Know
Theo Despoudis is a Senior Software Engineer and an experienced mentor. He has a keen interest in Open Source Architectures, Cloud Computing, best practices and functional programming. He occasionally blogs on several publishing platforms and enjoys creating projects from inspiration. He is a member of the Linux Foundation and the Apache Software Foundation.
HashnodeĀ·5yComplete web development roadmap for newbies
This list consists of beginner languages and tools. Advanced topics are not covered. HTML is by far the easiest to learn. JavaScript is a multi-paradigm, high-level language which has evolved to become one of the most popular languages not just in web development but in many other fields.
SitePointĀ·5y9 Best JavaScript and TypeScript ORMs for 2021
Object relational mapping (ORM) makes it possible for you to write queries in the language of your choice. An ORM is beneficial for medium- to large-scale projects that source data from hundreds of database tables. Using an ORM library to build your data layer helps ensure that the database will always remain in a consistent state.
JavaScript in Plain EnglishĀ·5yUse SQL Query Builder Knex.js with Node.js and Express.js
Knex.js is a thin abstraction that sits on top of the database driver for relational databases. It supports transactions, connection pooling, streaming queries, a thorough test suite, and the ability to run in the browser. Knex can be used in both Node.Js and the browser, limited only by WebSQLās constraints.
Geek CultureĀ·5yShould I Use MongoDB or PostgreSQL?
MongoDB and Postgres are two of the most popular databases. We are going to cover their key features, functionality, performance, and their use cases. MongoDB is a schema-free document-oriented store. Postgres is ideal for transactional workflows that make it reliable in production.
Product HuntĀ·4yArctype - Supercharged SQL client for developers and teams
Arctype is a fast, beautiful database GUI for developers and teams. With SQL autocomplete, spreadsheet-style editing, one-click visualizations, collaboration, and the best support for Postgres, MySQL, and PlanetScale - you'll finally love working with your DB.
daily.devĀ·5yš„ What's Hot in Web Development? ā Weekly Picks #164
We also cover the upcoming Ubuntu 21.04 release, a React roadmap, and a few more interesting articles. If you are not familiar with ReScript yet, we have two articles this week that will help you with your first steps. We will come back with another list of interesting development posts next week.
Product HuntĀ·5yDB Lens - Explore data, execute SQL, metrics, disk usage & more
DB Lens is an opensource database client for Mac, Linux & Windows. It helps developers to explore, observe & understand the database in a better way. DB Lens is available in English, French, German, Italian, Spanish, Portuguese, Italian and Spanish. It is available as a free download or as a paid version.
ITNEXTĀ·5yNoSQL does not meanĀ !Relational
Most data that we use has relationships of some sort. Letās see how we create and reference relational data in MySQL vs something like Google Cloud Firestore. Iāll use a food ordering app that has users , restaurants , dishes and orders. In Firestore, they store documents in collections rather than tables.
Product HuntĀ·4ySQL playground - Free private sample PostgreSQL databases
No local installations or spinning up cloud instances. Choose a database type, and get a unique connection string right away. Create a private Postgres database with a predefined structure & test data in the shortest time. No database installation, no local installations, and no cloud instances to spin up.
ChangelogĀ·5yHow we built a forever-free serverless SQL database
After 18 months of challenging work, weāve launched the first truly scalable Serverless SQL database. CockroachDB Serverless is āforever free,ā with a generous (and never-ending) monthly credit for requests and storage. It automatically and transparently scales to meet your needs, no matter how big or small, with no changes to your application. It supports online schema migrations, Postgres compatibility, and gives you access to Enterprise features.
UbuntuĀ·5yUbuntu 21.04 is here
Ubuntu 21.04 is here Canonical on 22 April 2021. It includes native Microsoft Active Directory integration, Wayland graphics by default, and a Flutter application development SDK. Separately, Canonical and Microsoft announced performance optimization and joint support for Microsoft SQL Server on Ubuntu.
ChangelogĀ·4yslashbase/slashbase: The open-source collaborative IDE for your databases.
Slashbase is an open-source collaborative IDE for your databases in your browser. Connect to your database, browse data, run a bunch of SQL commands or share queries with your team, right from your browser! It's written in Golang and Nextjs React Framework (SPA) and runs as a single Linux binary with Postgres.
MediumĀ·5ydBizzy: An Intuitive VSCode Extension for Database Development
dBizzy is an intuitive VSCode extension for early-stage database development. It gives you the ability to visualize your ER diagrams and test queries on local instances of your databases. It's lightweight, supports real-time rendering and exporting of ER diagrams, and the local database instances only persist in memory for the duration of your tabās session. The other half ofdBizzy streamlines the query testing aspects of constructing a database.
Hacker NewsĀ·4yDatabases in 2021: A Year in Review
It was a wild year for the database industry, with newcomers overtaking the old guard and vendors fighting over benchmark numbers. We also had to say goodbye to some of our database friends through acquisitions, bankruptcies, or retractions. Here are some of the highlights and a few of my thoughts on what they might mean for the field of databases.
thoughbotĀ·5yWhat technologies should I learn?
The advice below is targeted to an early career teammate at thoughtbot. Many newcomers to the industry flit from one language to another but donāt master any of them and stay stuck with a shallow skill set. There are some evergreen skills that will help you throughout a career in web development regardless of what languages come and go.
Towards DevĀ·4yThe Power of SQL
Structured Query Language or SQL was created by Edgard Codd in 1970 at IBM in order to deal with the large amounts of data that was coming to the world on a regular basis. It has been over 50 years since SQL has come to be and yet it still one of the most widely utilized programming languages today. A recent analysis from dataquest.io showed that out of 32,000 jobs that mention the key word ādataā in it, SQL is one of. the top programming languages to have as a skill set when applying to jobs.
LogRocketĀ·5yCRUD with Golang and CockroachDB
CockroachDB is a fast database thatās easy to set up. It scales easily (without the manual complexity of sharding), rebalances and repairs itself automatically. The app we will be building is a full-stack web app that allows us to get, add, update, and delete names.
Towards Data ScienceĀ·5yTake your SQL from Good to Great: Part 3
Inner JOIN is a way to join two tables based on some time logic. Range JOINs are a more refined way to merge two tables together. Lateral joins allow you to access columns after the FROM statement. BigQuery uses implicit Lateral Joins via a UNNEST tool.
