View Video - Worldie

Feeds

Posts

Videos

Pages

Groups

Photos

Activities

People

Business

Videos

SOS: Server Prototype 1 – Basis

06:56 PM | 19 Oct 2019

http://www.untiednations.com/community/plan-sos https://gitlab.com/groupware-systems/sos/sos-experimental/tree/master/prototypes/sos-server-1

Category: Technology

#Shared Open Space #Semantic Open Space #Structured Open Space #Untied Nations #William Charlton #prototyping #prototype #groupware #collaboration

2

5

980

David Sugar

No postgresql support?

No postgresql support?

View all 4 replies
- skreutzer
  
  It's PDO, but I think that unfortunately doesn't entirely abstract away the actual database, does it? MySQL/MariaDB because of local XAMPP. Any special preference for PostgreSQL, why so?
  
  It's PDO, but I think that unfortunately doesn't entirely abstract away the actual database, does it? MySQL/MariaDB because of local XAMPP. Any special preference for PostgreSQL, why so?
- David Sugar
  
  PDO does actually extract the database away. You just install php-pgsql instead php-mysql. nextcloud uses pdo and works great this way with either pgsql or mysql.
  
  PDO does actually extract the database away. You just install php-pgsql instead php-mysql. nextcloud uses pdo and works great this way with either pgsql or mysql.
- skreutzer
  
  If I remember correctly, wasn't it the case that PostgreSQL uses a different convention for naming tables, so "normal" table names without schema and a dot don't work? Or would it be possible to "fully qualify" table names including their database name and a dot in MySQL/MariaDB too, instead of USE? I think this was one difference I had problems with back in the day.
  
  If I remember correctly, wasn't it the case that PostgreSQL uses a different convention for naming tables, so "normal" table names without schema and a dot don't work? Or would it be possible to "fully qualify" table names including their database name and a dot in MySQL/MariaDB too, instead of USE? I think this was one difference I had problems with back in the day.
- David Sugar
  
  Well, postgresql offers features like message queues and key lookups like redis, so it reduces total backend complexity for me. It also ran about 1/2 to 1/3 the size in memory than mariadb on my alpine box.
  
  Well, postgresql offers features like message queues and key lookups like redis, so it reduces total backend complexity for me. It also ran about 1/2 to 1/3 the size in memory than mariadb on my alpine box.

recommended VIDEOS All

Britney Spears/Beyonce/Pink/Enrique Iglesias "We Will Rock You" - Pepsi Gladiator…

1996 Views

7 years ago

SOS: Server Prototype 1 – Basis

980 Views

6 years ago

[EN] 3SF GBA: Prototype 1

743 Views

6 years ago

Skatelife Detroit

Daniel Brummitt

1766 Views

6 years ago

Italy Legend . Fantaghiro

562 Views

3 years ago

Peeragogy Monthly Wrap: Processing Workflow

414 Views

5 years ago

You Saved Me - Sarah Walker and Chuck Bartowski Scene…

TV & Movie Clips

416 Views

5 years ago

Safe and Equal World

About Contact Us Careers Donate Feedback Mission Partners
Projects Research Promote Team Tech4Good Terms of Service Volunteer

©2021 Worldie 🧡 Social Media for Good ✈️

International Social Media Organization