dev-db/cstore_fdw::defiance
- Ebuilds: 1, Testing: 1.7.0 Description:
Cstore_fdw is an open source columnar store extension for PostgreSQL. Columnar
stores provide notable benefits for analytics use cases where data is loaded
in batches. Cstore_fdw's columnar nature delivers performance by only reading
relevant data from disk, and it may compress data 6x-10x to reduce space
requirements for data archival.
Homepage:https://www.citusdata.com/ License: AGPL-3
dev-db/datadraw::gentoo
- Ebuilds: 2, Testing: 3.1.1-r1 Description:
DataDraw is a feature rich database generator for high performance C applications. DataDraw gives your C application a high performance object-oriented framework at speeds that beat hand coded C.
Homepage:http://datadraw.sourceforge.net/ License: LGPL-2
dev-db/datagrip::xoores
- Ebuilds: 1, Stable: 2021.3.4 Description: Database IDE that is tailored to suit the specific needs of professional SQL developers
Homepage:https://www.jetbrains.com/datagrip/ License: || ( IDEA IDEA_Academic IDEA_Classroom IDEA_OpenSource IDEA_Personal )
dev-db/datanymizer::nest
- Ebuilds: 2, Testing: 0.7.2, Snapshot: 9999 Description:
Datanymizer is powerful database anonymizer with flexible rules,
capable to dump data directly from your database, applying the rules
that you define, and it even integrates the Tera templating engine
to enable complex values to be synthesized.
Homepage:https://github.com/datanymizer/datanymizer License: Apache-2.0 Apache-2.0-with-LLVM-exceptions BSD BSD-2 Boost-1.0 ISC MIT Unlicense ZLIB
dev-db/dbcrossbar::nest
- Ebuilds: 2, Testing: 0.5.8_pre3, Snapshot: 9999 Description:
dbcrossbar is a tool that copies large, tabular datasets between
many different databases and storage formats. Data can be copied
from any source to any destination.
Homepage:https://www.dbcrossbar.org License: Apache-2.0 BSD CC0-1.0 ISC MIT MPL-2.0 Unicode-DFS-2016 ZLIB
dev-db/dbgate-bin::nest
- Ebuilds: 1, Testing: 6.7.0 Description:
A database manager for MySQL, PostgreSQL, SQL Server and MongoDB,
with features: table data editing, with SQL change script preview,
master/detail views, query designer and etc.
Homepage:https://github.com/dbgate/dbgate License: MIT
dev-db/dummy_seclabel::nest
- Ebuilds: 2, Testing: 1.0, Snapshot: 9999 Description:
The dummy_seclabel module exists only to support regression testing of
the SECURITY LABEL statement. It is not intended to be used in production.
Homepage:https://github.com/postgres/postgres License: POSTGRESQL
dev-db/dynein::nest
- Ebuilds: 2, Testing: 0.3.0, Snapshot: 9999 Description:
This package provides a command line interface for Amazon DynamoDB.
It is designed to make it simple to interact with DynamoDB tables/items
from terminal.
Homepage:https://github.com/awslabs/dynein License: Apache-2.0 BSD Boost-1.0 ISC MIT Unicode-DFS-2016
dev-db/gqlplus::gentoo
- Ebuilds: 1, Testing: 1.16-r2 Description:
gqlplus is a front-end for Oracle program sqlplus with
command-line editing, history, table-name and column-name
completion. Otherwise the user interface is identical to that of
sqlplus. Command-line editing works as in bash/tcsh shells.
Homepage:https://gitlab.com/jessp011/gqlplus License: GPL-2
hypopg (available in: dev-db/hypopg::defiance, dev-db/hypopg::gentoo)
- Ebuilds: 3, Testing: 1.4.3-r1 Description:
HypoPG is a PostgreSQL extension adding support for hypothetical indexes.
An hypothetical, or virtual, index is an index that doesn't really exists,
and thus doesn't cost CPU, disk or any resource to create. They're useful
to know if specific indexes can increase performance for problematic queries,
since you can know if PostgreSQL will use these indexes or not without
having to spend resources to create them.
Homepage:http://hypopg.github.io/hypopg/ License: Apache-2.0
dev-db/influxdb::gentoo
- Ebuilds: 3, Testing: 2.7.11 Description:
InfluxDB is an open source time series database with no external
dependencies. It is useful for recording metrics, events, and
performing analytics.
Homepage:https://www.influxdata.com License: Apache-2.0 BSD BSD-2 EPL-2.0 ISC MIT MPL-2.0
dev-db/ip4r::nest
- Ebuilds: 2, Testing: 2.4.2, Snapshot: 9999 Description:
IP4R is a contributed PostgreSQL module that embraces and extends the
existing 'inet' and 'cidr' built-in types, providing extra functionality
and simplicity to IPv4 and IPv6 address lookup within large-scale
environments.
Homepage:https://github.com/RhodiumToad/ip4r License: POSTGRESQL
dev-db/kafka_fdw::defiance
- Ebuilds: 1, Snapshot: 9999 Description:
At this point the project is not yet production ready. Use with care. Pull requests welcome
A simple foreign data wrapper for Kafka which allows it to be treated as a table.
Currently kafka_fdw allows message parsing in csv and json format. More might come in a future release.
Homepage:https://github.com/adjust/kafka_fdw License: AGPL-3
dev-db/libodb::nest
- Ebuilds: 2, Testing: 2.5.0, Snapshot: 9999 Description:
This package contains the common ODB runtime library. Applications that
include code generated by the ODB compiler will need to link this library.
Homepage:https://codesynthesis.com/products/odb/ License: GPL-2
dev-db/litestream::nest
- Ebuilds: 2, Testing: 0.3.13, Snapshot: 9999 Description:
Litestream is a standalone streaming replication tool for SQLite.
It runs as a background process and safely replicates changes
incrementally to another file or S3. Litestream only communicates
with SQLite through the SQLite API so it will not corrupt your database.
Homepage:https://github.com/benbjohnson/litestream License: Apache-2.0
dev-db/lmdb++::gentoo
- Ebuilds: 1, Testing: 1.0.0-r1 Description:
This is a comprehensive C++ wrapper for the LMDB embedded database
library, offering both an error-checked procedural interface and an
object-oriented resource interface with RAII semantics.
Homepage:https://github.com/hoytech/lmdbxx License: public-domain
mongodb (available in: dev-db/mongodb::gentoo, dev-db/mongodb::inode64-overlay)
- Ebuilds: 6, Stable: 8.0.12, Testing: 8.0.12 Description:
MongoDB (from "humongous") is a scalable, high-performance, open source,
schema-free, document-oriented database. Written in C++, MongoDB features:
MongoDB bridges the gap between key-value stores (which are fast and highly
scalable) and traditional RDBMS systems (which provide structured schemas
and powerful queries).
Homepage:https://www.mongodb.com License: Apache-2.0 SSPL-1
dev-db/mssql-cli::nest
- Ebuilds: 2, Testing: 1.0, Snapshot: 9999 Description:
An interactive command line query tool for SQL Server with features such as
auto-completion, syntax highlighting, query history, non-interactive support.
Homepage:https://github.com/dbcli/mssql-cli License: BSD
dev-db/ocp::gentoo
- Ebuilds: 2, Testing: 0.3, Snapshot: 9999 Description: A tool for downloading and uploading files from/to Oracle Database directories using Oracle SQL Net connection only
Homepage:https://github.com/maxsatula/ocp License: GPL-2
dev-db/odb::nest
- Ebuilds: 2, Testing: 2.5.0, Snapshot: 9999 Description:
ODB is an open-source, cross-platform, and cross-database object-relational
mapping (ORM) system for C++. It allows you to persist C++ classes to
a relational database without having to deal with tables, columns, or
SQL and without manually writing any mapping code.
Homepage:https://codesynthesis.com/products/odb/ License: GPL-3
dev-db/odyssey::nest
- Ebuilds: 2, Testing: 1.4.0, Snapshot: 9999 Description:
Advanced multi-threaded PostgreSQL connection pooler and request router,
with pooling control, authentication and logging.
Homepage:https://github.com/yandex/odyssey License: BSD-2
dev-db/percona-toolkit::gentoo
- Ebuilds: 1, Stable: 3.6.0 Description: Percona Toolkit, formerly Maatkit and Aspersa, formerly MySQL Toolkit,
is a collection of command-line utilities that provide missing
functionality for MySQL. Some of the tools implement lacking server
functionality, such as online consistency checks for master/slave
replication; others are client-side utilities such as a query
profiler.
Homepage:https://www.percona.com/software/mysql-tools/percona-toolkit License: || ( GPL-2 Artistic )
dev-db/pg-gvm::gentoo
- Ebuilds: 2, Stable: 22.6.11, Testing: 22.6.14 Description:
Greenbone Library for ical functions. This library contains functionality for ical object manipulation.
This is a PostgreSQL server extension that adds several functions used by gvmd, e.g., iCalendar and host
range evaluation. In previous versions, of GVM these functions were managed directly by gvmd while
pg-gvm uses the extension management built into PostgreSQL.
Homepage:https://www.greenbone.net https://github.com/greenbone/pg-gvm License: GPL-3
dev-db/pg-safeupdate::nest
- Ebuilds: 2, Testing: 1.5, Snapshot: 9999 Description:
This is a simple extension to PostgreSQL that raises an error if
UPDATE and DELETE are executed without specifying conditions.
This extension was initially designed to protect data from accidental
obliteration of data that is writable by PostgREST.
Homepage:https://github.com/eradman/pg-safeupdate License: ISC
dev-db/pg_cron::nest
- Ebuilds: 2, Testing: 1.6.4, Snapshot: 9999 Description:
A simple cron-based job scheduler for PostgreSQL
that runs inside the database as an extension.
It uses the same syntax as regular cron, but it allows you
to schedule PostgreSQL commands directly from the database
Homepage:https://github.com/citusdata/pg_cron License: POSTGRESQL
dev-db/pg_partman::defiance
- Ebuilds: 1, Testing: 4.7.2 Description:
pg_partman is an extension to create and manage both time-based and serial-based table partition sets. Native partitioning in PostgreSQL 10 is supported as of pg_partman v3.0.1. Note that all the features of trigger-based partitioning are not yet supported in native, but performance in both reads and writes is significantly better.
Child table creation is all managed by the extension itself. For non-native, trigger function maintenance is also handled. For non-native partitioning, tables with existing data can have their data partitioned in easily managed smaller batches. For native partitioning, the creation of a new partitioned set is required and data will have to be migrated over separately.
Optional retention policy can automatically drop partitions no longer needed for both native and non-native partitioning.
A background worker (BGW) process is included to automatically run partition maintenance without the need of an external scheduler (cron, etc) in most cases.
All bug reports, feature requests and general questions can be directed to the Issues section on Github. Please feel free to post here no matter how minor you may feel your issue or question may be. - https://github.com/keithf4/pg_partman/issues
If you're looking for a partitioning system that handles any range type beyond just time and serial, the new native partitioning features in PostgreSQL 10 are likely the best method for the foreseeable future. If this is something critical to your environment, start planning your upgrades now!
Homepage:https://github.com/keithf4/pg_partman License: BSD
dev-db/pg_repack::nest
- Ebuilds: 2, Testing: 1.5.2, Snapshot: 9999 Description:
PostgreSQL extension which lets you remove bloat from tables and
indexes, and optionally restore the physical order of clustered indexes.
Unlike CLUSTER and VACUUM FULL it works online, without holding
an exclusive lock on the processed tables during processing.
pg_repack is efficient to boot, with performance comparable to
using CLUSTER directly.
Homepage:https://github.com/reorg/pg_repack License: BSD
dev-db/pg_squeeze::nest
- Ebuilds: 2, Testing: 1.8.0, Snapshot: 9999 Description:
A PostgreSQL extension that enables automatic and transparent fixing
of bloated tables with automatic shrinking, no extensive table locking,
and process works in the background.
Homepage:https://github.com/cybertec-postgresql/pg_squeeze License: POSTGRESQL
pg_stat_kcache (available in: dev-db/pg_stat_kcache::defiance, dev-db/pg_stat_kcache::gentoo)
- Ebuilds: 5, Testing: 2.3.2-r1, Snapshot: 9999 Description:
Gathers statistics about real reads and writes done by the filesystem layer.
It is provided in the form of an extension for PostgreSQL >= 9.4., and
requires pg_stat_statements extension to be installed. PostgreSQL 9.4 or
more is required as previous version of provided pg_stat_statements didn't
expose the queryid field.
Homepage:https://github.com/powa-team/pg_stat_kcache License: CC0-1.0
dev-db/pg_timetable::nest
- Ebuilds: 2, Testing: 5.13.0, Snapshot: 9999 Description:
An advanced job scheduler for PostgreSQL, offering many advantages
over traditional schedulers such as cron and others. It is completely
database driven and provides a couple of advanced concepts.
Homepage:https://github.com/cybertec-postgresql/pg_timetable License: POSTGRESQL
dev-db/pg_top::gentoo
- Ebuilds: 1, Stable: 4.1.3 Description:
pg_top is 'top' for PostgreSQL. It is derived from Unix Top. Similar to
top, pg_top allows you to monitor PostgreSQL processes.
Homepage:https://pg_top.gitlab.io/ License: BSD
dev-db/pg_track_settings::gentoo
- Ebuilds: 1, Testing: 2.1.2-r1 Description:
Helps you keep track of PostgreSQL settings configuration.
It provides a function (pg_track_settings_snapshot()), that must be called regularly.
At each call, it will store the settings that have been changed since last call.
It will also track the postgresql start time if it's different from the last one.
Homepage:https://github.com/rjuju/pg_track_settings License: POSTGRESQL
dev-db/pg_wait_sampling::gentoo
- Ebuilds: 1, Testing: 1.1.9-r1 Description:
PostgreSQL provides information about current wait event of particular process.
However, in order to gather descriptive statistics of server behavior user have
to sample current wait event multiple times. This is an extension for collecting
sampling statistics of wait events.
Homepage:https://github.com/postgrespro/pg_wait_sampling License: POSTGRESQL
dev-db/pgcenter::nest
- Ebuilds: 2, Testing: 0.9.2, Snapshot: 9999 Description:
pgCenter's main goal is to help Postgres DBA manage statistics that
theу have in their databases and see all the necessary data in convenient
format based on builtin stats views and functions.
Homepage:https://github.com/lesovsky/pgcenter License: BSD
dev-db/pgloader::nest
- Ebuilds: 2, Testing: 3.6.10, Snapshot: 9999 Description:
pgloader loads data from various sources into PostgreSQL.
It can transform the data it reads on the fly and submit raw SQL before
and after the loading. It uses the COPY PostgreSQL protocol to stream
the data into the server, and manages errors.
Homepage:https://github.com/dimitri/pgloader License: POSTGRESQL
pgtap (available in: dev-db/pgtap::gentoo, dev-db/pgtap::ledgersmb)
- Ebuilds: 2, Stable: 1.3.3 Description:
pgTAP is a suite of database functions that make it easy to write
TAP-emitting unit tests in psql scripts or xUnit-style test functions.
Homepage:https://pgtap.org/ License: POSTGRESQL
dev-db/pgvector::defiance
- Ebuilds: 3, Testing: 0.8.1 Description:
Open-source vector similarity search for Postgres
Store your vectors with the rest of your data. Supports:
exact and approximate nearest neighbor search
L2 distance, inner product, and cosine distance
any language with a Postgres client
Plus ACID compliance, point-in-time recovery, JOINs, and all of the other great features of Postgres
Homepage:https://github.com/pgvector/pgvector License: Postgres
dev-db/postgresql-hll::defiance
- Ebuilds: 1, Testing: 2.18 Description:
This Postgres module introduces a new data type hll which is a HyperLogLog
data structure. HyperLogLog is a fixed-size, set-like structure used for
distinct value counting with tunable precision. For example, in 1280 bytes hll
can estimate the count of tens of billions of distinct values with only a few
percent error.
In addition to the algorithm proposed in the original paper, this
implementation is augmented to improve its accuracy and memory use without
sacrificing much speed. See below for more details.
This postgresql-hll extension was originally developed by the Science team
from Aggregate Knowledge, now a part of Neustar. Please see the
acknowledgements section below for details about its contributors.
Homepage:https://github.com/citusdata/postgresql-hll License: Apache-2.0
dev-db/postgresql_anonymizer::nest
- Ebuilds: 2, Testing: 3.0.13, Snapshot: 9999 Description:
An extension to mask or replace personally identifiable information (PII)
or commercially sensitive data from a PostgreSQL database.
The project is aiming toward a declarative approach of anonymization.
This means we're trying to extend PostgreSQL Data Definition Language (DDL)
in order to specify the anonymization strategy inside the
table definition itself.
Homepage:https://gitlab.com/dalibo/postgresql_anonymizer License: Apache-2.0 BSD ISC MIT POSTGRESQL Unicode-DFS-2016
dev-db/powa::defiance
- Ebuilds: 1, Testing: 4.2.0 Description:
PoWA is a PostgreSQL Workload Analyzer that gathers performance stats and
provides real-time charts and graphs to help monitor and tune your PostgreSQL
servers.
For more information, please read:
- the PoWA main website : http://dalibo.github.io/powa/
- the Documentation : http://powa.readthedocs.io/
Homepage:http://powa-team.github.io/powa/ License: CC0-1.0
dev-db/powa-archivist::gentoo
- Ebuilds: 1, Testing: 5.1.2-r1 Description:
This project is the core extension of the PoWA project,
a PostgreSQL Workload Analyzer that gathers performance stats
and provides real-time charts and graphs to help monitor
and tune your PostgreSQL servers.
Homepage:https://github.com/powa-team/powa-archivist License: POSTGRESQL
dev-db/pspg::gentoo
- Ebuilds: 5, Stable: 5.8.1, Testing: 5.8.7 Description:
Unix pager (with very rich functionality) designed for work with
tables. Designed for PostgreSQL, but MySQL is supported too. Works
well with pgcli too. Can be used as CSV or TSV viewer too. It
supports searching, selecting rows, columns, or block and export
selected area to clipboard.
Homepage:https://github.com/okbob/pspg License: BSD-2
dev-db/rel-bin::edgets
- Ebuilds: 1, Testing: 3.016 Description:
Rel is a database management system with a user-friendly graphical
interface that faithfully implements Date and Darwen's Tutorial D
query language, based on the relational model of data.
Homepage:https://reldb.org/ License: Apache-2.0
dev-db/sqlbench::nest
- Ebuilds: 2, Testing: 1.1.0, Snapshot: 9999 Description:
sqlbench measures and compares the execution time of one or
more SQL queries.The main use case is benchmarking simple
CPU-bound query variants against each other during local development.
Homepage:https://github.com/felixge/sqlbench License: MIT
dev-db/sqlmap::gentoo
- Ebuilds: 3, Stable: 1.10, Testing: 1.10.6, Snapshot: 9999 Description:
sqlmap is an open source penetration testing tool that automates the
process of detecting and exploiting SQL injection flaws and taking over
of database servers.
Homepage:https://sqlmap.org/ License: BSD BSD-2 GPL-2+ LGPL-2.1+ MIT public-domain
dev-db/tableplus::nest
- Ebuilds: 1, Testing: 1.2.6.264 Description:
Modern, native, and friendly GUI tool for relational databases,
with support of MySQL, PostgreSQL, SQLite and more
Homepage:https://tableplus.com License: TablePlus
dev-db/tarantool::tarantool
- Ebuilds: 54, Snapshot: 9999 Description:
Tarantool is an in-memory database designed to store the most volatile
and highly accessible web content. Tarantool has been extensively used
in production since 2009. Its key features include:
* all data is maintained in RAM
* data persistence is implemented using Write Ahead Log and snapshots
* supports asynchronous replication and hot standby
* uses coroutines and asynchronous I/O to implement high-performance
lock-free access to data
* stored procedures in Lua are supported
This ebuild provides tarantool server.
Homepage:https://tarantool.org License: BSD-2
dev-db/usql::nest
- Ebuilds: 2, Testing: 0.18.1, Snapshot: 9999 Description:
usql is a universal command-line interface for PostgreSQL, MySQL,
Oracle Database, SQLite3, Microsoft SQL Server, and many other
databases including NoSQL and non-relational databases.
Homepage:https://github.com/xo/usql License: MIT
dev-db/valentina-studio-bin::deftera
- Ebuilds: 1, Testing: 17.5.0 Description:
Valentina Studio is a cross-platform GUI database client by Paradigma
Software for DuckDB, ValentinaDB, MongoDB, MySQL, MariaDB, PostgreSQL,
MS SQL Server and SQLite. It bundles a SQL editor with autocompletion,
schema and query designers, diagramming, data transfer and import/
export tools.
This package installs the prebuilt amd64 binary published by upstream
as a .deb release artifact under /opt/VStudio. Qt6, ICU and the
Valentina runtime libraries are bundled inside that prefix; only a
small set of system X11/GTK/glibc libraries is pulled in via RDEPEND.
The Free Edition requires registration with a no-cost serial number
obtained from Paradigma Software on first launch.
Homepage:
https://www.valentina-db.com/en/valentina-studio-overview
https://www.valentina-db.com/en/studio/download
License: Valentina-EULA