Very true.
That being said, the original maintainers of MySQL (who now regret selling their database) have forked the code base and are now working on a drop-in replacement called MariaDB. From their webpage:
> MariaDB is the compatible successor to MySQL, the world’s most popular Open Source database. MariaDB has greatly improved scalability and performance, engines for NoSQL and volume transaction processing, and clustering capability. The MariaDB client libraries are available under the liberal LGPL license, enabling a new generation of commercial applications.
Edit: Just realized my wording makes it look like MariaDB is a new project. It's been around for 2+ years and it's quite production ready. By 'working on', I mean actively developing and adding new features.
Image Transcription:
[This image is a screenshot of a webbrowser]
Title of the browser tab: "Database error"
URL of the browser tab: "https://mariadb.org/blog/"
Website content: "Error establishing a database connection"
^^I'm a human volunteer content transcriber for Reddit! If  you'd like more information on what we do and why we do it, click here!
Allright the are some problems with the SQL Syntax if you use MySQL most people seem to have no problems if you use MariaDB ( https://mariadb.org/ ) .
If you use MySql after installing open Up MySQL Workbench and double click local instance. then Write CREATE DATABASE Darkflame and run it by pressing on the lighnting symbol.
​
Delete the text and write USE Darkflame.
​
After That copy and paste the SQL Code from the Repository but delete OR Replace from all lines. Also you need to delete " DEFAULT ''" from the Table creation called ugc filename line. Then run it
Mine is basically the same but I use MariaDB since Oracle owns MySQL and they suck ass.
MariaDB is maintained by the original MySQL developers who hate it being sold off to Oracle so they forked the code.
Do a reddit search for SQL and check out the subreddits that come up.
Supposedly MariaDB is the new darling of open source databases. A lot of web hosts have MySQL available as well.
I haven't developed for either of them personally.
> what i dont understand is how can a companny acquire open-source that is openly contributed ? i mean if i make a module in mysql ( when it was open-source) wasn't that source my rights to be ?
MySQL in particular is GPLed, but is also available from Oracle with a proprietary commercial license. Oracle can do this because they require all contributors to sign the Oracle Contributor Agreement. With the OCA, every contribution is jointly owned by the contributor and Oracle, which gives Oracle the right to relicense the code.
The OCA contains wording that contributions will always also be licensed under an FSF or OSI-approved open-source license.
I don't know how the licensing was before Oracle, but I do know that the project was always maintained by a company (starting with the inventors MySQL AB, then Sun, then Oracle) and probably always had legal provisions for dual-licensing.
Another example is Nginx, which is commercialized by the founders' company Nginx, Inc. Because the open-source Nginx code base has a BSD-like license, everyone can commercialize it. Nginx, Inc., besides contributing to open-source, develops additional proprietary functionality and combines it with the open-source basis into Nginx Plus.
Going back to MySQL, it's IMO a perversion of the GPL's somewhat "anti-capitalist" spirit, because it practically prevents anyone from commercializing the code except for Oracle, who can commercialize however they want because of the OCA.
Well, MariaDB is doing the same thing with the MCA.
I'm still having luck with the new version of the online repo generator:
https://mariadb.org/download/?t=repo-config
The only issue for me is that the Jaleco.com East Coast mirror is having an error, however the main mirror at osuosl.org seems to be working just fine. Once I changed the mirror address in all of my apt/sources.list.d/ files for MariaDB, updating resumed and there were no more Release file problems.
Do you think major repos and cloud providers will fully accept Rocky as "the new" CentOS? For example, if you look at MariaDB's repo configurator, they still list CentOS 8 instead of any other proper alternative.
https://mariadb.org/download/?tab=repo-config
And as others have said, THANK YOU!!!!
Image Transcription: Screenshot
[Screenshot is of a Google Chrome browser window. The address is https://mariadb.org/mariadb-innodb-foreign-key-constraint-errors/]
Database Error
Error establishing a database connection
^^I'm a human volunteer content transcriber for Reddit! If you'd like more information on what we do and why we do it, click here!
It really depends on the context of what you are doing and what the application is. From what I can take from your vague thread, I think MariaDB would probably be a better option for you.
> However, the only way I can conceptualize of this is having a bunch of HTML files - one for every day, and then just adding an HTML file every day. This just doesn't seem... right. It feels very cumbersome. Is there a more efficient way to deal with this sort of thing? Should I be using some sort of database?
Yes, you should use a database.
Start with Django's How-To guide on Models and Databases.
To hit the ground running, download and install MariaDb, create a single table with a few columns (a primary key and some random text columns), insert some dummy data into the tables. Then try to use Django to query the data and output the results on screen.
The learning curve might feel like a brick wall followed by a mountain, but start with the simplest possible model and query, then work your way to more complex data models until have a good feel for the tools and framework.
They both are open source but controlled and managed differently as open source projects. Oracle is notoriously anti-open source and some people don't like supporting Oracle by using their products. See for your self MariaDB
Also MariaDB has a more aggressive development cycle when it comes to features and or implementing suggestions on improvement. Oracle for the most part (from what i have heard) is not that responsive to the non-paying community.
There is no reason at all to use MySQL versus MariaDB for anything other than vendor specific requirements usually dictated by companies in bed with Oracle.
> I'm looking to set up either MySQL running from my desktop
If the database is important to the company it should really, really be running on a server. You don't want to wind up in a situation where the whole business goes down because your desktop needs a new motherboard.
> and using Access
No.
> and using Access
The memories. NOOOOOO.
> and using Access
AHHHHHHHHHHHHHHH.
In all seriousness, I really recommend against using Access for anything. It has caused me nothing but pain at my current job. Maybe the newer versions aren't as bad, but I am not optimistic.
If your needs aren't terribly complex (simple CRUD type operations), you are best off going with what you know - build something in PHP to let people work with your database. Personally I prefer web based tools because it doesn't require that people install anything - everyone already has a browser ready to go. Check online, there should be tons of frameworks for getting something like this off the ground fairly quickly (I do mostly java, so couldn't tell you what is out there).
> Just noting, I'm not too knowledgeable regarding servers or MySQL specifically, any suggested MySQL versions would be appreciated.
I recommend using MySQL 5.6 or 5.7, as they solve some outstanding issues that were a bit of a pain. Alternatively you could use MariaDb or Percona's variant of MySQL. Both add features, fixes, and tools that are extremely useful.
I would not do mysql, oracle is carefully fucking it over. At work (Data Centre, thousands of servers on ESX hosts) we are moving all our open source databases to Postgresql (with a couple of exceptions outlined below).
If you want to go down the MySQL route then I would recommend MariaDB written by the guy who wrote MySQL it is a fully compatible drop-in replacement for MySQL which we've used in a couple of apps where MySQL drivers were the only option.
"sell-out" is not the correct term. OpenOffice was developed and maintained by Sun Microsystems (they also developed mysql, java,solaris...). In 2010 it was bought by Oracle. IIRC original developers of OO forked it and moved to LibreOffice . Many of the mysql developers forked mysql and moved to mariadb.
That might be caused by the fresh refill of (innodb-)buffer from disk and by the setting innodb_io_capacity. In my case latter setting was too high for a HDD-RAID.
Check out https://mariadb.org/how-to-tune-mariadb-write-performance/ for experiments
Is Node.js a requirement?
I would do a local install of MariaDB. This runs separately from Node.
Then you can use the 'mysql' package from NPM to talk to the DB server from Node.
If you want something you can demo from anywhere, I would spin up a 'droplet' from DigitalOcean. I think I pay $5/month or so. From there you can use the external IP, or spend another $10 or whatever for domain registration and set that up.
It's not really clear what you're asking, "cloud programming" isn't really a thing. If you want to get into programming cloud-based web apps then you need to use the compute services of cloud providers like AWS, Azure, GCP, and learn their respective platforms.
Hosting your own web server and database are perfectly feasible for development, but it's not cloud. Private cloud solutions are possible, but I'm not sure it's worth going through all the effort of hosting your own cloud platform (with hypervisors, container engines, software defined networking engine etc) just to learn how to develop a web app that you eventually intend to host on a cloud platform.
So if you want to practice web development, that's easy enough to do with a web server (Apache, nginx, Node) and database (MariaDB, PostgreSQL, MongoDB) running locally on your dev machine. Ultimately whether it's hosted on a traditional server or a cloud platform doesn't make a lot of difference to the development or design of the app itself; it's the same code, you're really only changing your deployment process, DB connection strings etc.
If you want to learn a cloud platform, ignore the complexity of web development and start with a static "hello world" HTML page, the point is to learn the cloud platform itself; signing up for an account, learning their web interface/APIs, working out what virtual resources you need and how to create them, then how to use them to get a basic website running, and what kind of costs you'll be paying.
If your goal is to learn both then that's fine, but you're just making it harder on yourself trying to do both simultaneously.
I had a strange issue myself with MariaDB and Nextcloud. It turned out the solution was to downgrade MariaDB to 10.5. Add this repository, then run sudo apt update
and sudo apt upgrade
to automatically downgrade the packages.
Report back whether that work or not.
Hi. Thanks for choosing MariaDB. Sorry to hear you where having trouble, and there's a point at which 9 year old Stack Overflow articles written for Ubuntu-12.04 have limited value.
When you say you deleted the database, can I assume you did rm -rf /var/lib/mysql
while MySQL server was stopped? Did you remove the MySQL server package (sudo apt remove mysql-server
) after this?
By you reference to Digital Ocean I assume you:
sudo apt install mariadb-server
To get your installation. Depending on your Ubuntu Server version you will get a different MariaDB Version. Hopefully that provides the version supported by your domain provider. A later version is possible with MariaDB sourced packages that are available for supported Ubuntu versions. But for the moment lest focus on getting a MariaDB running before you consider a new version.
The "cannot connect to MYSQL server" error is that the service isn't started. Assuming systemctl start mariadb.service
doesn't rectify the problem, showing the exact systemctl status mariadb.service
and journalctl -n 30 -u mariadb.service
will provide the necessary information to help you further. Also tell us which Ubuntu and MariaDB version you are using.
True but people don't like the practices of taking open source from the community and forcing others to create a new community. https://mariadb.org/wp-content/uploads/2019/11/MySQL-MariaDB-story.pdf read the story and you can agree or disagree. This is the same logic.
btw, MariaDB 5.5 EoL date is 11 Apr 2020 https://mariadb.org/mariadb-55-rip/ and not suitable for production.
Please check:
SHOW VARIABLES LIKE '%char%'; SHOW CREATE DATABASE dbname; SHOW CREATE TABLE tablename\G
Encoding should be correct in multiple places:
Here you go, the screenshots of the error: https://imgur.com/a/IpPIDaB
And pacman -Qi mariadb
gives this:
Name : mariadb
Version : 10.5.8-1
Description : Fast SQL database server, derived from MySQL
Architecture : x86_64
URL : https://mariadb.org/
Licenses : GPL
Groups : None
Provides : mysql=10.5.8
Depends On : mariadb-clients=10.5.8 systemd-libs libxml2 zstd
Optional Deps : cracklib: for cracklib plugin [installed]
curl: for ha_s3 plugin [installed]
galera: for MariaDB cluster with Galera WSREP [installed]
mysql-python: for myrocks_hotbackup [installed]
perl-dbd-mariadb: for mariadb-hotcopy, mariadb-convert-table-format and mariadb-setpermission
[installed]
Required By : galera
Optional For : None
Conflicts With : mysql
Replaces : None
Installed Size : 234.60 MiB
Packager : Christian Hesse <[email protected]>
Build Date : Wed 11 Nov 2020 02:53:24 PM IST
Install Date : Mon 28 Dec 2020 12:01:55 PM IST
Install Reason : Explicitly installed
Install Script : Yes
Validated By : Signature
There were also a bunch of stable releases on the same day: https://mariadb.org/mariadb-10-4-13-10-3-23-10-2-32-10-1-45-and-5-5-68-now-available/
PostgreSQL (/r/PostgreSQL) is an enterprise-grade relational database, it's free, and it runs on Linux or Windows. The only catch is that it doesn't have a "friendly" front-end -- you need to add one, either by finding one or building one. Similar to Postgres and open-source or available for free are MariaDB/MySQL (derivatives of one another), Firebird, and Microsoft SQL Express (free edition).
You want to avoid products that are combined front-end and back-end databases, like dBASE, MS Access, and Filemaker Pro. They're not flexible enough for the future, they cost more than enterprise-grade databases like PostgreSQL (and others), and they tend not to handle multi-user access over fileshares reliably so they can get corrupted.
Cloud relational databases are available, but SaaS vendors will want to sell you a complete product with a front-end. And I don't think you can use a simple CRM if you're tracking financial transactions and reporting on them and their taxation.
So it is! I'd convinced myself it was a seal because i can't see any ears on it, but this page repeatedly calls it a sea lion.
​
So does anyone know what the MariaDB Sea Lion's name is??
I have not been involved in MySQL community since Oracle acquisition. However, since that happened, a lot of bad press came out claiming that Oracle is actively trying to suppress the open-source nature of MySQL, e.g.
I don't see a lot of recent press on the subject.
I'm using https://mariadb.org. It's free and opensource made by original MySql developer. Been running for over a year on Debian server. No problem so far. MySQL and MariaDb do not support EF on core still. But there is this: https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql
Switch to MariaDB, it's a community-developed fork of MySQL under the GNU GPL. Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation.
A key difference is in the development philosophy - MariaDB development is more open, and we (I work for the MariaDB Foundation, so feel free to do your own research!) welcome patches from the community and work to make this process smooth. You can read about Tencent's experience about not getting patches accepted into MySQL, and then submitting them to MariaDB, here. Here's another article highlighting some of the other differences - a key one is faster security updates, and if you're running a Linux distro, it's more likely to have MariaDB rather than MySQL as default.
Development in 10.3 is focusing on Oracle compatibility (as in Oracle RDBMS, not Oracle MySQL), so at the moment MariaDB is more compatible with Oracle than Oracle MySQL.
I'm not questioning if it is production ready. The problem I see is this:
>And critical + performance bugs are actively fixed.
Yeah but companies dont' care about some guys saying that they are actively fixing bugs. They want to see that the database is actively being supported by professionals working on it full time. You said in another comment "Rethinkdb is PostgreSQL of NOSQL world". It is not. There are guys being paid to work full time on it. It is as community-driven as the Linux kernel. MariaDB? Same history.
Look, I'm not gonna lie. I'm probably being too pessimistic about it and I certainly hope that RethinkDB will get some companies on board to get some full-time developers working on it so you can come here, quote my comment and say "LOL what do you think now bitch?". But until I see that I won't consider RethinkDB for any project that's going to get the company's money on the line.
Hey no problem. Also have you looked into mariadb. It is what we are using and has improvements over regular mysql. Also what dev application process did you read? Also I really liked xp pylons, I really wish we used it on civcraft, that was my inspiration for Expensive Beacons when I was doing it.
Not a lawyer, but I have delt with this issue a lot.
MySQL Community edition is licensed under the GPL which means that you can literally do anything you want with it. Many companies use MySQL community edition and scale it to HUGE proportions and never violate any licensing agreements. I saw a comment regarding releasing source code due to using a GPL product. This is false. If you use MySQL in your product and redistribute the software to your customers, the only thing you need to do is disclose what open source technologies are included with your software solution so your company cannot claim the DB solution as their own (which it clearly is not).
However, as someone who has built a lot of LAMP applications, I would suggest not using MySQL anymore and switching to MariaDB. If you already have code written for MySQL, no worries, MariaDB is a direct fork of MySQL and the original creator (Michael Widenius) is behind it.
tl;dr: No, it doesn't sound right. You can use the free version of MySQL and do whatever you want with it is long as you disclose to your customers you're using it in your software if you're redistributing it.
It looks like they do offer 24/7/365. MariaDB Corporation Ab significantly supports the non-profit MariaDB Foundation, offer enterprise support packages, and are listed on mariadb.org. If I were you, I'd at least have the team evaluate it, especially given how quickly MariaDB is outpacing MySQL. Last I heard, the MySQL C# backend was still compatible with Maria DB.
I'm honestly surprised that anyone calls Oracle support amazing. I know they have some extremely technical people, but it's a bit of a lottery in terms of who you'll get. I have friends supporting customers on Linux and even some Unix flavors and they have nothing but trouble whenever they have to involve Oracle in anything. The last story I heard was the Oracle reps claiming that the version of Red Hat that they were using was at fault for some memory leak in the configuration, and refusing to even look for anything on their end. That was at the six-month mark of the issue being open and liberally peppered with CYA-isms.