dbdiagram.io Release Notes
dbdiagram.io Release Notes and Roadmap. dbdiagram is a quick and simple free tool to help you draw your database relationship diagrams and flow quickly using simple DSL language.
Data Engineering
Databases
dbdocs.io - Database Documentation and Catalog Tool
A free, simple, developer-friendly tool to help you create web-based documentation for your database
A Free Database Designer for Developers and Analysts
Quick and simple free tool to help you draw your database relationship diagrams and flow quickly using just keyboard
Create Star Schema Data Model in SQL Server with Microsoft Toolset
Learn the step by step process to create a Star Schema in SQL Server with the SQL Server Data Tools, Management Studio and more.
ETL Database - a guide to ETL/ELT for data engineers and data analysts
ETL database is an introductory guide to ETL. Learn about ETL process, types of transforms, common ETL challenges, and much more.
Data and Database Tools Catalog - DBMS Tools
Most complete list of data dictionary and database documentation tools on the web. Probably.
Stored Procedure in SQL Server with R Code
In this article we will explore how to create custom stored procedures using R which is basically an R function that can be called from a SQL Server stored procedure.
DB Connection Pools: Essential Knowledge for Web Developers
Typical data-driven web apps need a Database (DB) connection to render almost every page or to serve every API call. For scalability reasons, Web Server and Database servers are hosted on different Machines.
What are Materialized Views? A 5 Minute Introduction
A materialized view is a type of database object that contains any results derived from a query. Read on for a quick introduction.
Database-Projects/README.md at master · Uppalapa/Database-Projects
SQL. Contribute to Uppalapa/Database-Projects development by creating an account on GitHub.
Sciencificity's Blog: Using the tidyverse with Databases - Part II
I was serious, you don't need to be a SQL expert to work with Databases through R
ConnectionStrings.com - Forgot that connection string? Get it here!
All connection strings in one place. Find the syntax for your database connection using ADO.NET, ADO, ODBC, OLEDB, C#, VB, VB.NET, ASP.NET and more.
r-dbi/odbc: Connect to ODBC databases (using the DBI interface)
Connect to ODBC databases (using the DBI interface) - r-dbi/odbc
Strategies for connecting Shiny applications to databases – RStudio Support
Broadly speaking, there are two strategies for connecting a shiny application to a database using secure authentication. The first is running the application as a service account. The second is run...
SQL Injection Prevention - OWASP Cheat Sheet Series
Website with the collection of all the cheat sheets of the project.
smbache/squr: Structured Query Utility for R
Structured Query Utility for R. Contribute to smbache/squr development by creating an account on GitHub.