#

sql-logs

Here are 3 public repositories matching this topic...

macbre / index-digest

Star

Open

Report unique indices that cover nullable columns

macbre commented Mar 10, 2020

https://dev.mysql.com/doc/refman/8.0/en/create-index.html#create-index-unique

A UNIQUE index permits multiple NULL values for columns that can contain NULL.

Links

https://medium.com/@aleksandrasays/dealing-with-mysql-nulls-and-unique-constraint-d260f6b40e60

Examples

CREATE TABLE `progress` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `plan_id` int(1

Read more

linters

Open

Suggest VARBINARY for storing IP addresses

Open

Handle SHOW PROCESSLIST results as an input

1

macbre / data-flow-graph

Star

Uses your app logs to visualize how the data moves between the code, database, HTTP services, message queue, external storages etc.

visualization mysql graphviz elasticsearch query kibana sql database sustainability graph data-flow performance-visualization d3js graphviz-dot d3-visualization sankey-diagram sql-logs sus

Updated Nov 4, 2019
Python

macbre / query-digest

Star

A dynamic code analysis tool that processes SQL queries logs and data flow information

mysql elasticsearch query sql database sustainability data-flow performance-visualization sql-logs sus query-digest

Updated Dec 9, 2018
Python

Improve this page

Add a description, image, and links to the sql-logs topic page so that developers can more easily learn about it.

Curate this topic

Add this topic to your repo

To associate your repository with the sql-logs topic, visit your repo's landing page and select "manage topics."

You can’t perform that action at this time.