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.
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.
Pointer·3ymikeroyal/Self-Hosting-Guide: Self-Hosting Guide. Learn all about locally hosting(on premises & private web servers) and managing software applications by yourself or your organization.
Most self-hosted software can be installed using Docker, a packaging system which allows software to bundle their configuration and dependencies. Shipwright is a WebUI to generate templates for Yacht, Portainer, Docker-Compose, and Unraid. Dozzle is a small lightweight application with a web based interface to monitor Docker logs. Diun is a tool that receive notifications when a Docker image is updated.
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.
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.
PostgreSQL·4yPostgreSQL 15 Released!
PostgreSQL 15 builds on the performance improvements of recent releases with noticeable gains for managing workloads in both local and distributed deployments. This release improves the developer experience with the addition of the popular MERGE command, and adds more capabilities for observing the state of the database. The performance improvements extend to its archiving and backup facilities.
Towards Dev·4ySQL or NoSQL ?
Data is the most valuabl e commodity in today’s world. Data storage was expensive and infrastructure wasn’t that developed to efficiently store the massive influx of data. With more and more web applications, need to quickly create and access enormous data became more important. This is when NoSQL came in to rescue.
Changelog·4ymgramin/awesome-db-tools: Everything that makes working with databases easier
Awesome Database Tools is a community driven list of database tools that simplify working with databases for DBA, DevOps, Developers and mere mortals. Feel free to add information about your own db-tools or your favorite third-party db- tools. For updates on awesome-db-tools and thoughts/news about databases/tools/SQL follow me at @GraminMaksim.
Pointer·4yturns any MySQL, Postgres, SQLite into a spreadsheet with REST APIs.
NocoDB turns any database into a smart-spreadsheet. It uses Docker, Git, Npm, Slack, Reddit, and Twitter. NocoDB can search, sort, filter, hide columns with uber ease. It can also upload images to cells (Works with S3, Minio, GCP, Azure, DigitalOcean, Linode, OVH, BackBlaze)
Community Picks·3yPractical data engineering concepts and skills
Data engineers are responsible for wrangling, manipulating, and streaming data to fuel insights and better decision-making. These skills are in high demand, so if you’re looking to make a career change and become a data engineer or develop your existing skill set, this is the article for you.
Dev Genius·4yData Analyst Portfolio Project.
Data Analyst Portfolio Project will cover all the problems, errors, and we'll slide through the project in a step by step manner. To start with the Dataset, we’ll start by cleaning and joining the various tables of the Year 2018, 2019 and 2020 since the dataset is very huge.
Geekflare·4yPostgreSQL vs MySQL: Differences and Similarities
The database system uses multi-version concurrency control (MVCC), MVCC makes a database suitable for concurrent data entry and data queries done by writers. Both the database systems offer account management features like roles, groups, and individual users. Users can simply download the distribution package under the MIT license. Oracle controls the development and maintenance of the DBMS. It is free and available as a server version on GitHub.
Hasura·4yPostgreSQL 15 released: Top things to know
Postgres 15 is a stable release of their latest major version of their major version 15. Let us look at the top features and changes in this release and how it will impact usage going forward. The MERGE command is one of the newest additions to the Postgres DB with the v15 release. Most vendors currently support the latest Postgres v14.4 stable release.
System Weakness·3yLet’s Learn SQL - Learning Web-Sec - Day 1
Let’s Learn SQL - Learning Web-Sec - Day 1 Getting Hands Dirty With SQL Caspar Camille Rubin on Unsplash Keep reading and I promise to teach you hours of what I learnt today in just a few minutes. Feel free to comment below about things that need a better explanation or if there's any type or mistake.
Community Picks·4yWhat is a Materialized View?
Materialized views should update automatically, but this has so far proven impossible to deliver on. Not every database supports materialized views, and those that do each handle them a little differently, especially when it comes to the approach to view maintenance. MongoDB Yes, in 4.2+ Manual MongoDB has a NoSQL equivalent of materialized view.