GitHub topics: plpgsql | Ecosyste.ms: Repos

docwho2/java-postgres-lambda-trigger

Example of Triggering Java Lambda functions from AWS RDS Postgres with User Interface

Language: Java - Size: 2.3 MB - Last synced at: 3 days ago - Pushed at: 3 days ago - Stars: 0 - Forks: 3

stackernews/stacker.news

Trying to fix online communities with economics

Language: JavaScript - Size: 40.5 MB - Last synced at: 3 days ago - Pushed at: 3 days ago - Stars: 480 - Forks: 129

pgpartman/pg_partman

Partition management extension for PostgreSQL

Language: PLpgSQL - Size: 3.2 MB - Last synced at: 4 days ago - Pushed at: 2 months ago - Stars: 2,305 - Forks: 289

seart-group/labeler

Quickly set up and perform real-time, collaborative manual analysis

Language: EJS - Size: 1.32 MB - Last synced at: 5 days ago - Pushed at: 5 days ago - Stars: 3 - Forks: 0

postgis/postgis

PostGIS spatial database extension to PostgreSQL [mirror]

Language: PLpgSQL - Size: 197 MB - Last synced at: 4 days ago - Pushed at: 5 days ago - Stars: 1,851 - Forks: 394

okbob/plpgsql_check

plpgsql_check is a linter tool (does source code static analyze) for the PostgreSQL language plpgsql (the native language for PostgreSQL store procedures).

Language: C - Size: 2.02 MB - Last synced at: 3 days ago - Pushed at: 28 days ago - Stars: 683 - Forks: 54

aquametalabs/aquameta

Web development platform built entirely in PostgreSQL

Language: PLpgSQL - Size: 42.6 MB - Last synced at: 3 days ago - Pushed at: 19 days ago - Stars: 1,094 - Forks: 52

pgMemento/pgMemento

Audit trail with schema versioning for PostgreSQL using transaction-based logging

Language: PLpgSQL - Size: 7.96 MB - Last synced at: 2 days ago - Pushed at: 2 months ago - Stars: 389 - Forks: 41

KaioGabriel-the/Banco-de-Dados

Repositório para as questões da matéria de "Banco de Dados II".

Language: PLpgSQL - Size: 15.6 KB - Last synced at: 11 days ago - Pushed at: 12 days ago - Stars: 0 - Forks: 0

ChojoGebutsu/PostgreSQL-Data-Analytics-Project

This repository contains SQL scripts for analyzing ERP and CRM data from the gold layer of the data warehouse built in PostgreSQL-Data-Warehouse-Project. It covers both exploratory data analysis and advanced analytics techniques like trend analysis, cumulative metrics, performance tracking, data segmentation, and part-to-whole evaluation.

Size: 336 KB - Last synced at: 13 days ago - Pushed at: 13 days ago - Stars: 0 - Forks: 0

qwat/qwat-data-model

TEKSI Water module (project QWAT) - PostgreSQL / postgis Datamodel

Language: HTML - Size: 31.4 MB - Last synced at: 11 days ago - Pushed at: 13 days ago - Stars: 23 - Forks: 24

Cris-Neumann/Random-scripts

Repositorio donde iré alojando scripts random que he ido creando en Python (varias librerías), SQL (funciones de ventana), Visual Basic, etc.

Language: Jupyter Notebook - Size: 855 KB - Last synced at: 11 days ago - Pushed at: 13 days ago - Stars: 0 - Forks: 0

modeldba/antlr4ts-sql

Pre-built SQL grammars that you can import and “just use”. No configuration necessary.

Language: TypeScript - Size: 5.2 MB - Last synced at: 10 days ago - Pushed at: about 4 years ago - Stars: 33 - Forks: 11

modeldba/sql-autocomplete

Autocomplete recommendations for SQL statements

Language: TypeScript - Size: 212 KB - Last synced at: 10 days ago - Pushed at: about 4 years ago - Stars: 62 - Forks: 8

mcabas/Datacamp_Notebook

Datacamp Learning Journey

Language: Jupyter Notebook - Size: 21.1 MB - Last synced at: 19 days ago - Pushed at: 19 days ago - Stars: 3 - Forks: 0

apostoldevel/db-platform

The database of the Apostol CRM software platform

Language: PLpgSQL - Size: 1.98 MB - Last synced at: 23 days ago - Pushed at: 23 days ago - Stars: 2 - Forks: 1

CrisCorreaS/apuntes-sql

Apuntes y ejercicios resueltos de SQL en PostgreSQL, SQL Server y phpMyAdmin

Size: 56.5 MB - Last synced at: 30 days ago - Pushed at: about 1 month ago - Stars: 5 - Forks: 0

Adyen/adyen-postgres-partitioning

Functions to manage partitions in PostgreSQL with minimal impact for applications

Language: PLpgSQL - Size: 33.2 KB - Last synced at: 7 days ago - Pushed at: over 1 year ago - Stars: 57 - Forks: 8

andreystepanov/hashids.sql

PL/pgSQL implementation of hashids library

Language: PLpgSQL - Size: 7.81 KB - Last synced at: 4 days ago - Pushed at: over 2 years ago - Stars: 49 - Forks: 11

lorindi/SoftUni-Software-Engineering

SoftUni

Language: HTML - Size: 204 MB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 28 - Forks: 1

jankovicsandras/plpgsql_bm25

BM25 search implemented in PL/pgSQL

Language: Jupyter Notebook - Size: 1.26 MB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 42 - Forks: 0

JakeTheSillySnake/SQLBootcamp

PostgreSQL tasks for School21 bootcamp.

Language: PLpgSQL - Size: 591 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

cleaning-corp/DB

БД для клининговой компании: учёт заказов, клиентов, сотрудников и т.д.

Language: SQL - Size: 39.1 KB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 3 - Forks: 0

chanukyasds/pg_math

pg_math extension to support statistical distribution functions for PostgreSQL

Language: C - Size: 27.3 KB - Last synced at: about 1 month ago - Pushed at: almost 2 years ago - Stars: 16 - Forks: 1

Imtjl/distributed-storage-systems

Distributed Storage Systems - a 3rd year CSE banchelor course in ITMO University

Language: PLpgSQL - Size: 2.85 MB - Last synced at: about 1 month ago - Pushed at: about 1 month ago - Stars: 0 - Forks: 0

omniti-labs/mimeo

Extension for specialized, per-table replication between PostgreSQL instances

Language: PLpgSQL - Size: 1.22 MB - Last synced at: 27 days ago - Pushed at: almost 8 years ago - Stars: 78 - Forks: 14

tobistudio/php-shop-site

As Popular shopping site , I developed using php framework and strong structure called Vmoex. In comparison to other programming languages, PHP demonstrates a significant speed advantage 😍😍😍

Language: PHP - Size: 6.41 MB - Last synced at: about 1 month ago - Pushed at: about 1 year ago - Stars: 10 - Forks: 2

luk4z7/plpgsql-tools

Helpers for PL/pgSQL applications

Language: PLpgSQL - Size: 11.7 KB - Last synced at: about 1 month ago - Pushed at: over 7 years ago - Stars: 14 - Forks: 1

funbringer/pg_linegazer

Transparent code coverage for PL/pgSQL

Language: C - Size: 21.5 KB - Last synced at: about 1 month ago - Pushed at: over 7 years ago - Stars: 7 - Forks: 5

ng-galien/idea-plpgdebugger

A plugin to debug PL/pg in Intellij

Language: Kotlin - Size: 3.92 MB - Last synced at: about 1 month ago - Pushed at: 6 months ago - Stars: 52 - Forks: 8

44437/weather-api

Language: Go - Size: 154 KB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 0 - Forks: 0

fgiorgia/data-cleaning-for-housing-data

Cleaning the Nashville Housing Data dataset.

Language: PLpgSQL - Size: 3.29 MB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 0 - Forks: 0

agu3des/Disaster

Website about disasters

Language: HTML - Size: 1.45 MB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 0 - Forks: 0

tilezen/vector-datasource

Tilezen vector tile service - OpenStreetMap data in several formats

Language: Python - Size: 70.9 MB - Last synced at: 3 days ago - Pushed at: about 2 months ago - Stars: 512 - Forks: 121

jannis15/todo

made with Flutter & Supabase

Language: JavaScript - Size: 579 KB - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 0 - Forks: 0

olithissen/suncalc_postgres

A pure PL/pgSQL port of suncalc.js

Language: PLpgSQL - Size: 247 KB - Last synced at: about 1 month ago - Pushed at: almost 2 years ago - Stars: 7 - Forks: 1

mohit01chugh/edu_sql_analysis

SQL queries used to analyze student data.

Language: PLpgSQL - Size: 2.05 MB - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 0 - Forks: 0

michelp/metagration

Metagration: PostgreSQL Migrator in PostgreSQL

Language: PLpgSQL - Size: 177 KB - Last synced at: about 1 month ago - Pushed at: over 3 years ago - Stars: 101 - Forks: 4

ChojoGebutsu/PostgreSQL-Data-Warehouse-Project

Building a Data Warehouse with PostgreSQL, including ETL processes, Data Modeling, and Analytics.

Language: PLpgSQL - Size: 1.61 MB - Last synced at: 2 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

dmtai/realworld_service

Implementation of realworld app backend api

Language: C++ - Size: 228 KB - Last synced at: 5 days ago - Pushed at: almost 2 years ago - Stars: 9 - Forks: 3

piotrmludzik/SpotifyDB 📦

Codecool exercise | DB modeling

Language: PLpgSQL - Size: 1.92 MB - Last synced at: 3 days ago - Pushed at: about 4 years ago - Stars: 0 - Forks: 0

octcarp-courses/SUSTech_CS307-DB_S23_Works

Three SQL programming assignments of CS307 2023 Spring: Database Principle, SUSTech. Taught by Prof. Yuxin MA.

Language: PLpgSQL - Size: 0 Bytes - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

dcgadmin/plpgsql-deepdive

PL/pgSQL Exercise to solve challenges encounter in Application.

Language: Python - Size: 11.6 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

GabrielU3/Database-Cellphone-Enterprise

SQL Database Implementation for a fictional enterprise that sells cell phones

Language: PLpgSQL - Size: 678 KB - Last synced at: about 1 month ago - Pushed at: 3 months ago - Stars: 6 - Forks: 0

sqids/sqids-plpgsql

Official PLpgSQL (PostgreSQL) port of Sqids. Generate short unique IDs from numbers.

Language: PLpgSQL - Size: 16.6 KB - Last synced at: about 1 month ago - Pushed at: 8 months ago - Stars: 20 - Forks: 3

TomasCuevas/Aprendiendo-SQL

Seguimiento de TAREAS y CLASES del curso de SQL de Fernando Herrera

Size: 69.3 KB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

entgl-t/hotspot_billing

Language: JavaScript - Size: 5.47 MB - Last synced at: about 1 month ago - Pushed at: about 3 years ago - Stars: 3 - Forks: 0

theoheneba/cofounder

A platform for connecting entrepreneurs with potential co-founders. Built with React, TypeScript, Tailwind CSS, and Supabase.

Language: TypeScript - Size: 468 KB - Last synced at: 3 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

agu3des/Dados

Learning Data

Language: PLpgSQL - Size: 112 KB - Last synced at: 2 days ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

tonytech83/Python-DB

Softuni - Python DB - September 2023

Language: Python - Size: 3.61 MB - Last synced at: 28 days ago - Pushed at: 4 months ago - Stars: 2 - Forks: 0

Jardinesdelareina/grok_postgresql

База знаний PostgreSQL

Language: PLpgSQL - Size: 48.3 MB - Last synced at: about 1 month ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

PierreRochard/general

General is a web application development framework

Language: Python - Size: 324 KB - Last synced at: about 1 month ago - Pushed at: 11 months ago - Stars: 35 - Forks: 5

mina-faridi/Database_lab_exercises

Database lab exercises (fall 2020)

Language: PLpgSQL - Size: 11.2 MB - Last synced at: 3 months ago - Pushed at: over 3 years ago - Stars: 0 - Forks: 0

Wassim-Rached/PostgreSQL-projects-examples

Explore a robust PostgreSQL repository featuring efficient indexes, triggers, views, functions, PL/pgSQL scripts, and insightful diagrams for advanced project development and database optimization.

Language: PLpgSQL - Size: 320 KB - Last synced at: 3 months ago - Pushed at: over 1 year ago - Stars: 1 - Forks: 0

oelmekki/pgrebase

Easy postgres codebase injection - aka postgres non data live reload

Language: Go - Size: 9.13 MB - Last synced at: about 1 month ago - Pushed at: almost 2 years ago - Stars: 337 - Forks: 14

fontseca/noda-tasks-management-tool-api

A robust task management RESTful API developed with Go, PostgreSQL, JWT for authentication, and Docker for containerization. It features secure user authentication, task creation and management.

Language: Go - Size: 1.35 MB - Last synced at: about 1 month ago - Pushed at: 6 months ago - Stars: 9 - Forks: 0

BedquiltDB/bedquilt-core

A JSON document store on PostgreSQL

Language: PLpgSQL - Size: 502 KB - Last synced at: about 1 month ago - Pushed at: about 2 years ago - Stars: 255 - Forks: 14

worthant/Databases-course

This course is about databases fundamentals

Language: PLpgSQL - Size: 6.44 MB - Last synced at: about 1 month ago - Pushed at: about 2 years ago - Stars: 5 - Forks: 0

noteflakes/pmts

Poor man's time series functionality for PostgreSQL

Language: PLpgSQL - Size: 30.3 KB - Last synced at: about 1 month ago - Pushed at: 8 months ago - Stars: 32 - Forks: 0

Sunshine-ki/BMSTU5_DB

Language: Python - Size: 46.2 MB - Last synced at: about 1 month ago - Pushed at: over 4 years ago - Stars: 15 - Forks: 0

lafriks/pgulid Fork of geckoboard/pgulid

Universally Unique Lexicographically Sortable Identifier (ULID) for PostgreSQL

Language: PLpgSQL - Size: 8.79 KB - Last synced at: 4 months ago - Pushed at: 6 months ago - Stars: 5 - Forks: 1

theodoremoreland/REDB-API Fork of stlrda/redb-api

A Python and FastAPI based asynchronous REST API for accessing St. Louis Parcel Data stored in the Regional Entity Database (REDB)

Language: Python - Size: 797 KB - Last synced at: 4 months ago - Pushed at: 12 months ago - Stars: 1 - Forks: 0

Inspirate789/BMSTU-DB

:open_file_folder: Лекции, семинары и лабораторные работы по курсу "Базы данных" в МГТУ им. Н. Э. Баумана.

Language: Go - Size: 79.8 MB - Last synced at: 3 months ago - Pushed at: over 2 years ago - Stars: 1 - Forks: 1

anitagraser/postgis-spatiotemporal

Spatio-temporal trajectory functions beyond the built-in PostGIS temporal support (https://postgis.net/docs/reference.html#Temporal)

Language: PLpgSQL - Size: 19.5 KB - Last synced at: about 1 month ago - Pushed at: over 6 years ago - Stars: 13 - Forks: 3

lealre/northwind-PLpgSQL

Performing Stored Procedures and Triggers in PostgreSQL Database - PL/pgSQL

Size: 707 KB - Last synced at: about 1 month ago - Pushed at: 12 months ago - Stars: 4 - Forks: 0

dmtai/currexch_service

HTTP-service on boost::asio and postgres

Language: C++ - Size: 115 KB - Last synced at: 3 months ago - Pushed at: over 1 year ago - Stars: 1 - Forks: 0

Crdzbird/Secured-SQL

This SQL was created with the purpose to give that extra security that sometimes is needed in the Database.

Language: TSQL - Size: 42 KB - Last synced at: 3 months ago - Pushed at: almost 5 years ago - Stars: 3 - Forks: 0

PurposeAchiever6/exportbrainGPT

Quivr, your second brain, utilizes the power of GenerativeAI to store and retrieve unstructured information. Think of it as Obsidian, but turbocharged with AI capabilities.

Language: TypeScript - Size: 2.26 MB - Last synced at: about 1 month ago - Pushed at: over 1 year ago - Stars: 5 - Forks: 0

Lucas-Erkana/Vet-clinic

In this project, you I will use a relational database to create the initial data structure for a vet clinic. I will create a table to store animals' information, insert some data into it, and query it.

Language: PLpgSQL - Size: 166 KB - Last synced at: about 1 month ago - Pushed at: about 2 years ago - Stars: 6 - Forks: 0

AnsarIbrahim/Vet-Clinic

The Vet-Clinic-database is a comprehensive system that manages patient records, appointments, treatments, and billing for a veterinary clinic. It enables efficient scheduling, tracks medical history, and supports seamless communication between staff. This database ensures quality care for pets and streamlines administrative tasks.

Language: PLpgSQL - Size: 132 KB - Last synced at: about 1 month ago - Pushed at: over 1 year ago - Stars: 5 - Forks: 0

Smile040501/RailwayReservationSystem

This project aims to build a railway reservation system which is a software application that handles the entire booking data of the railway. This software can also be used by different railway companies to carry out operations in a smooth, effective, and automated manner.

Language: PLpgSQL - Size: 3.47 MB - Last synced at: about 1 month ago - Pushed at: about 3 years ago - Stars: 3 - Forks: 5

pereiraR3/DB-ModelingDatabase-Rede-de-Farmacias

Modelagem de Banco de Dados de uma Rede de Filiais - Projeto elaborado durante a disciplina de Lab. de Banco de Dados

Language: PLpgSQL - Size: 1.85 MB - Last synced at: 3 days ago - Pushed at: 9 months ago - Stars: 0 - Forks: 0

MLT93/bubbo-technical-test

Carry out technical test for the Bubbo company

Language: TypeScript - Size: 67.1 MB - Last synced at: 3 months ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

leonard-namolaru/bdd-agence-musiciens

[Note : 18/20] Projet UE Bases de données avancées (Université Paris Cité , M1) - Base de données pour une agence représentant des musiciens : Modélisation, peuplement, fonctions PL/pgSQL, triggers, indexes.

Language: PLpgSQL - Size: 619 KB - Last synced at: 3 months ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

fontseca/noda-database

The PostgreSQL database repository for the NODA project.

Language: PLpgSQL - Size: 164 KB - Last synced at: 3 months ago - Pushed at: 9 months ago - Stars: 0 - Forks: 0

user-of-github/BSUIR_course-projects 📦

Repository for course projects

Language: C++ - Size: 125 MB - Last synced at: 10 months ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

bishopce16/stroke_prediction_analysis

The purpose of this project is to derive insight on characteristics and statistics regarding the dataset to see which factors influence whether or not a patient has had a stroke.

Language: Jupyter Notebook - Size: 27.2 MB - Last synced at: 21 days ago - Pushed at: over 2 years ago - Stars: 3 - Forks: 3

merendamattia/BdD

BdD - Basi di Dati presso l'Università degli Studi di Parma (9 CFU).

Language: PLpgSQL - Size: 64.5 KB - Last synced at: about 1 month ago - Pushed at: over 2 years ago - Stars: 4 - Forks: 0

YaSargis/jelata-framework

Jelata Framework

Language: Python - Size: 40.3 MB - Last synced at: about 2 months ago - Pushed at: 10 months ago - Stars: 2 - Forks: 0

sravanigodavarthi/OLTP-Banking-Database

An OLTP banking system is implemented, emphasizing data integrity and atomicity, and leveraging constraints, triggers, stored procedures, views, and indexing to enhance query performance.

Language: Python - Size: 469 KB - Last synced at: 2 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

nayanesenhorinha/data_analytics

Exercícios do curso de Analista de Dados do Senac Rio em parceria com o programa "Programadores Cariocas no Mercado Segurador".

Language: Jupyter Notebook - Size: 4.6 MB - Last synced at: 3 months ago - Pushed at: 11 months ago - Stars: 0 - Forks: 0

bursasha/oracle-postgresql-projects

Advanced SQL, covering Oracle PL/SQL and PostgreSQL PL/pgSQL with phases on using procedures, functions, triggers, query optimizations, packages, and Docker server setup 💡

Language: PLSQL - Size: 12 MB - Last synced at: 3 months ago - Pushed at: 11 months ago - Stars: 0 - Forks: 0

Manoel-Mieiro/ADM_BD_24_P2

Arquitetura e composição do banco de dados do time de vendas da empresa DF paper company; objeto de estudo para a segunda avaliação da disciplina de Administração de Banco de Dados, ministrada pelo docente Diego Cardoso Borda Castro no Centro Federal de Educação Tecnológica da Celso Suckow da Fonseca durante o primeiro semestre de 2024.

Language: PLpgSQL - Size: 42.2 MB - Last synced at: 3 months ago - Pushed at: 11 months ago - Stars: 0 - Forks: 0

lealre/sql-bootcamp-de

Projects and Classes from SQL Bootcamp for Data Engineering

Language: PLpgSQL - Size: 541 KB - Last synced at: about 2 months ago - Pushed at: 12 months ago - Stars: 0 - Forks: 0

theodoremoreland/REDB Fork of stlrda/REDB-Workflows

A Python automated ELT pipeline that routinely aggregates 20+ million rows of parcel data from numerous local government departments for the Regional Entity Database.

Language: PLpgSQL - Size: 43.4 MB - Last synced at: 4 months ago - Pushed at: 12 months ago - Stars: 1 - Forks: 0

ViktorVx/pl-pg-sql-learning

PL/pgSQL learning scripts

Language: PLpgSQL - Size: 2.93 KB - Last synced at: 3 months ago - Pushed at: about 4 years ago - Stars: 1 - Forks: 0

array-analytics/plpg_hashids

Short unique id generator for PostgreSQL in plpgsql, using hashids.org

Language: PLpgSQL - Size: 45.9 KB - Last synced at: about 1 month ago - Pushed at: over 2 years ago - Stars: 36 - Forks: 8

nayanesenhorinha/peg_02

Projeto em grupo do módulo 2 do curso Analise de dados - Programadores Cariocas no Mercado Segurador.

Language: PLpgSQL - Size: 250 KB - Last synced at: 3 months ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 1

amoghkori/retail_data_analysis

Retail data analysis pipeline utilizing AWS S3, Snowflake, Python, SQL, and Tableau. It demonstrates data transformation and setup in Jupyter Notebook, integrates real-time retail insights via an automated Tableau dashboard with Snowflake, and employs a CRON job in Jupyter Lab connected to Amazon SQS for consistent data updates.

Language: Jupyter Notebook - Size: 16.9 MB - Last synced at: 3 months ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0