orbital
OpenRefine
Our great sponsors
| orbital | OpenRefine | |
|---|---|---|
| 13 | 45 | |
| 93 | 10,465 | |
| - | 1.5% | |
| 3.4 | 9.7 | |
| 10 months ago | about 12 hours ago | |
| TypeScript | Java | |
| MIT License | BSD 3-clause "New" or "Revised" License |
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.
orbital
- orbital - Open-source, local-first video file browser like YouTube
-
Ask HN: Anyone making a living building desktop applications?
I tried to make 2 different desktop apps in 2021 and failed at both.
Atomic Edits[0] is a desktop app that helps YouTubers (like me) automatically remove silence in videos. It went viral on Reddit[1] but I realized later that building a video editing app with Electron (and not C++) was a bad choice. Library support video/audio editing was lacking.
Recut[2] is an app that basically does what Atomic Edits aimed to do, but actually succeeded. I think it's because it was a native Mac app which meant it had access to better libraries for editing videos. (That or I gave up too early on Atomic Edits.)
Orbital[3] is desktop app that allows you to search, filter, preview video files on your computer like YouTube. I posted on some subreddits and it had potential but I realized it wouldn't be enough to sustain me. It could've worked as a side-project but being as my main source of income was from YouTube ad-revenue, it wasn't worth it.
VideoHubApp[4] is a desktop app that does what Orbital aimed to do and actually earned a couple thousand dollars. It was started a few years earlier and was built with a similar tech stack.
All that is to say, I made desktop apps that had potential, but I did not have the time to spend making them feature complete.
[0] https://github.com/SuboptimalEng/atomic-edits
[1] https://www.reddit.com/r/webdev/comments/ohbl6i/i_made_a_des...
[2] https://getrecut.com/
[3] https://github.com/SuboptimalEng/orbital
[4] https://videohubapp.com/en/
- Ask HN: Those who quit their jobs without anything planned. How did it go?
- Show HN: Open-source, local-first video file browser like YouTube
-
After quitting my job and going full-time on YouTube, I started accumulating a ton of media files. So I made an app to search, filter, and preview them.
As for the project, it’s open source - meaning the code is available for all to see, update, and report issues on GitHub (https://github.com/SuboptimalEng/Orbital).
- An open-source, local-first desktop app that helps search, filter, and preview video files (like YouTube).
OpenRefine
-
Ask HN: What Underrated Open Source Project Deserves More Recognition?
"OpenRefine is a powerful free, open source tool for working with messy data: cleaning it; transforming it from one format into another; and extending it with web services and external data." https://openrefine.org/
-
What you need to know about the future of Mozilla Hubs
Yes, let's hope! The strategy has worked out sometimes - Google shut down 'Google Refine' 10 years ago, it got turned into 'Open Refine', last update 2 months ago. https://github.com/OpenRefine/OpenRefine
It's a hugely useful tool if you're working with messy Excel-scale data, i.e., most biologists or social scientists.
-
OpenRefine
It seems to be pure JS with jQuery: https://github.com/OpenRefine/OpenRefine/blob/master/main/we...
-
java string equals returns false, even for identical strings
EDIT: trim() does not remove unicode 0x200b (unicode character for zero width space). https://github.com/OpenRefine/OpenRefine/issues/5105 is worth a read.
-
UIUC MCS - CS 513 Review - Theory and Practice of Data Cleaning
There were six homework assignments. In order they were Regular Expressions, OpenRefine, Datalog, SQL, Provenance, and Python. None of these assignments took more than two to three hours to complete. They all were basic implementation and programming assignments with autograders.
-
"We have great datasets"
Open Refine will get you about 70% there. It's FOSS
-
Is there any tools to streamline data cleaning process?
I’ve heard good things about https://openrefine.org/
-
What is the best approach to removing duplicate person records if the only identifier is person firstname middle name and last name? These names are entered in varying ways to the DB, thus they are free-fromatted.
It's not suited to SQL, use Open Refine or python fuzzywuzzy.
What are some alternatives?
GameDev - 👾 The code for my game dev + computer graphics experiments on YouTube. [Moved to: https://github.com/SuboptimalEng/Gamedex]
CQEngine - Ultra-fast SQL-like queries on Java collections
atomic-edits - 🎬 A desktop app that automatically removes silence from videos.
visidata - A terminal spreadsheet multitool for discovering and arranging data
tailwind-clones - 🍃 Cloning the UIs' of popular websites with Tailwind CSS.
LightAdmin - [PoC] Pluggable CRUD UI library for Java web applications
NewPipe - A fork of NewPipe with SponsorBlock functionality.
Smooks - Extensible data integration Java framework for building XML and non-XML fragment-based applications
pareto-mac - Automatically audit your Mac for basic security hygiene.
Jimfs - An in-memory file system for Java 7+
video-cutter - Cut any video online using FFMPEG... no server needed ! (Thanks WebAssembly)
JBake - Java based open source static site/blog generator for developers & designers.