dstack
prql
dstack | prql | |
---|---|---|
17 | 106 | |
1,131 | 9,489 | |
6.9% | 1.3% | |
9.8 | 9.9 | |
2 days ago | 3 days ago | |
Python | Rust | |
Mozilla Public License 2.0 | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
dstack
-
Pyinfra: Automate Infrastructure Using Python
We build a similar tool except we focus on AI workloads. Also support on-prem clusters now in addition to GPU clouds. https://github.com/dstackai/dstack
-
Show HN: Open-source alternative to HashiCorp/IBM Vault
Not exactly this, but something related. At https://github.com/dstackai/dstack, we build an alternative to K8S for AI infra.
-
Ask HN: How does deploying a fine-tuned model work
You can use https://github.com/dstackai/dstack to deploy your model to the most affordable GPU clouds. It supports auto-scaling and other features.
Disclaimer: I’m the creator of dstack.
- FLaNK Stack Weekly 19 Feb 2024
-
Show HN: I Built an Open Source API with Insanely Fast Whisper and Fly GPUs
Great job on the project! It looks fantastic. Thanks to your post, I discovered Fly's GPUs. We are currently developing a platform called https://github.com/dstackai/dstack that enables users to run any model on any cloud. I am curious if it would be possible to add support for Fly.io as well. If you are interested in collaborating on this, please let me know!
- Show HN: Dstack – an open-source engine for running GPU workloads
-
[P] I built a tool to compare cloud GPUs. How should I improve it?
I also noticed that the creator of this app, dstack, is affiliated with Tensordock, the top results for most if not all queries. If that's the case, perhaps a direct link to the cheapest machine could be provided? I haven't used Tensordock, so I don't know if this is mechanically possible.
-
Running dev environments and ML tasks cost-effectively in any cloud
Here's the repository with all the important links, including documentation, examples, and more: https://github.com/dstackai/dstack
-
Dstack Hub
Hey everyone, I'm happy to release dstack Hub, an open-source tool that helps teams manage their ML workflows more effectively without vendor lock-in.
dstack Hub extend dstack [1] with workflow scheduling capabilities and user management. Here's how it works: run dstack Hub via Docker, use its UI to configure projects and cloud credentials, then pass the URL and personal token to the dstack CLI. Now, you can run workflows through the CLI and Hub will orchestrate them in the cloud on your behalf.
This is a beta release and we plan to continuously improve it. We'd love to hear your feedback and answer any questions!
[1] https://github.com/dstackai/dstack
-
Running Stable Diffusion Locally & in Cloud with Diffusers & dstack
To help you overcome this challenge, we have written an article to guide you through the simple steps of using both diffusers and dstack to generate images from prompts, both locally and in the cloud, using a simple example.
prql
- Prolog language for PostgreSQL proof of concept
-
SQL is syntactic sugar for relational algebra
> I completely attribute this to SQL being difficult or "backwards" to parse. I mean backwards in the way that in SQL you start with what you want first (the SELECT) rather than what you have and widdling it down.
> The turning point for me was to just accept SQL for what it is.
Or just write PRQL and compile it to SQL
https://github.com/PRQL/prql
- Transpile Any SQL to PostgreSQL Dialect
-
Show HN: Open-source, browser-local data exploration using DuckDB-WASM and PRQL
Hey HN! We’ve built Pretzel, an open-source data exploration and visualization tool that runs fully in the browser and can handle large files (200 MB CSV on my 8gb MacBook air is snappy). It’s also reactive - so if, for example, you change a filter, all the data transform blocks after it re-evaluate automatically. You can try it here: https://pretzelai.github.io/ (static hosted webpage) or see a demo video here: https://www.youtube.com/watch?v=73wNEun_L7w
You can play with the demo CSV that’s pre-loaded (GitHub data of text-editor adjacent projects) or upload your own CSV/XLSX file. The tool runs fully in-browser—you can disconnect from the internet once the website loads—so feel free to use sensitive data if you like.
Here’s how it works: You upload a CSV file and then, explore your data as a series of successive data transforms and plots. For example, you might: (1) Remove some columns; (2) Apply some filters (remove nulls, remove outliers, restrict time range etc); (3) Do a pivot (i.e, a group-by but fancier); (4) Plot a chart; (5) Download the chart and the the transformed data. See screenshot: https://imgur.com/a/qO4yURI
In the UI, each transform step appears as a “Block”. You can always see the result of the full transform in a table on the right. The transform blocks are editable - for instance in the example above, you can go to step 2, change some filters and the reactivity will take care of re-computing all the cells that follow, including the charts.
We wanted Pretzel to run locally in the browser and be extremely performant on large files. So, we parse CSVs with the fastest CSV parser (uDSV: https://github.com/leeoniya/uDSV) and use DuckDB-Wasm (https://github.com/duckdb/duckdb-wasm) to do all the heavy lifting of processing the data. We also wanted to allow for chained data transformations where each new block operates on the result of the previous block. For this, we’re using PRQL (https://prql-lang.org/) since it maps 1-1 with chained data transform blocks - each block maps to a chunk of PRQL which when combined, describes the full data transform chain. (PRQL doesn’t support DuckDB’s Pivot statement though so we had to make some CTE based hacks).
There’s also an AI block: This is the only (optional) feature that requires an internet connection but we’re working on adding local model support via Ollama. For now, you can use your own OpenAI API key or use an AI server we provide (GPT4 proxy; it’s loaded with a few credits), specify a transform in plain english and get back the SQL for the transform which you can edit.
Our roadmap includes allowing API calls to create new columns; support for an SQL block with nice autocomplete features, and a Python block (using Pyodide to run Python in the browser) on the results of the data transforms, much like a jupyter notebook.
There’s two of us and we’ve only spent about a week coding this and fixing major bugs so there are still some bugs to iron out. We’d love for you to try this and to get your feedback!
-
Pql, a pipelined query language that compiles to SQL (written in Go)
> Looks like PRQL doesn't have a Go library so I guess they just really wanted something in Go?
There's some C bindings and the example in the README shows integration with Go:
https://github.com/PRQL/prql/tree/main/prqlc/bindings/prqlc-...
- FLaNK Stack 26 February 2024
- FLaNK Stack Weekly 19 Feb 2024
-
PRQL as a DuckDB Extension
Can someone tell me why PRQL is better? I went here: https://github.com/PRQL/prql
It looks nice, but what's the strengths compared to SQL?
-
Shouldn't FROM come before SELECT in SQL?
PRQL [1] is a compile-to-SQL relational querying language that puts FROM first.
[1] https://prql-lang.org
-
Vanna.ai: Chat with your SQL database
https://prql-lang.org/ might be an answer for this. As a cross-database pipelined language, it would allow RAG to be intermixed with the query, and the syntax may(?) be more reliable to generate
What are some alternatives?
msdocs-python-django-azure-container-apps - Python web app using Django that can be deployed to Azure Container Apps.
malloy - Malloy is an experimental language for describing data relationships and transformations.
dstack-examples - A collection of examples demonstrating how to use dstack
Preql - An interpreted relational query language that compiles to SQL.
zenml - ZenML 🙏: Build portable, production-ready MLOps pipelines. https://zenml.io.
bustub - The BusTub Relational Database Management System (Educational)
flyte - Scalable and flexible workflow orchestration platform that seamlessly unifies data, ML and analytics stacks.
tresql - Shorthand SQL/JDBC wrapper language, providing nested results as JSON and more
lambdapi - Serverless runtime environment tailored for code produced by LLMs. Automatic API generation from your code, support for multiple programming languages, and integrated file and database storage solutions.
spyql - Query data on the command line with SQL-like SELECTs powered by Python expressions
metaflow - :rocket: Build and manage real-life ML, AI, and data science projects with ease!
toydb - Distributed SQL database in Rust, written as a learning project