Posts

Showing posts with the label SQL

Visual Query Builder

Visual Query Builder    I built a visual query builder in Delphi with a coworker for the Mississippi Supreme Court system in the past.  The application worked on Microsoft Windows OS and used Microsoft SQL Server (I think).  I was thinking about rebuilding it using Claude Code and making it open source.  Starts with a known database.  Dynamically pick data (tables and rows using the system view information schema).  Have interface that filters, allows summarization (sum or count) by a secondary data (table and specific row), and allows sorting (and pick ascending or descending). When picking it shows a grid that is the Preview of the data. https://www.metabase.com/docs/latest/questions/query-builder/editor

"Big Data" technologies

 Big Data programming model and technologies Tools: Anaconda -   open source (free).   Most popular at 33.4% in 2018.   Has R and Python versions.   IDEs: Jupyter, RStudio, Spyder, and JupyterLab     Editors: Jupyter, RStudio, Spyder, and Visual Studio Code   Platforms: Linux, macOS, Windows   Visualize your data: Matplotlib, Bokeh, Datashader, and Holoviews   Machine learning & deep learning models: Scikit-learn, Tensorflow, h20, and Theano   Analyze: Dask, numpy, pandas, and Numba Keras wrapper on top of Tensorflow. ================================================================ R 48.5% in 2018. R is "a language for statisticians built by statisticians." open source (free). ggplot2 SparkR bindings to run Spark on R. Disad -   1) hard to be productive in R (if no prior Matlab, SAS, or OCTAVE).   2) Limited at more general purposes. ================================================================ Python open source (f...