News for hackers. Stuff that matters.
Re:SQL for data scientists in 100 queries by shubhamjain on Tuesday February 06, 2024 @05:36PM (#39281792)
Shameless Plug: If anyone here wants to practice their SQL, they are welcome to try my Mac app: TextQuery [1]. I built it because I wanted to quickly import CSV datasets and run SQL queries on them. I don't think there could be a more fun way to learn SQL than to jump in and start analyzing thousands of public datasets. Sure, you can use CLI/Code as well, but GUI is often faster and easier. Currently, the app is in the beta period and free-to-use. When launched, you'll get to keep the latest beta version.

[1]: https://textquery.app/

Re:SQL for data scientists in 100 queries by xp84 on Tuesday February 06, 2024 @06:52PM (#39282615)
Super cool! Thanks for sharing.
Re:SQL for data scientists in 100 queries by saadatq on Tuesday February 06, 2024 @06:03PM (#39282100)
This is brilliant.
Re:SQL for data scientists in 100 queries by Atotalnoob on Tuesday February 06, 2024 @09:02PM (#39283577)
Isn’t this just a ui over SQLite?
Re:SQL for data scientists in 100 queries by aeturnum on Tuesday February 06, 2024 @09:16PM (#39283660)
There's clearly some non-SQLite functionality that seems really neat!
Re:SQL for data scientists in 100 queries by Terretta on Tuesday February 06, 2024 @09:47PM (#39283857)
Why do you need to harvest email addresses?
Re:SQL for data scientists in 100 queries by friendlynokill on Tuesday February 06, 2024 @09:52PM (#39283878)
Been meaning to learn SQL, so will check this out
Re:SQL for data scientists in 100 queries by _kush on Wednesday February 07, 2024 @12:05AM (#39284719)
This is a very interesting idea! Great work
Re:SQL for data scientists in 100 queries by 7thaccount on Wednesday February 07, 2024 @07:55AM (#39287958)
Nice. I built some code that did this about a ~6 years ago, but it had no GUI and had to deal with some very irregular csv files. I always wondered why the default SQLite didn't have better support for reading CSV directly and auto ascertaining data types.