I’m a big fan of Python, but I’ve found myself using SQL for a lot of things lately. For example, if I want to make a list that lists all the properties of all the tables in my database, I have to write a lot of SQL statements.
SQL is great for data manipulation, but Python is a lot easier to get up-to-speed with and to be used by other people. If you’re already good with SQL, you wont have much difficulty with Python.
I’ve never really used Python, but Ive found that it’s a nice addition to a class that I use. It’s actually pretty nice that I can write a lot of SQL statements for things like this.
I dont really spend that much time with my SQL, but the only thing I can think of that would be really hard to replicate in Python is an index on my user-defined functions. This one is probably the hardest to replicate, but not really difficult at all. You just want to put a list of functions in a table and have some kind of foreign key to link them to other tables.
I’ve taken the liberty of writing a quick Python class called “sql” that will let you do all of the same database things you can do in SQL. I’d also like to point out that sql supports a lot of different database backends (MariaDB, MySQL, etc.) so you could even write your own database.
There are a lot of differences between database backends. MySQL and MariaDB are two of the most popular, but they’re actually really different beasts. MySQL is a very relational database and is more like a relational database you would use when developing a website, while MariaDB is a NoSQL database. MariaDB is easier to use, but is less flexible (you can’t add functions, for example).
So what are the differences between both of these databases? Well, MariaDB is better to use for large websites, but that doesnt mean it is easier to use. MySQL is easier to use by its simplicity and flexibility. If you want to use a more relational database like PostgreSQL, that is more like a database that can handle more complex data structures. But again, you cant add functions.
sql is one of the three “super-fangled” database languages used by the world today. There are many databases that are not really designed to handle that type of data.
SQL is the preferred programming language for most online businesses. In fact, the dominant programming language for most websites is SQL. There may be some exceptions, but I think that MySQL would be at the top of the list for my personal use.
SQL is an excellent language, but it can be very cumbersome to have to do anything. In fact, it could not be easier to have someone writing queries in SQL to do more complicated things. As a user that needs to have a database installed, it’s difficult to have a system where you can change the database from the command line, or to have a system where you can do that.