1. FCPeggy
  2. Sherlock Holmes
  3. News / Announcements
  4. Tuesday, 08 May 2018
  5.  Subscribe via email
With Joomla 4.0 coming, I've noted updating to Joomla 3.8 the announcement with regard to upgrading PHP and that SQL is going.
I'm totally confused and afraid to update - what is going to happen to my existing websites built on SQL databases? Will I have to eventually redesign them?
I really don't understand what is going to happen but understand the need to accommodate newer devices and technology.
What's the industry buzz?
Accepted Answer Pending Moderation
0
Votes
Undo
Hello

You have nothing to worry about. Joomla 4 will continue to use SQL. I suspect what you have read was regarding the sample data when you set up a new Joomla installation. There is currently talk of removing this feature which is SQL based and replacing it with the PHP alternative which already exists in Joomla 3.8.

Ciarán
  1. more than a month ago
  2. News / Announcements
  3. # 1
Accepted Answer Pending Moderation
0
Votes
Undo
Hi Ciarán,

https://docs.joomla.org/Potential_backward_compatibility_issues_in_Joomla_4

"This document tracks potential backward compatibility issues for Joomla! 4. Listed are issues which potentially break extensions.
The base of this comparison is Joomla! 3.7. Updated System Requirements

The system requirements have been updated as follows:
PHP 7
MySQL 5.5.3
PostgreSQL 9.2
SQL Server support has been dropped.

PHP MySQL Extension - Joomla no longer supports using PHP's ext/mysql driver (which was removed in PHP 7.0). Joomla will automatically try and use the mysqli extension (available since PHP 5.3) or the mysql PDO Driver (available since PHP 5.3) else it will fail to create a database connection."

My databases are "mysql". If SQL server support has been dropped, is that not the same as "mysql"? Which interpret as being that my database will not connect if I do all of the upgrades required for Joomla 4.0?

This is where my confusion comes from. I would really appreciate some help understanding all this. Your help has always been phenomenal in this forum.

Thank you - -from Canada!
Peggy
  1. more than a month ago
  2. News / Announcements
  3. # 2
Accepted Answer Pending Moderation
0
Votes
Undo
Hi Peggy

What got removed is MS SQL server support from Microsoft in J4. Not MySQL. For MySQL is only an old driver removed because it is deprecated. You can already change to mysqli in your Joomla configuration and all should work as before.

I hope that helps!

Ciarán
  1. more than a month ago
  2. News / Announcements
  3. # 3
Accepted Answer Pending Moderation
0
Votes
Undo
Yes this helps immensely.
So much to learn, so little time...who say's you can't teach an old dog new tricks?
Have a wonderful weekend!
Peggy
  1. more than a month ago
  2. News / Announcements
  3. # 4
Accepted Answer Pending Moderation
0
Votes
Undo
Hi,

Anybody know why SQL Server support is going to be removed?


Tahank you
  1. more than a month ago
  2. News / Announcements
  3. # 5
Accepted Answer Pending Moderation
0
Votes
Undo
Hello

What has gotten removed is Microsoft SQL server support. Joomla 4 will still support MySQLi. This is unlikely to cause you any issues for the vast majority server setups.

Ciaran
  1. more than a month ago
  2. News / Announcements
  3. # 6
Accepted Answer Pending Moderation
0
Votes
Undo
Hello

What has gotten removed is Microsoft SQL server support. Joomla 4 will still support MySQLi. This is unlikely to cause you any issues for the vast majority server setups.

Ciaran


Thank you Ciaran, by "SQL Server" I mean "Microsoft SQL server". Why is going to be removed? last year Microsoft launched SQL Server for Linux.

I am working in a project with Joomla for a company that by its policy, they need IIS and SQL Server as DB. Many companies in my country (and in the world) have similar requirements.
  1. more than a month ago
  2. News / Announcements
  3. # 7
Accepted Answer Pending Moderation
0
Votes
Undo
Hi Manuel

Admittedly I myself have not been following the reasons for this change however, you will get a more detailed idea for the reasoning for this change in the following PR, This appears to be the PR that caused this change.. https://github.com/joomla/joomla-cms/pull/12494

Ciaran
  1. more than a month ago
  2. News / Announcements
  3. # 8
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!

Join Our Newsletter

* indicates required
We respect your privacy and do not tolerate spam and will never sell, rent, lease or give away your information (name, email, number, etc.) to any third party. Nor will we send you unsolicited email.
Joomla51 - Mullaghmore, Co. Sligo, Ireland
Joomla51.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by
Open Source Matters
the trademark holder in the United States and other countries.

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.

Ok