Comments (13)
@max-sixty I've been having a lot of fun with qStudio. Any reason we shouldn't list it as an integration? (It is, after all...) Thanks
Update: I raised a PR #4547
from prql.
I cannot find your commit to qStudio for PRQL syntax highlighting.
We have the prqlc
(PRQL compiler) tool that you can install using winget:
winget install prqlc
from prql.
Hi @ryanhamilton ! qStudio looks great, nice work...
That would be super from our end. We do already produce binaries, for example: https://github.com/PRQL/prql/releases/tag/0.11.4
FWIW my guess is that asking folks to add the binary to their path might be difficult for the average user. I get the reluctance to make your binary heavier, though the compressed binaries are 3-5MB at that link...
There was some work to make a Java binding — we still run tests on it, so it very likely works — though I haven't heard of that many folks using it...
from prql.
@ryanhamilton This is SO COOL! I downloaded a copy and I like it a lot. (This seems pretty mature - you even support different themes, which makes me happy. (I'm a Solarized Light kind of guy :-)) Adding direct support for PRQL would make my day.
I found a few rough edges while I was downloading/installing. What's the best place for me to offer comments/suggestions? Thanks!
from prql.
Thanks @max-sixty @vanillajonathan - That worked!
This is now done and well I think it's pretty cool :)
I tried querying sqlite, duckdb and H2, all of them just worked. If you download the latest 3.02+ it's in there:
https://www.timestored.com/qstudio/prql-ide
What's the best place for me to offer comments/suggestions?
@richb-hanover The best place is on github: https://github.com/timeseries/qstudio/issues
If possible please star the project as after 13 years I'm trying to fully open source the project: timeseries/qstudio#43
The one thing I wasn't sure of is what separator PRQL uses between separate statements. I assumed ;.
If it gets enough users I can see about adding automatic download of prqlc. 🚀 👍
from prql.
Oh wow! I so want to look at this (but it'll probably have to wait 'til this weekend...)
PS PRQL is line-based - there are no "end of line" separators. Thanks!
from prql.
Thanks for your help @richb-hanover , between us we got it working. 👍
I hope you find it useful and this proves an easy way to get PRQL to more users. Now any database should be usable with PRQL.
I have added a custom demo page:
https://www.timestored.com/qstudio/prql-ide
and I will shortly email our existing userbase to announce the support.
from prql.
@ryanhamilton I would hold off on a big announcement. I tried it with a big query that works fine when I paste the SQL into SQLiteBrowser, but throws an error in qStudio. (That's what I had in mind in my note at timeseries/qstudio#44.) I'll aim to get a complete report to you by this weekend. Thanks again.
from prql.
It would be good to get some more PRQL users really using qStudio to iron out any bugs or to raise feature suggestions.
Could qStudio be added to the list of integrations?
I'm happy to raise the PR but wasn't sure if you would welcome it or not.
Let me know.
from prql.
FYI The new qStudio with PRQL reached the top of HN
https://news.ycombinator.com/item?id=40562210
https://www.timestored.com/qstudio/release-version-3
So there's at least 1000+ people with a version that has the integration already :)
from prql.
Congratulations on HN coverage! I especially like this:
Year 1 - Getting the first version out that worked for me and my colleagues. Year 2 - Cleaning it up enough to promote wider use. Documentation. Years 3-5 - Minor bug fixes only as I thought qStudio solved the problem. Years 6 - I realised restricting qStudio to only 1-2 database technologies was foolish. Major change to support many more databases. Improved generic SQL highlighting. Added a partial dark mode. Years 7-8 - Minor bug fixes. Year 9 - Added a proper Dark Mode and support for many themes by using FlatLaf. Now looking properly modern. Year 10 - Realise that I'm not fully solving the problem. That actually for most data analysts I should support creating the analysis (pivot table) and improve exporting (real excel export, not just nicely escaped CSV).
That comports with my mentor's adage:
- To make software for yourself, it takes X units of work
- To make software for your colleagues, it takes 3X
- To make generally useful software, it takes 9X
It sounds reasonable to have qStudio listed as an integration. I'll talk it up. Thanks again
from prql.
@ryanhamilton I cannot find your commit to qStudio for PRQL syntax highlighting.
from prql.
Congrats on the HN exposure @ryanhamilton !
from prql.
Related Issues (20)
- Queries that return nested tuples HOT 1
- Reformatting an alias omits quoting HOT 2
- DevContainer: Need to run `git config ... --add safe.directory` one time HOT 5
- After adding 1500k line of db schema type definition to default_db module, `prqlc compile` takes more than 1G ram & 2 min even for simplest query. HOT 1
- Nightly tests failed HOT 1
- How to abstract table filtering using function? HOT 2
- Nightly tests failed HOT 1
- Nightly tests failed
- Select columns collection is inaccurate HOT 1
- Odd version number in Windows Dev Container HOT 4
- Reformatting a string containing both single and double quotes breaks down HOT 1
- Nightly tests failed HOT 1
- Nightly tests failed HOT 1
- Nightly tests failed HOT 1
- Nightly tests failed
- Converting quotes properly to double quotes in Postgres in custom field name scenario HOT 5
- Nightly tests failed
- RUSTSEC-2024-0370: proc-macro-error is unmaintained HOT 1
- Nightly tests failed HOT 1
- Nightly tests failed HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from prql.