Show HN: Spice.ai – materialize, accelerate, and query SQL data from any source https://ift.tt/5BbzfeW

Show HN: Spice.ai – materialize, accelerate, and query SQL data from any source Hi HN, We're Luke and Phillip, and we're building Spice.ai OSS - a lightweight, portable runtime, built in Rust and powered by Apache DataFusion to locally materialize, accelerate, and query data tables sourced from any database, data warehouse or data lake. Phillip and I first introduced Spice on Show HN in September 2021. Since then, we’ve been schooled and humbled in every way building 100TB+ data and ML systems for the https://spice.ai cloud platform. Along with our customers, we struggled with getting fast, low-latency, high-concurrency SQL query within a budget, accessing and combining data from many sources, trade-offs between OLTP/OLAP compute engines, and managing datasets as code. Today, we’re re-launching Spice, completely rebuilt from the ground up, to directly solve several of the problems we had in accessing data quickly and cost-effectively providing it to applications, dashboards, and machine learning. Spice provides federated SQL query across databases (MySQL, PostgreSQL, etc.), data warehouses (Snowflake, BigQuery, etc.) and data lakes (S3, MinIO, Databricks, etc.) with the ability to materialize remote datasets locally using in-memory Arrow, DuckDB, SQLite, or PostgreSQL. Accelerated engines run in your infrastructure giving you flexibility and control over price and performance. You can read the full announcement blog post at https://ift.tt/3Zbdk67... . We’d appreciate it if you check Spice out, give us feedback, and if you'd like to contribute, we'd love to build with you. Thanks! GitHub: https://ift.tt/UC6GfiT https://ift.tt/UC6GfiT March 28, 2024 at 10:46PM

Show HN: I built an interactive plotter art exhibit for SIGGRAPH https://ift.tt/AIqphNX

Show HN: I built an interactive plotter art exhibit for SIGGRAPH I'm enthralled with using pen plotters to make generative art. Last August at SIGGRAPH, I built an interactive experience for others to see how code can be used to make visual art. The linked blog post is my trials and tribulations of linking a MIDI controller to one of these algorithms and sending its output to a plotter, so that people may witness the end-to-end experience. https://ift.tt/kxhRUeX March 27, 2024 at 10:10PM

Show HN: Dora AI Beta – the first end-to-end AI website tool https://ift.tt/ghFHwQC

Show HN: Dora AI Beta – the first end-to-end AI website tool Unlike existing design tools which mainly swap AI assets into templates or pre-defined layouts, Dora AI sites are realized from beginning to end with AI — from composition to visual identity to content. That means one prompt can yield infinite unique results. We just launched our first open beta for our AI feature. As we're still in beta, any feedback on our tool would be greatly appreciated! https://ift.tt/2UX580P March 26, 2024 at 09:54AM

Show HN: Open-source AI copilot with RSCs and in-built analytics https://ift.tt/TAoqlNs

Show HN: Open-source AI copilot with RSCs and in-built analytics https://ift.tt/UL8wvcD March 27, 2024 at 01:10AM

Show HN: Dynamic Multi-LLM AI Chat https://ift.tt/pJcYdXs

Show HN: Dynamic Multi-LLM AI Chat https://faune.ai March 26, 2024 at 09:34PM

Show HN: Vocab Scrabble – A fun way to increase your vocabulary https://ift.tt/n8zMDlg

Show HN: Vocab Scrabble – A fun way to increase your vocabulary Play Scrabble with AI generated letters and validation, improve your vocabulary and impress your friends. https://ift.tt/A5KD7uH March 26, 2024 at 04:15AM

Show HN: Invertornot.com – API to enhance your images in dark-mode https://ift.tt/C3Mbcla

Show HN: Invertornot.com – API to enhance your images in dark-mode Hi HN, I built ( https://invertornot.com ) it's an API that can predict whether an image will look good/bad while inverted. This is particularly useful for images in dark-mode as you can now safely invert them. The conservative solution to adapt images for dark-mode consist in dimming the image, however there is a lot of images that can be inverted (graph for example). Using deep learning we can avoid heuristics and obtain a much more reliable solution. The API uses an EfficientNet pre-trained model fine-tuned on a custom dataset (1.1k samples). EfficientNet was chosen as it was pre-trained and offered the best performance for its size. The trained model is very small (16MB) which means you can easily run your own instance. This problem is very simple for deep learning as it's a simple binary classification. For this project training the model wasn't the challenge as most of the time was spent on the construction of the dataset. For the API I'm using FastAPI, Redis and ONNX Runtime to run the model. The API can be used by posting the images to the API, using URL and using SHA-1 for already processed images. The API is free and open-sourced ( https://ift.tt/vWwzBuT ). https://invertornot.com March 26, 2024 at 03:19AM