Readit News logoReadit News
texodus commented on Show HN: Duck-UI – Browser-Based SQL IDE for DuckDB   demo.duckui.com... · Posted by u/caioricciuti
alex_hirner · 4 months ago
I'd love to make it work with flightsql or HTTP endpoints returning arrow IPC [0]! Did you consider using perspective for last-mile charting [1]? Building your own seems like a huge chunk of work. Well done!

[0] https://duckdb.org/docs/stable/clients/wasm/data_ingestion#a... [1] https://github.com/finos/perspective

texodus · 4 months ago
Perspective is also getting direct support for DuckDB soon! https://github.com/finos/perspective/pull/3062
texodus commented on You Wouldn't Download a Hacker News   jasonthorsness.com/25... · Posted by u/jasonthorsness
xnx · 10 months ago
Thanks! I'll check that out. Thought it was a typo of "Perspective" for a moment: https://perspective.finos.org/
texodus · 10 months ago
Yes! This is the pro version, we also develop open source https://github.com/finos/perspective (which Prospective is substantially built on, with some customizations such as a wasm64 runtime).
texodus commented on You Wouldn't Download a Hacker News   jasonthorsness.com/25... · Posted by u/jasonthorsness
xnx · 10 months ago
I have this data and a bunch of interesting analysis to share. Any suggestions on the best method to share results?

I like Tableau Public, because it allows for interactivity and exploration, but it can't handle this many rows of data.

Is there a good tool for making charts directly from Clickhouse data?

texodus · 10 months ago
No Clickhouse connector for free accounts yet, but if you can drop a Parquet file on S3 you can try https://prospective.co
texodus commented on The DuckDB Local UI   duckdb.org/2025/03/12/duc... · Posted by u/xnx
pepperonipboy · a year ago
Wow that's really cool! Part of my PhD thesis was about writing stable treemapping algorithms for temporal data. The idea being that you want your treemap cells not to fly around like what I'm seeing in your demo, but to remain more or less in the same position without sacrificing too much on the cells aspect ratios. We've come up with a pretty effective and fast method to do that, check out the paper and a demo down below. Maybe we could even do a collaboration to get this implemented in perspective.

https://github.com/EduardoVernier/eduardovernier.github.io/b...

https://youtu.be/Bf-MRxhNMdI?list=PLy5Y4CMtJ7mKaUBrSZ3YgwrFY... (see the GIT method)

texodus · a year ago
That looks much better, thanks I will read up.
texodus commented on The DuckDB Local UI   duckdb.org/2025/03/12/duc... · Posted by u/xnx
markhalonen · a year ago
I suggest https://perspective.finos.org/ for data viz to be built in. We use DuckDB paired with Perspective for client-side BI use case, and it's been great.
texodus · a year ago
Glad you dig it! Check out our pro version to - it also support DuckDB, Python/Pyodide and more! https://prospective.co
texodus commented on Ask HN: Who is hiring? (June 2024)    · Posted by u/whoishiring
texodus · 2 years ago
https://prospective.co/ | Software Engineers | Full time | Remote only, US only | NYC

Hello! We are a small team of sharp and motivated engineers working on advancing the art of data analysis and visualization for everyone from business analysts to data scientists. And we're looking for talented and interested engineers to join us.

Prospective is a professional toolchain for analyzing and visualizing data on your local machine. It's a graphical tool that runs in a web browser and is able to slice and dice gigabytes of static or realtime data. It's built on the popular OSS framework Perspective https://github.com/finos/perspective . Prospective runs as WebAssembly in modern browsers, so it's fast, portable, and memory-efficient. It has its own in-memory data store, but can also plug into any database or streaming platform with a straightforward adapter API. Prospective integrates with existing data tools like Python and Jupyter, and all the dashboards created can be shared to ease collaboration. Our goal is to expand beyond financial services and become the standard toolchain for anyone whose job is to make sense and find patterns in large datasets.

Prospective offers a great opportunity to dig into complex software. On any given day we might be optimizing how the database executes queries in C++, implementing API features in Rust, writing new language bindings for our API, speeding up our Bazel build process, or implementing new charting or query features in our graphical UI. Prospective is engineered to be fast and stable. We write good tests, and once a bug is fixed it stays fixed.

Our team has a culture of mentorship and collaboration, and we work with each other knowing that every team member is always either teaching or learning. We pair-program regularly as a way to share our thinking and get feedback on our solutions. We hold each other to a high quality bar for performance and aesthetics, a constraint that we think creates a healthy environment for creative problem-solving. Every day has a brief "stand up" in the morning and a "stand down" in the afternoon to share what we've learned and what we're stuck on. Every Friday afternoon we demo what we're building for each other, which we call "dogfooding". And we talk regularly to our users, both paid and open-source, to create product feedback loops to understand where the rough edges are and what folks find extremely valuable.

We'd love to chat with you if you have experience in WebAssembly, Python native extensions, C++, Rust or Jupyter. But regardless of your experience, we're very intentionally looking for people who are interested, motivated, and passionate about deeply learning WebAssembly and pushing the boundaries of what a browser can do. We believe smart, passionate people will channel that energy into learning how the tech stack works; and we believe that aligning people's work with their interests correlates with long term business success. We're currently looking for two additional engineers to join our five-person team. We're open to more-junior and more-senior engineers, and are committed to making a competitive offer based on experience and skill level.

Contact andrew@prospective.dev

texodus commented on Ask HN: Minimal JavaScript for simple UIs with Python back end    · Posted by u/minjsthrowaway
texodus · 2 years ago
Maintainer of Perspective here - we have an enterprise version that does exactly what you ask for! https://prospective.co/
texodus commented on Enterprise-Fu   mike.daless.io/prez/enter... · Posted by u/luu
trillic · 2 years ago
Is there a public recording of you presenting the deck? Would love the full context.
texodus · 2 years ago
Not that you asked for this, but as a @flavorjones admirer I figured I'd post anyway, my favorite actually recorded talk of theirs https://www.youtube.com/watch?v=zOutXbz_7Ns
texodus commented on Perspective Market Simulation   prospective.co/blog/marke... · Posted by u/texodus
mszcz · 2 years ago
Does anyone know what charting library they're using?

u/texodus

KarmaCake day574September 2, 2009View Original