Skip to main content

Daiquiri is a framework for the publication of scientific databases.

Project description


A framework for the publication of scientific databases

pytest Workflow Status Coverage Status License Latest Version

Homepage of the Daiquiri default app


Query interface from Gaia@AIP



Today, the publication of research data plays an important role in astronomy and astrophysics. On the one hand, dedicated surveys like SDSS and RAVE, data intensive instruments like LOFAR, or massive simulations like Millennium and MultiDark are initially planned to release their data for the community. On the other hand, more traditionally oriented research projects strive to publish their data as a key requirement demanded by the funding agencies.

The common approach is to publish this data via dedicated web sites. This includes rather simple HTML forms as well as complex query systems such as SDSS-CAS. Most of these web sites are tailor made for the particular case and are therefore not easily transferable to future projects.

At Leibniz-Institute for Astrophysics Potsdam (AIP), we gained experience with both the maintenance and the development of such applications. It became, however, apparent that already the current plethora of applications constitutes a major challenge for maintenance expenses and scalability. In order to address these issues, we developed the Daiquiri framework, which is particularly designed to allow for different highly customizable web applications based on a common easily maintainable code base.


Daiquiri enables collaboration and institutions to create customized websites, comprising of the following features:

  • An interactive Query interface enabling users to perform SQL/ADQL queries against catalog databases. The queries are analyzed using the queryparser and permissions are checked depending on user accounts and groups.
  • Asynchronous database queries, which can take minutes or even hours.
  • Download of the query results in different formats and visualization of the data.
  • A programmatic interface to the database implementing the IVOA TAP protocol.
  • A cone search API based on the IVOA Simple Cone Search recommendation.
  • An integration into to IVOA registry of registry to make the VO endpoints available in applications like, e.g. topcat.
  • A metadata management backend containing information about the database schemas and tables including DOI and UCD.
  • The download of files connected to the database tables, including access restrictions.
  • An OAI-PMH2 endpoint to make the metadata stored in the system available to harvesters.
  • A cut-out API for multi-dimensional data (e.g. data cubes).
  • A sophisticated user management system with customizable registration and confirmation workflows.
  • A contact form connected to the management backend.


Daiquiri is based on Django and is written in Python. The following requirements are mandatory:

  • Python >=3.9
  • PostgreSQL >=14, MySQL >=5.6
  • RabbitMQ >=3.5 (for asyncronous tasks like the query queue)

For demonstration, development or testing purposes, Daiquiri can be installed on Linux, macOS, or even Windows. If you, however, intent to set up a production enviroment, serving Daiquiri over a Network or the Internet, we strongly suggest that you use a recent Linux distribution, namely:

  • Debian 11
  • Ubuntu 22.04

Scientific Databases Using Daiquiri

Daiquiri is currently used on several sites hosted and maintained by the Leibniz-Institute for Astrophysics Potsdam (AIP):


You can find the detailed instractions for the installation of Daiquiri in the main documentation.


Main documenation:

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

django-daiquiri-0.4.5.tar.gz (530.5 kB view hashes)

Uploaded Source

Built Distribution

django_daiquiri-0.4.5-py3-none-any.whl (733.6 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page