Awesome Open Source

Programming Languages

Search results for table plpgsql

47 search results found

PostgreSQL Sample Database

Temporal_tables ⭐ 523

Postgresql temporal_tables extension in PL/pgSQL, without the need for external c extension.

Pgmemento ⭐ 304

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

Adventureworks For Postgres ⭐ 235

Set up the AdventureWorks sample database for use with Postgres

Elixir mix task to generate Ecto models from already existing tables

Periods ⭐ 200

PERIODs and SYSTEM VERSIONING for PostgreSQL

Sqlite_fdw ⭐ 186

SQLite Foreign Data Wrapper for PostgreSQL

A Document Database API extension for Postgres

Hierarchy Data Closure Table ⭐ 165

This is a mysql and postgresql store procedure and trigger implementation of closure table in RDBMS about hierarchy data model.

Duckdb_fdw ⭐ 160

DuckDB Foreign Data Wrapper for PostgreSQL

Postgresql Functions ⭐ 128

Custom PostgreSQL functions and extensions

PostgreSQL script that generates Go struct definitions for all tables in a database

Dune Snippets ⭐ 112

dune snippets is a collection of sql queries for duneanalytics.com / Google BigQuery

Ora_migrator ⭐ 100

Tools for Oracle to PostgreSQL migration

Pgosm Flex ⭐ 90

PgOSM Flex provides high quality OpenStreetMap datasets in PostGIS (Postgres) using the osm2pgsql Flex output.

E-Maj is a PostgreSQL extension that tracks updates on tables sets with rollback capabilities

Pgl_ddl_deploy ⭐ 69

Transparent Logical DDL Replication

Extension for specialized, per-table replication between PostgreSQL instances

Postgresql Tableversion ⭐ 54

PostgreSQL table versioning management software

Mimic Omop ⭐ 54

Mapping the MIMIC-III database to the OMOP schema

Pg_recall ⭐ 50

Simple PostgreSQL extension that keeps track of changes to certain tables

Tableau Server Postgres Queries ⭐ 49

List of all Tableau Server Postgres DB Tables, Joins and Fields

PostgreSQL Sample Database

Postgresql Time Series Table Partitions ⭐ 41

Originally for monthly table partitions, more info at [imperialwicket.com](http://imperialwicket.com/pos

Hasura Jwt Auth ⭐ 40

Hasura JWT auth using PostgreSQL

Schemainspect ⭐ 37

Schema inspection for PostgreSQL (and potentially others).

Docker Postgres World Db ⭐ 33

Example Database for PostgreSQL : World DB

General is a web application development framework

KB is an Akinator like engine written in T-SQL

Poor man's time series functionality for PostgreSQL

Pg Mv Fast Refresh ⭐ 27

postgres MV fast refresh module

Layui Soul Table Java ⭐ 24

layui-soul-table 后台java版

Data logistics system enabling real-time pathogen surveillance. Built for the Seattle Flu Study.

Changes history and tables audit in PostgreSQL

Ps_history ⭐ 20

Scripts to regularly capture MySQL Performance_Schema data into history tables for analysis

Pivotmytable ⭐ 18

PivotMyTable is a PL/Python PosgreSQL function for easy construction of pivot tables, generating the proper code for the crosstab functions from the PostgreSQL extension tablefunc to work.

Pg Audit Json ⭐ 18

Simple, easily customised trigger-based auditing for PostgreSQL (Postgres). See also pgaudit.

Pg Sql Variants ⭐ 18

Variants types for PostgreSQL

Db_vet_clinic ⭐ 17

Dive into the World of Veterinary Care 🏥 : Embark on a journey to build a comprehensive veterinary clinic database. Craft intricate tables using SQL, input data with care, and unleash the power of queries. Our aim: a seamlessly organized relational database for streamlined data management.

Pg Message Queue ⭐ 15

Fork of pg_message_queue by Chris Travers

Macaroon ⭐ 15

Postgres introspection and macros

Pg_doc_store ⭐ 15

Pg_global_temp_tables ⭐ 14

Oracle-style global temporary tables for PostgreSQL

Hoyodecrimen.api ⭐ 14

Website and API for hoyodecrimen

Sql Surveyor ⭐ 13

High-level SQL parser. Identify tables, columns, aliases and more from your SQL script in one easy to consume object. Supports PostgreSQL, MySQL, SQL Server and Oracle (PL/SQL) dialects.

Pipelines Twitter Demo ⭐ 12

Example project which simulates an interesting analytics use case using MemSQL Pipelines.

Postgresql Contrib ⭐ 11

Sql Autocomplete ⭐ 11

Autocomplete recommendations for SQL statements

Postgres extension to copy to/from s3

Postgres Analytics Tutorial ⭐ 9

Exercises for the Architecting Real-Time Analytics for your Customers tutorial

Pg_grants_manager ⭐ 9

PostgreSQL automated grants managment

Pg_fact_loader ⭐ 8

Build fact tables asynchronously with Postgres

Interface for running plpgsql delta scripts along with some plpgsql helper functions

Datamodel ⭐ 8

PostgreSQL / postgis datamodel for TEKSI Wastewater module (Project QGEP)

Time_for_keys ⭐ 7

Temporal foreign keys for Postgres

Find Bad Toast ⭐ 7

Find rows in a PostgreSQL table that have corrupted TOAST records.

Snowflake External Function ⭐ 7

Snowflake External Function for Placekey

Pghistory Tracker ⭐ 7

PostgreSQL History Tracker

data management, warehousing, and reporting in SQL Server.

Galaxql Solutions ⭐ 7

Solution to the intermediate SQL tutorial

Friendlysql ⭐ 6

Friendly advice on SQL from Rafael, Elias, and Mark Armendariz, with advanced queries from Depesz and Mark Guyatt. I've added a handful of queries made on Cameo data

Get_ddl_primitive ⭐ 6

Postgres primitives to get DDL when pg_dump -s is impossible

Postfix Log To Mysql ⭐ 5

Postfix Logs parser to MySQL

Esri_union ⭐ 5

The basic idea is that you call this function and with 2 tables as input. The code builds a grid to splits up the data, compute the result and return a table name with a union of this two tables. More info at https://github.com/larsop/esri_union/wiki and https://github.com/larsop/esri_union/blob/master/R . Norwegian Institute of Bioeconomy Research (NIBIO)

Pgsql_shadow_tables ⭐ 5

Shadow table management for PostgreSQL

🏡 🏬 🏭 Determine the Zoning of a Parcel

Content_balanced_grid ⭐ 5

Content balanced grid code splits the map based on content not on size. Norwegian Institute of Bioeconomy Research (NIBIO)

Jira Groups Renamer ⭐ 5

SQL script for batch group renaming in Atlassian Jira

Pg_fkpart ⭐ 5

PostgreSQL extension to partition tables following a foreign key

Text patterns clustering in PostgreSQL

Related Searches

Javascript Table (4,575)

Python Table (3,241)

Database Table (2,713)

Php Table (2,441)

Java Table (1,600)

Table Sql (1,404)

Ruby Table (1,254)

Html Table (1,252)

Mysql Table (1,067)

Postgresql Table (792)

1-47 of 47 search results

Privacy | About | Terms | Follow Us On Twitter

Copyright 2018-2024 Awesome Open Source. All rights reserved.