Spark vs Redshift
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement! Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
https://www.quora.com/Spark-vs-Redshift-Should-I-be-using-both-for-big-data-Which-is-better
Performance
https://dbseer.com/benchmark-comparison-spark-sql-redshift-cluster/
Hands on Full-text Search in SQLite3
FTS5 (Full-text Search) in SQLite3¶
- If tokens in the search phrase are separated by either spaces or plus signs,
then they are matched in order by tokens in the text.
To match tokens orderless,
you can separate tokens in the search phrase with the keyword
AND.
Group by vs Over Partition in SQL
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
SQL Server: Difference between PARTITION BY and GROUP BY
group byalwasy aggreates values. That isgroup byalwasy reduces a group of values to 1 value. Hoever,analytics_function() over(partition …
SQL Logic Visualization
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
-
rm-hull/sql_graphviz is a small Pyton script that generates a Graphviz visualization of a SQL schema dump.
-
sqldep - queryScope is a great online tool for visualizing logic of SQL code. You …
Parameterized SQL
Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!
- Parameters are not supported in a DDL statement.