Skip to content

Operational Databases

Join our forum to discuss your ideas with Aiven community or check out our public roadmap.

Operational Databases

Categories

JUMP TO ANOTHER FORUM

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

141 results found

  1. As a developer, I would like to simplify the process of building search and Retrieval Augmented Generation (RAG) AI applications with PostgreSQL so that embedding and generation AI models are closer to the database, enabling me to create embeddings, retrieve LLM chat completions, generate responses, and reason over data directly within SQL queries.

    3 votes
    How important is this to you?
  2. As a developer looking for an open-source alternative to MongoDB,
    I want to use FerretDB to translate MongoDB wire protocol queries to SQL,
    so that I can stop using proprietary MongoDB instances.

    42 votes
    How important is this to you?
  3. As developer,
    I want to use the ip4r extension as the built-in IP address types in Postgres work okay for many applications, but are lacking when it comes to applications that heavily work with IPs, like ours. ip4r adds several IP types with expanded functionalities that enable us to perform far more efficient "IP in range" type lookups, as well as tracking IP ranges that don't fall neatly in CIDR boundaries, plus general performance improvements. Very useful for our malicious IP threat feed service, abuseipdb.com, as you can imagine.

    2 votes
    How important is this to you?
  4. pgsqueeze is tries to replace pgrepack extension and it would be great if Aiven did support it.
    https://github.com/cybertec-postgresql/pg_squeeze

    1 vote
    How important is this to you?
  5. Currently, MySQL slow query logs are stored in the mysql.slow_log table. Adding an option to redirect those logs into service logs would allow log integrations, like OpenSearch, to pick those up and give customers greater value and flexibility.

    It would implicitly solve the following:
    https://ideas.aiven.io/forums/951280-operational-databases/suggestions/46266829-allow-mysql-slow-query-log-on-read-only-replicas

    4 votes
    How important is this to you?
  6. As a database administrator, I want the option to be able to set the lowercasetablenames MySQL parameter in the event of migration requiring the lowercasetablenames is different than 0

    3 votes
    How important is this to you?
  7. As a developer,
    I want to be able to perform efficient vector similarity and embeddings techniques directly in PostgreSQL, so that I can enable efficient handling of high-dimensional vector data within the PostgreSQL database for tasks like similarity search and machine learning.

    Pgvectorscale is an open-source PostgreSQL extension that builds on pgvector, enabling greater performance and scalability.

    https://www.timescale.com/blog/pgvector-is-now-as-fast-as-pinecone-at-75-less-cost/
    https://github.com/timescale/pgvectorscale

    2 votes
    How important is this to you?
  8. As developer
    I want to fork databases as quickly as possible
    so that I can start developing new features immediately and run fast automated tests as a part of my CI/CD.
    In addition, this is especially important for larger database instances which can take a lot time to do a full copy of the entire dataset.

    Also known as copy on write or database branching.

    3 votes
    How important is this to you?
  9. With Valkey, it is generally possible to add a new password for a user without immediately invaliding the old one.

    This makes it much easier to manage password rotation without incurring downtime.

    Aiven for Caching blocks access to the ACL commands, and the UI, API, CLI only allow for resetting the current password.

    The admin interfaces for Caching should allow to Add Password and Remove Password

    2 votes
    How important is this to you?
  10. As a database administrator or developer,
    I would like to utilize the pg_profile extension in PostgreSQL,
    so that I would be able to identify the most resource intensive activities in my databases.

    8 votes
    How important is this to you?
  11. As a database administrator or developer, I would like to integrate PostgreSQL with Oracle databases using the oracle_fdw extension so that I can seamlessly access data in Oracle databases from within PostgreSQL using standard SQL queries. This feature simplifies data integration and allows for efficient cross-database operations without the need for complex data migration processes.

    3 votes
    How important is this to you?
  12. As a developer, I want to be able to use Aiven's Dragonfly together with BullMQ which is a popular message queue library for NodeJS. They are not compatible today as BullMQ requires additional configuration flags to be set up for Dragonfly. BullMQ does work with Redis (and apparently Valkey) but Dragonfly compatibility isn't working out-of-the-box. Aiven could add these configuration flags to the Console UI to allow better compability with tools developed for the Redis ecosystem.

    This is also well documented on the Dragonfly website: https://www.dragonflydb.io/docs/integrations/bullmq

    1 vote
    Pending Review  ·  0 comments  ·  Other  ·  Admin →
    How important is this to you?
  13. As an devops engineers
    I want to store extensive amount of data on Valkey but only need part of them to be on memory
    so that I can still utilize the low-latency nature of Valkey but also be able to retain as much data as I can without pay the cost for unnecessary memory.
    In addition, i also want to be able to move data around different tiers

    12 votes
    How important is this to you?
  14. As a database administrator or developer,
    I would like to utilize the pgwaitsampling extension in PostgreSQL,
    so that I would be able to gather sampling-based statistics on wait events for troubleshooting dependencies for queries that take longer than expected.

    8 votes
    How important is this to you?
  15. As a DBA I want to activate "so_reuseport" option so that PGBouncer can use multiple CPUs.
    In the context of a very high concurrent database using PGBouncer, the single process can reach 100% CPU usage. Having multiple PGBouncer processes in the same instance would distribute the load between several processes.

    1 vote
    How important is this to you?
  16. As a devops engineer/admin,
    I want to run both read/write request to the Valkey clusters that locates closest geographically region
    So that I can reduce the latency and improve the experience of my end-user

    20 votes
    How important is this to you?
  17. As a Systems Administrator
    I want to see PGBouncer Metrics (CPU/RAM/Network Usage) on the Aiven Console Metrics page
    so that I can quickly and easily see resource utilization across both PostgreSQL and PGBouncer.

    1 vote
    How important is this to you?
  18. As a database administrator or developer, I would like to have audit logging capability in the system so that I can track and monitor user activities, maintain data security, and ensure compliance with regulatory requirements.

    2 votes
    How important is this to you?
  19. The ability to globally enforce the maxexecutiontime system variable would be great to have

    https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_max_execution_time

    As it would help with limiting the long running queries happening that are left unchecked.

    1 vote
    How important is this to you?
  20. As a devops
    I want to have the service startup time in the GET service endpoint
    so that I can know I a service has been UP or STOPPED since more than 7 days for example. For now I have to fetch the activity logs of the project, then look up for the service, then look for the right event (if the status of the service is UP then I'm looking for the "servicepoweron" event else the "servicepoweroff") but sometimes the service is UP for more than 1 year so I can't find the startup date of the…

    5 votes
    How important is this to you?
  • Don't see your idea?