Data Science & PostgreSQL
CYBERTEC is your professional partner for Data Science and PostgreSQL. From machine learning, artificial intelligence and big data to PostgreSQL support, consulting and training.
CYBERTEC Training and Courses
Products & Tools
Based on multiple years of experience with PostgreSQL we developed a variety of applications and successfully integrated them into existing systems.
We Want to Make You Happy!
We have been using a PostgreSQL HA-Cluster for years and our experience using the software alongside with various services CYBERTEC provides are throughout positive.Jens Werdin, Technical Director, Siemens
With PostgreSQL we safe Terabytes of data for international telecommunication companies. Performance, stability and low costs are perfect!Jan Bastian, CEO, Voipfuture
News From the CYBERTEC Blog
Handling Bonus Programs in SQL
Bonus cards, “Miles & more”, bonus points – don’t we all love and hate them at the same time? Recently we had an interesting use case which made me think about sharing some of the techniques we used in this area to reduce client code by writing some clever SQL. This post will show you […]
Transaction anomalies with SELECT FOR UPDATE
© Laurenz Albe 2022 I was recently confronted with a nice example of how adding FOR UPDATE to a query can introduce transaction anomalies. This article will explain how that happens and how you can cope with the problem. Be ready to learn some PostgreSQL implementation details! The example Setting the stage We have a […]
Debugging deadlocks in PostgreSQL
© Laurenz Albe 2022 Even if you understand what a deadlock is, debugging deadlocks can be tricky. This article shows some techniques on how to figure out the cause of a deadlock. A simple deadlock example Setting the stage We will test our techniques for debugging deadlocks with the following example: The deadlock To provoke […]