archiewood

7 ms·

31.
by archiewood 3y ago
Aha I did not notice that prompt. By default my brain is trained to ignore things that are commented out in code I think I would execute the SQL query that the cursor was within. Ie anything until the next ;
32.
by archiewood 3y ago
We're really excited to see all the stuff built on DuckDB-WASM too! I love how fast your workbench runs, and how effortlessly it renders 60k rows in the browser Some UX feedback, if you're open to it: - It was initially unintiutiv
33.
by archiewood 3y ago
This is a relatively similar architecture to that we are building at Evidence.dev (open-source data viz framework) Architecture: https://evidence.dev/blog/why-we-built-usql/ 1. Query SQL databases, APIs, or local
34.
by archiewood 3y ago
Was very bummed out when Heroku started charging for Hobby Tier as I had to sunset a few of my hobby apps - Heroku was my first experience deploying a website: `git push heroku master` - Dataclips was my first experience writing SQL Writing
35.
by archiewood 3y ago
I love Obsidian. The Markdown <-> Markup typing experience is just so good compared to e.g. Slack, Reddit and other markdown-esque tools
36.
by archiewood 3y ago
Traceback (most recent call last): File "/home/runner/2320236597/main.py", line 3, in <module> from email_sender import SendEmail File "/home/runner/2320236597/email_
37.
by archiewood 3y ago
This is my current workflow, though with ChatGPT. I was just trying to save a few clicks
38.
by archiewood 3y ago
My most common use case here is to then want to hit the API from python, and adjust the params / url etc. Would love a "copy to python requests" button that grabs the headers generates a boilerplate python snippet including t
39.
by archiewood 3y ago
Looks cool, will check it out next time.
40.
by archiewood 3y ago
I do quite a lot of this kind of stuff for my job. Some thoughts that may be useful. Often the full IDE is needed. I record a lot of gifs of VSCode, where part of the gif is typing code, part is interacting with the rest of the IDE / t
41.
by archiewood 3y ago
The linked source data from the RIAA is presented much better: https://www.riaa.com/u-s-sales-database/ Positive money is up on the y axis
42.
by archiewood 3y ago
They have a table comparing what they are doing vs materialize in the FAQs in the docs (not super easy to find) - https://docs.epsio.io/faq/ On a quick read, seems like the core difference is around whether you query t
43.
by archiewood 3y ago
> Not sure the language you choose matters as much as making the API usable by a wide audience. Fully agree with this, and having typeset my masters thesis and later my resume using LaTeX, I think that the “authoring experience” is defin
44.
by archiewood 3y ago
Really interesting read. Have you thought about how you might identify usability ‘gotchas’ in notation. For example two similar visualization components where the property names for a similar concept differ. Eg `title` vs `name`
45.
by archiewood 3y ago
Oh yeah. Any manual data update has potential to go wrong. Especially since in my exp the most common way to do this is to paste the new data over previous sheet in an excel, and hope all the formulas still work. Kind of fine, but let’s hop
46.
by archiewood 3y ago
> Looker (which is hot garbage for other reasons as well) From what I remember, Looker does allow you to create pivot tables from the Explore interface? You can then also download to csv / excel from a Looker explore. Something miss
47.
by archiewood 3y ago
> This is because Power BI tracks usage metrics and almost all dashboards are completely unused. This is what I term the “dirty secret of BI” - for most organisations, most dashboards are unused, except by the teams creating them. This i
48.
by archiewood 3y ago
Step 1: Be a front end engineer Step 2: Wait three months
49.
by archiewood 3y ago
I assume this is the problem that https://what3words.com/ is trying to solve. but I guess it being in English makes it a less good solution Edit: they support hindi (and many other languages)
50.
by archiewood 3y ago
i will opt for `fix: make! code! great! again!`
51.
by archiewood 3y ago
If you are interested in this, you might be interested in the code-based BI tool I'm working on, Evidence ( https://github.com/evidence-dev/evidence ) The experience is a bit more: Start writing code -> GitHub co
52.
by archiewood 3y ago
it's wild to me that they don't offer colour options
53.
Ten Million Passwords(raw.githubusercontent.com)
2 points by archiewood 3y ago|1 comments
54.
by archiewood 3y ago
This is interesting. I've built reports in Dash before. As I remember it was kind of tricky to hook up the filters etc, and "callbacks" confused me for a while. Is that the kind of thing Vizro addresses? Do you have a "w
55.
by archiewood 3y ago
I also do this. Had two bikes stolen in quick succession a while back. Now: Duct tape all over the frame. Different handle tape on each side. No theft since
56.
by archiewood 3y ago
I built a VSCode extension so you can explore and query a DuckDb. It’s built on top of the very excellent SQLTools ecosystem. Find it’s much easier than the CLI to work out what your columns and tables are called. It also has autocomplete f
57.
VSCode for DuckDB(marketplace.visualstudio.com)
2 points by archiewood 3y ago|1 comments
58.
by archiewood 3y ago
Im in Firefox and it tells me 43% of the fingerprints are Firefox. So seems very skewed!
59.
BigQuery VSCode SQLtools: Explore your database and run queries(github.com)
1 points by archiewood 3y ago|0 comments
60.
Running Outstanding Business Reviews, with SQL(evidence.dev)
4 points by archiewood 3y ago|0 comments

More ›