Suljettu

pg_timetable: PostgreSQL scheduling on steroids

pg_timetable has been written by us and implements a sophisticated PostgreSQL

based scheduler for database tasks. It has been written in Go (codes and Github

can be provided). What is the purpose of the thing?

There are many reasons we wrote it:

a.) cron is not powerful enough. It does not prevent that the

very same job is executed twice at the same time

b.) cron can execute at a certain point in time but it cannot execute

"as soon as possible".

c.) cron does not take parameters and all it does it launching a script

pg_timetable is different. It stores all its configuration in a PostgreSQL

database. It reads this stuff once a minute or so and launches a job.

pg_timetable does not only launch a job - that would be too simple. We got a bit

different semantics.

We got: base tasks, builtin tasks and chains. What we actually schedule is

chains. We also preserve a transactional semantic.

So what is a base task? Base tasks could be ...

- send an email given a certain mail template

- run some SQL. e.g.:

SELECT func1($1), func2($2) FROM tab WHERE f = $3;

COPY t_table FROM '$1' CSV HEADER; -- $1 = filename

- run a shell script

./[login to view URL] url ...

This allows us to form chains which might do the following:

BEGIN;

./[login to view URL] url ...

SELECT aggregate_data($1);

INSERT INTO log ...

COMMIT;

./delete_downloaded_files ...

INSERT INTO log ...

builtin_send_mail(...)

As you can see the idea is to mix elements of SQL and shell and builtin stuff

while maintaining PostgreSQL transactions.

Currently pg_timetable is pretty good already. It works but it is not heavily

tested, poorly documented, lacks documentation and most importantly examples.

There are tests already but we want to expand them and run things for a while to

see, if it reliable. It will be the backbone of one of our products and it will

be released as Open Source once it is stable.

Taidot: Golang, PostgreSQL, SQL

Näytä lisää: how to create scheduled job in postgresql, create scheduler in postgresql, pg_cron postgresql example, postgres vacuum, postgres cron function, pg_cron aws, pg_cron rds, postgresql scheduled query

Tietoa työnantajasta:
( 0 arvostelua ) Vienna, Austria, Austria

Projektin tunnus: #19796715

19 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön

abstractsoftweb

[login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] https://datemyfriend.c Lisää

€18 EUR / tunti
(8 arvostelua)
5.6
BigCityInstitute

Hi, sir Thank you for reading my bid. I have already completed a lot of backends by using golang. Especially, I have rich experience microservice backend development. As you know, golang is very excellent in perfor Lisää

€20 EUR / tunti
(3 arvostelua)
5.5
engmalaa

Hello, I am Postgresql expert and I can join you immediately to help you in your urgent tasks. Please let us discuss the details. Regards, Mohammad Alaa

€27 EUR / tunti
(5 arvostelua)
4.0
adampohp79

Hi. thanks for your posting. I'm very happy to have a chance of bidding your project. I have experience in development of the projects like yours If you hire me, I'll do my best for your project and finish greatly in a Lisää

€27 EUR / tunti
(6 arvostelua)
4.1
Ipullar

Hi, As a senior Go/Postgres SQL expert, I am so interested in your job description. I can commit up to 30+ hrs per week, MON-FRI 6~8 hrs per day. I look forward to having the opportunity to discuss the job further. Let Lisää

€30 EUR / tunti
(1 arvostelu)
4.4
hjr122413

Howdy. I am glad to see you. Kindly review my profile: https://www.freelancer.com/u/hjr122413 I just checked your project “pg_timetable: PostgreSQL scheduling on steroids” and I have gone through your project details Lisää

€35 EUR / tunti
(3 arvostelua)
4.0
RiHCh

Hi,Dear. I will be your Freelancer Forever! I have many development experiences,getting work about . As I am interested in your project, I've read the project description and definitely can develop your task. If I hir Lisää

€27 EUR / tunti
(4 arvostelua)
4.0
huseyinaygun

Hi, I have 10-year experience of SQL development. I developed reports or enhanced performance of queries in the reports using Oracle Reports, Oracle BI reports, SQL, Oracle packages for the following projects: -Ca Lisää

€27 EUR / tunti
(4 arvostelua)
3.8
springdragon43m

Hi, I am interested in your project. I have 7 years of experiences in web development. So I can help you and am ready to start now. Looking forward to hearing from you soon. Regards

€30 EUR / tunti
(1 arvostelu)
3.6
VirtualBrainInc

Hello! I have briefly read the description on timetable-postgresql-scheduling-steroids development project, and I can deliver as per the requirements however I need us to discuss for more clarity on the detai Lisää

€30 EUR / tunti
(1 arvostelu)
2.8
Zhenqiang

Hello, client. I read your job description carefully, and I got interested in your project. I am a Senior PostgreSQL developer with 10+ years of software development career. Through reading your job post, I thought I a Lisää

€27 EUR / tunti
(1 arvostelu)
2.1
TimPollard

G'day, Your cron replacement app sounds interesting. I'd definitely be interested in working on it. I'm a talented developer and Linux DevOps engineer with over a decade's professional experience maintaining Linux ma Lisää

€36 EUR / tunti
(0 arvostelua)
0.0
bfaconsultora

Wide experience working with PostgreSQL (+10 years), specialy server side programming (PLPGSQL, Python, C, C++). Knowledge of Go programming. Also experience in writting technical papers / user manual / software docum Lisää

€18 EUR / tunti
(0 arvostelua)
0.0
grigorywazin

Nice to meet you! I'm good at postgresql. I read your job description carefully. Before start project, you can test my skills. I can do this. *************************

€20 EUR / tunti
(0 arvostelua)
0.0
chesslover

Hi there, I am a Go/Golang developer mainly using gRPC, protobuf, sqlx (jmoiron), Buffalo framework, CDK, dep, Go modules, govet, gofmt, and godoc. For Go unit testing I mainly use testify and DATA-DOG/go-sqlmock. Th Lisää

€25 EUR / tunti
(0 arvostelua)
0.0
anatolygenay123

Hi, How are you? Greetings from Yoshida in Japan! ⭐24hours communication, if you need, I can work as full time⭐ I’ve carefully gone through your job post. I feel very confident on your project and You will get the "B Lisää

€30 EUR / tunti
(1 arvostelu)
0.0
DevStar925

Hi there? I read your project description just now and I understood your issues. As I am a senior PostgreSQL Expert, so I am confident I can solve your issue properly. Please ping me for more discussion asap. Regards

€27 EUR / tunti
(0 arvostelua)
0.0
Clientfirst0416

Promise the high-quality code and deliver it in time. I have read your job description pretty carefully and I am sure that I can do your job. Your job seems to be posted only for me not for the others, because you are Lisää

€20 EUR / tunti
(0 arvostelua)
0.0
€36 EUR / tunti
(0 arvostelua)
0.0