GoGreen PC TuneUp™
Learn More

Insta-Install™
this is how we code sign our software and ssl encrypt our websites from our affiliate partner SSL.com

myBlog

myBlog Home

Back to Blog MTNCOMP


SQL

SQL Databases and dictionaries

Published: Saturday, April 4, 2020 written by Andy Flagg
View Count: 99
Keywords: SQL, Dictionaries, Databases



In the past few months, the switch from Microsoft SQL Server to mySQL has been very interesting.
 
The latest dictionaries we could find were difficult at best to utilize unless with mySQL.
 
So buckle up folks. I have used Microsoft SQL since 1993 ever since SQL 6.5 and all the way up to SQL 2019.
 
SQL is SQL, yet the nuances between the mySQL workbench and the Microsoft SQL Server Management Studio (SSMS) are very different. Even attached and creating databases on different hard drives is easier with Microsoft than on Linux but doable, I hope. Why not. Relational Database Management Systems have been around for a long time and we will continue to use them for the foreseeable future. Until then... Happy SQL on Linux.
 
REF: mySQL
 
Reference of my first downloaded database for Linux for mySQL. Interesting little database, and I needed that for an AI like platform Zork like work creator workbench and novel approach to word game development. Don't worry, the production version will be interesting to say the least.
 
 
https://sourceforge.net/projects/mysqlenglishdictionary/ 
 
Quotes from link above:
"
Features
Full MySQL - compatible English Dictionary
Public DomainA dictionary with 176023 entries. Text was extracted from the files at http://www.mso.anu.edu.au/~ralph/OPTED/ and then parsed and stored in a 16MB MySQL database. The database has three fields : a. word b. wordtype and c. definition. You can use this standalone or as a jquery/ajax/PHP addon for your programs.

Acknowledgment of the original content:
a. OPTED
b. Project Gutenburg
c. and the 1913 edition of Webster's Unabridged Dictionary

Features
Full MySQL - compatible English Dictionary
Public Domain
"

more to come...

if you found this article helpful, consider contributing $10, 20 an Andrew Jackson or so..to the author. more authors coming soon
FYI we use paypal or patreon, patreon has 3x the transaction fees, so we don't, not yet.

© 2020 myBlog™ v1.1 All rights reserved. We count views as reads, so let's not over think it.