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 ============================================================ 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
