Senaite data base

Technical
1

Good afternoon,
I am developing a LIMS for the DNA Lab I work to, based on SQLServer, REACT for the frontend and pyhton for the backend.
As of today I have almost developed the full functionalities in the DB and planning to start with the application. Just discovered SENAITE and it looks great, so I am evaluating to adapt my DB to SAINATE reusing its code and adding the specific modules for DNA processes. As SAINATE is not using an SQL data base this development seems too hard for me, but I have read, and maybe I am wrong, that SENAITE is planning to migrate to PostgreSQL. Am I right?, is there any PostgreSQL version I can work with and extend it with new DNA features I have?
The version I tested is 1.3.3 and now the latest is 2.7 I guess, so even DNA functionalities may have been developed.
Some advise would be very welcome.
Regards,
José

2

Hi Jose,

I have compiled a Senaite 2.6 version with PostGreSQL. It is available on Docker from dockprash/senaite2.6-postgresql-working

1 Like
3

cc: @xispa

I also would like to know this. Senaite is one the best options we have find but using ZODB is a huge turn down for us.

@prashs1973 I’ve found your user on Docker Hub, but couldn’t find any image. You sure it is public? Could you provide us the link for it? A link for a repository would also be very helpful.

edit: My mistake, I just found the image. The repo would still be very useful though.

4

1. Database backend (this is the key point)
SENAITE (and Bika LIMS before it) is built on Zope/Plone and uses ZODB (object database), not a relational database like SQL Server or PostgreSQL.
As of today, there is no official PostgreSQL or SQL-based version of SENAITE.

There have been discussions in the community over the years about SQL / PostgreSQL support, but:

  • No migration has been completed

  • No production-ready PostgreSQL backend exists

  • No roadmap guarantees such a migration