Based on our record, TABLUM.IO should be more popular than SQL Police Department. It has been mentiond 3 times since March 2021. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.
For the data loaded from the raw and unstructured data sources (RESTful APIs, files, feeds) I'd recommend checking tablum.io. The data first gets into the staging SQL DB where you can apply transformations in SQL (ClickHouse dialect with hundreds of ready-to-use functions for aggregations, transformations, string and array processing, etc). After that, you can set up a pipeline to external DWH or DB. Or just... Source: over 2 years ago
Fairly easy to parse it with Python (or any other scripting languages that support regular expressions). Besides, there're no-code parsers that can do that. E.g. tablum.io, it has a regexp parser that turns poorly formatted text into an SQL table. All you need it is to provide the regular expression (regexp) to split the text (per-line basis or the entire text) into chunks that become SQL rows and columns, after... Source: over 2 years ago
You're right. There should be some way to safely pass the authentication token without storing it in the query. BTW, to keep all data within the company network perimeter and no share any keys with the cloud service, one can install tablum.io as a self-hosted version on a Linux server (it runs in Docker). Source: over 2 years ago
Https://sqlpd.com I found it useful when I was learning MySQL. Source: over 2 years ago
Notion SQL Learning - Are you looking for a way to save time and fast-track your SQL learning?
Learn Anything - Search Interactive Maps to Learn Anything
PCPartPicker - By offering its users with multiple buying guides, this PC building website basically assist its users in building their own PC and give them ideas for creating ideal PC.
Marple - Data analysis platform for engineering teams. Organise, find and visualise test and measurement data
SQL query for CSV - SQL query for CSV helps people analyze large sets of csv records in a short time using declarative SQL syntax.
JSONsilo.com - Convert your static JSON file to a REST API in minutes