OpenRefine
Adminer
OpenRefine | Adminer | |
---|---|---|
45 | 53 | |
10,498 | 6,032 | |
0.5% | - | |
9.7 | 0.0 | |
1 day ago | about 2 months ago | |
Java | PHP | |
BSD 3-clause "New" or "Revised" License | 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.
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.
Adminer
-
Shopware dev productivity and plugin validation
Use adminer (or the SQL CLI) to verify tables and database entries. In a dockware default development setup: http://localhost//adminer.php (Server: 127.0.0.1, not localhost; database: shopware; initial login: root:root).
- Adminer: Database management in a single PHP file
- DBeaver – open-source Database client
-
Ask HN: What Underrated Open Source Project Deserves More Recognition?
Heh, what a name for a DB explorer ("Adminer - Database management in a single PHP file"; Apache 2 or GPLv2 https://github.com/vrana/adminer/blob/v4.8.1/readme.txt#L7 )
- SQLite-Web: Web-based SQLite database browser written in Python
-
Microsoft sqlsrv.so Extension for MS SQL - need ODBC ?
Web Station test using PHP and Adminer via the 'ancient' unsupported pdo_dblib confirmed SQL Server is working, however I need to write code using the sqlsrv extension.
-
mySQL Backup Script without mysqldump
Or, more PHP now, do you have phpmyadmin or can run adminer - single file?
-
Adminer VS laravel-adminer - a user suggested alternative
2 projects | 15 Jul 2023
-
Notes app that is a simple PHP
Nothing stops you from compiling everything into one file. Adminer does it.
-
Looking for Remote Database manager
Another solution I use often is Adminer, it is a single PHP file, working over web server and accessible from anywhere
What are some alternatives?
CQEngine - Ultra-fast SQL-like queries on Java collections
phpMyAdmin - A web interface for MySQL and MariaDB
visidata - A terminal spreadsheet multitool for discovering and arranging data
cloudbeaver - Cloud Database Manager
LightAdmin - [PoC] Pluggable CRUD UI library for Java web applications
phpRedisAdmin - Simple web interface to manage Redis databases.
Smooks - Extensible data integration Java framework for building XML and non-XML fragment-based applications
phpPgAdmin - the premier web-based administration tool for postgresql
Jimfs - An in-memory file system for Java 7+
ClickHouse - ClickHouse® is a free analytics DBMS for big data
JBake - Java based open source static site/blog generator for developers & designers.
PostgreSQL - Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch