Pinned Repositories
animated_chart
example of animated chart in jupyter notebook using pandas
check_sql_mode_pipes_as_concat
MemSQL UDF to check if sql_mode = PIPES_AS_CONCAT
cockroach
CockroachDB - the open source, cloud-native distributed SQL database.
compare_databases_table_counts
compares MemSQL table count to Druid
crdb_check_user_passwords
script to check for default user passwords
dbcheck
checks MemSQL databases in list to see if they are online. prints error if they are not.
from_unix_microsecond
MemSQL function to convert unix microsecond timestamp into a timestamp with microsecond level precision
graph_FORScan_data
graph ODBII vehicle data from FORScan using pandas. takes in raw files from FORScan, plots all of the data in relation to time and RPM.
memsql_procedure_backup
Shell script to dump all stored procedures from MemSQL cluster
python-vesync-etekcity-api
API to VeSync Etekcity smart plugs
mikeczabator's Repositories
mikeczabator/graph_FORScan_data
graph ODBII vehicle data from FORScan using pandas. takes in raw files from FORScan, plots all of the data in relation to time and RPM.
mikeczabator/python-vesync-etekcity-api
API to VeSync Etekcity smart plugs
mikeczabator/animated_chart
example of animated chart in jupyter notebook using pandas
mikeczabator/memsql_procedure_backup
Shell script to dump all stored procedures from MemSQL cluster
mikeczabator/check_sql_mode_pipes_as_concat
MemSQL UDF to check if sql_mode = PIPES_AS_CONCAT
mikeczabator/cockroach
CockroachDB - the open source, cloud-native distributed SQL database.
mikeczabator/compare_databases_table_counts
compares MemSQL table count to Druid
mikeczabator/crdb_check_user_passwords
script to check for default user passwords
mikeczabator/dbcheck
checks MemSQL databases in list to see if they are online. prints error if they are not.
mikeczabator/from_unix_microsecond
MemSQL function to convert unix microsecond timestamp into a timestamp with microsecond level precision
mikeczabator/gateio-crypto-trading-bot-binance-announcements-new-coins
This is a crypto trading bot that scans the Binance Annoucements page for new coins, and places trades on Gateio
mikeczabator/json_export
Formats a SQL result set in a JSON format. Built and tested for MySQL and MemSQL
mikeczabator/kafka_messages_in_topics
prints the topics and number of messages in each topic on the local kafka broker
mikeczabator/kafkacat_redhat_build
Version 1.5.0-4-ge461fb (JSON, Avro, librdkafka 1.1.0 builtin.features=snappy,sasl,regex,lz4,sasl_plain,plugins,zstd)
mikeczabator/mask_cluster_report
Removes the IP addresses from the MemSQL cluster report.
mikeczabator/MemSQL-MPSQL-QUOTENAME
QUOTENAME function for MemSQL MPSQL which mimics the functionality of T-SQL QUOTENAME
mikeczabator/memsql_hosts_network_check
check latency and ping for the hosts in memsql-admin list-nodes
mikeczabator/memsql_os_config
RHEL OS settings for MemSQL
mikeczabator/memsql_pipeline_offset_summary
memsql pipeline offset summary
mikeczabator/memsql_reads_writes
Displays the `Rows_affected_by_writes` / `Rows_returned_by_reads` value deltas at set intervals.
mikeczabator/mikeczabator.github.io
mikeczabator/parse_cmep
Parse a delimited CMEP file to a single value row CSV
mikeczabator/python_webserver
lightweight python webserver with logging
mikeczabator/records_per_second
runs a count(*) on a table every 1 second, and calculated the delta at each interval, effectively giving you a rough RPS in a single table.
mikeczabator/spool_file
spools a file in configurable batches and intervals
mikeczabator/syncthing_manager
syncthing tools for windows and linux
mikeczabator/utility_iot_data
dataset of utility / IOT data. approx 125MM time series, 5-minute AMI reads.