[FRIAM] Subject: Re: Friam Digest, Vol 180, Issue 3

[Prof David West]

One of the best books on data management and databases that few have read: Data and Reality by William Kent. first published in mid-1980s, Third edition published in 2012.

davewest


On Thu, Jun 14, 2018, at 10:17 AM, uǝlƃ ☣ wrote:
> Not to pile on to MySQL or anything.  But I just landed on this:
> 
> https://medium.com/@adamhooper/in-mysql-never-use-utf8-use-utf8mb4-11761243e434
> > My [Hooper's] take-away lessons
> > 
> >  1) Database systems have subtle bugs and oddities, and you can avoid a lot of bugs by avoiding database systems.
> >  2) If you need a database, don’t use MySQL or MariaDB. Use PostgreSQL.
> >  3) If you need to use MySQL or MariaDB, never use “utf8”. Always use “utf8mb4” when you want UTF-8. Convert your database now to avoid headaches later.
> 
> 
> 
> On 06/06/2018 11:10 AM, Marcus Daniels wrote:
> > Robert writes:
> > 
> > “Remember that Oracle acquired MySQL.  It is now a free product (likely with no meaningful updates, not sure) but with an option to upgrade to supported Oracle extensions at a premium.”
> > 
> > MySQL is distributed under the General Public License, so all it takes is someone to fork it and distribute their own version, like MariaDB.
> > Such a group can take whatever work Oracle does on the core and put it in their fork.
> > Finding a motivation and money to do that is the problem.  I haven’t used either for years because I came to the conclusion that Postgres was better.
> > And if you want small and fast, there’s Sqlite3.
> 
> 
> -- 
> ☣ uǝlƃ
> 
> ============================================================
> FRIAM Applied Complexity Group listserv
> Meets Fridays 9a-11:30 at cafe at St. John's College
> to unsubscribe http://redfish.com/mailman/listinfo/friam_redfish.com
> FRIAM-COMIC http://friam-comic.blogspot.com/ by Dr. Strangelove