Just got this from Javier

is there an ARM quest db

Hi @Alan Kwan yes, we have support for ARM64

cool. checking it out on brew now.

Hello, does anyone know questDB can store JSON type in a column? Thank you :)

ERROR: CLI execute error: ERROR: table does not exist [name=SAVEPOINT]; Error while executing the query this error appears when I execute truncate table command from a third part software proc sql noerrorstop; connect to odbc as x1 (required = "dsn=geekdao;uid=admin;password=quest"); execute( truncate table last_r )by x1; disconnect from x1; quit;

hot or not? https://twitter.com/TarasNovak/status/1553382975185854467

so, I have not tried using QuestDB with Jupyter notebooks yet, but I did publish data table renderers in vscode marketplace again for others to try and use. Give them a whirl! https://twitter.com/TarasNovak/status/1560402316527894531

how neat is this? https://www.linkedin.com/posts/tarasnovak_graphviz-vscode-ojsnotebooks-activity-6972132779568373760-4T1Y?utm_source=share&utm_medium=member_desktop

questdb intro in vscode notebook view with new OJS notebook kernel 🙂

since a lot of your users work with large csv data files, I thought I'd share this alpha v. tool here too: https://www.linkedin.com/posts/tarasnovak_dataanalytics-vscode-tabulardataviewer-acti[…]915352272896-uo8Q?utm_source=share&utm_medium=member_desktop

fyi: https://www.linkedin.com/feed/update/urn:li:activity:6985667609983676416/

If I say it, it must be true 🙂 https://twitter.com/TarasNovak/status/1581044417556713472

does questdb work with sqlmagic? I'd like to try it with Juputer notebooks in vscode similar to this example ... https://twitter.com/TarasNovak/status/1583057340496236544

Any interesting project ideas to build with QuestDB ?

It all depends on which datasets you have available, Soham. For example, Black Friday just happened and I saw a lot of articles about how some shops were gaming the system raising prices in the weeks before Black Friday so they could advertise a discounted price afterwards. I saw some sites keeping track of price changes for some merchants. You could potentially crawl daily data of products you want to track, and store in QuestDB. You could add columns for brand, vendor, category, and even local website (for large websites with presence in multiple countries with different prices on each). Then you could use QuestDB to show trends and historical data

The same idea can be applied to Energy consumption, energy prices, air quality metrics…

Or even to track contributions and issues on Github or gitlab

It all depends on what you want to achieve, which data you already have, and how hard it would be to capture the data you don’t have

Hi! I need to go through all the rows and index them with Lucene. Can I do it in batches? I have not found anything in the docs? Thank you!

Does anyone know of a way to initialize tables in a QuestDB docker image on startup? Is there a spot where you can put an SQL script? For example, postgres initialization scripts does this, but I haven't seen anything for quest