pg_timetable
pgweb
Our great sponsors
pg_timetable | pgweb | |
---|---|---|
7 | 4 | |
1,015 | 8,282 | |
1.7% | - | |
7.8 | 7.2 | |
about 1 month ago | 7 days ago | |
Go | Go | |
GNU General Public License v3.0 or later | MIT 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.
pg_timetable
-
Do I need to keep maintaining the partitions?
That's easily done with a cron job or something similar (e.g. pg_timetable)
- pg_timetable: Advanced Scheduling for PostgreSQL
-
PG_DBMS_JOB – An Open Source PostgreSQL extension for Oracle DBMS_JOB compatibility
When you are working on Oracle to PostgreSQL migrations, one of the Oracle packages that cause conversion issues is DBMS_JOB. Traditionally, we used extensions like : pg_agent, pg_cron or more recently pg_timetable for scheduling jobs. All of these tools or extensions use a cronjob like scheduling method which does not give a full compatibility of the features provided by Oracle DBMS_JOB. Translating calls to DBMS_JOB.SUBMIT() into a cron setting is more painful than being impossible when there is an execution interval lesser than a minute. There are several such DBMS_JOB compatibility issues including asynchronous scheduling which is not possible with the already existing extensions in PostgreSQL. MigOps hates to stay without Open Source solutions. So, we are announcing PG_DBMS_JOB extension for Oracle DBMS_JOB compatibility, released under PostgreSQL License. An interesting point here is that we have included full compatibility of Oracle DBMS_JOB in PG_DBMS_JOB PostgreSQL extension.
-
pgAgent install on Windows failing.
If you don't want to (or can't) use the Windows Scheduler, you might want to try out pg_timetable instead, which also offers Windows binaries.
- How to launch a thread/job from PL/pgSQL or otherwise from inside of the database?
-
Postgres as a Cron Server
Try pg_timetable
-
How to send email notifications with event triggers on PostgreSQL?
You better send emails periodically with cron-like scheduler. This one can do both cron and periodical jobs: https://github.com/cybertec-postgresql/pg_timetable
pgweb
-
Ask HN: What apps have you created for your own use?
Built Pgweb (Postgres GUI) some time ago since I could not find a good minimalistic database explorer.
https://github.com/sosedoff/pgweb
The app is super simple, made with Go + jQuery and I still use it almost every day, and has brought it to every single company I've been with.
- Slashbase: A modern in-browser database IDE & CLI for your dev & data workflows. Supports PostgreSQL & MongoDB.
- Slashbase: The open-source in-browser database IDE & CLI for your dev/data workflows written in Golang. Supports: PostgreSQL & MongoDB.
-
A nice front end for reading mysql or postgres data?
For postgresql, pgweb is perfect.
What are some alternatives?
pg_cron - Run periodic jobs in PostgreSQL
rqlite - The lightweight, distributed relational database built on SQLite.
pg_dbms_job
Dotsql - A Golang library for using SQL.
groupcache - groupcache is a caching and cache-filling library, intended as a replacement for memcached in many cases.
cockroach - CockroachDB - the open source, cloud-native distributed SQL database.
prometheus - The Prometheus monitoring system and time series database.
tidb - TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at : https://tidbcloud.com/free-trial
jaeger - CNCF Jaeger, a Distributed Tracing Platform
sqlhooks - Attach hooks to any database/sql driver
vitess - Vitess is a database clustering system for horizontal scaling of MySQL.
InfluxDB - Scalable datastore for metrics, events, and real-time analytics