PostgreSQL is referred to as “The world’s most advanced open source database” – but what does PostgreSQL have that other open source relational databases don’t?
2ndQuadrant recently hosted a webinar on this very topic: PostgreSQL is NOT your traditional SQL database, presented by Gülçin Yıldırım Jelínek, Cloud Services Manager at 2ndQuadrant.
The recording of the webinar is now available here.
Questions that Gülçin couldn’t respond to during the live webinar have been answered below.
Q1: What exactly is the role of postgresql for a marketplace like ebay or rakuten?
A1: This question is not very clear. If the question is about whether Postgres can be used in an e-commerce website, the answer is yes.
Q2: I’m in process of switching from MS SQL Server to Postgres and I have an issue:
Simple search in text columns with diacritics chart.
Ex: table Person
Name
——-
Ștefan
ștefan
Stefan
When I search:
SELECT * FROM pers WHERE Name LIKE 'ste%';I want to retrieve all records from above.
In SQL Server there’s a simple way to accomplish this – I use: COLLATE Latin1_General_100_CI_AI when I define column, and that it’s.
Do you have recommendations to accomplish the same task in Postgres?
A2: The unaccenting collations are not supported in PostgreSQL. You can query like this to get the same result:
SELECT * FROM pers WHERE unaccent(Name) ILIKE 'ste%';
For any questions, comments, or feedback, please visit our website or send an email to webinar@2ndquadrant.com.