pngquant
datasette
pngquant | datasette | |
---|---|---|
5 | 187 | |
5,028 | 8,963 | |
- | - | |
5.1 | 9.3 | |
17 days ago | 7 days ago | |
C | Python | |
GNU General Public License v3.0 or later | 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.
pngquant
-
Random Code Inspiration Volume 2
image-shrinker is a simple, easy to use open source tool for shrinking images. Under the hood it uses pngquant, mozjpg, SVGO, and gifsicle. You can also install these tools individually if you need to compress some images. I often use pngquantafter exporting PNGs for web projects from Figma or similar tools. I literally run it like this:
-
keeping collection size down (for ankiweb) when needing lots of image cards/notes
Searching more I found https://pngquant.org/ which I could add to my bulk workflow to make most png's approach the jpeg size.
-
screen capture/snapshot utility with image optimization support/configurability
But this did prompt me to do some searching, and I see https://pngquant.org/ which seems to achieve jpeg like size reduction while maintaining the file as a png. One difference they note is that this method will typically preserve sharp edges better than jpeg (which is probably a strong plus for my type of use case)
- Ask HN: Small scripts, hacks and automations you're proud of?
-
Optimising hundreds of gifs, offline
If use PNG you can use pngquant 2 for instance. More modern image formats may also compress your images further.
datasette
-
Ask HN: High quality Python scripts or small libraries to learn from
Simon Willison's github would be a great place to get started imo -
https://github.com/simonw/datasette
- Show HN: TextQuery – Query and Visualize Your CSV Data in Minutes
-
Little Data: How do we query personal data? (2013)
I'm a fan on simonw's datasette/dogsheep ecosystem https://datasette.io/
-
LaTeX and Neovim for technical note-taking
I use Anki the exact same way. After a lifetime of learning I have accepted that I will never read over anything I write for myself voluntarily - so my two options are:
1. Write an article so good I can publish it and look it over myself later on. I did this last year with https://andrew-quinn.me/fzf/, for example.
2. Create Anki cards out of the material. Use the builtin Card Browser or even https://datasette.io/ on the underlying SQLite database in a pinch to search for my notes any time I have to.
-
Daily Price Tracking for Trader Joes
Were you aware of, or tempted by https://datasette.io/ for creating your solution?
- SQLite-Web: Web-based SQLite database browser written in Python
-
Ask HN: What two software products should have a kid?
Browsing HN, GitHub and the like we get to see a huge variety of software products and code bases.
I often see products and think - if this product X, got together with Y, it would be pretty cool - kind of like if they had a kid together.
Not too literally, but more on the conceptual level - my level of programming is low.
E.g. Just some....
- pocketable.io & datasette (+with some more charting) [https://pocketbase.io, https://datasette.io]
-
Ask HN: Looking for a project to volunteer on? (February 2024)
You might like the Datasette project: https://datasette.io/
I don't think they are desperate for contributions but it's a welcoming environment and a fun project to hack on. You'll learn a lot just from reading the source and the incredibly informative PRs. The creator is a really talented developer with a great blog which shows up on the HN front page often.
-
Stuff I Learned during Hanukkah of Data 2023
Last year I worked through the challenges using VisiData, Datasette, and Pandas. I walked through my thought process and solutions in a series of posts.
-
What We Watched: A Netflix Engagement Report – About Netflix
> uploads of boring raw excel data and receive a nice UI
https://datasette.io/
What are some alternatives?
oxipng - Multithreaded PNG optimizer written in Rust
nocodb - 🔥 🔥 🔥 Open Source Airtable Alternative
3d-game-shaders-for-beginners - 🎮 A step-by-step guide to implementing SSAO, depth of field, lighting, normal mapping, and more for your 3D game.
duckdb - DuckDB is an in-process SQL OLAP Database Management System
flameshot - Powerful yet simple to use screenshot software :desktop_computer: :camera_flash:
sql.js-httpvfs - Hosting read-only SQLite databases on static file hosters like Github Pages
mozjpeg - Improved JPEG encoder.
litestream - Streaming replication for SQLite.
zettelkasten - Creating notes with the zettelkasten note taking method and storing all notes on github
Sequel-Ace - MySQL/MariaDB database management for macOS
dotfiles - ben's dotfiles
beekeeper-studio - Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.