If you find yourself naming tables with the same prefix with an underscore, you may notice that phpMyAdmin automatically groups them together. This is designed to improve readability and enhance organisation and provide “faster navigation”. This maybe true with a large number of databases but if you only have a handful, it can be annoying… Read More »
If you are encountering the issue below: Then the chances are you are trying to connect to a MySQL database via mysqlclient using MySQL’s mysql_native_password plugin. Why this happens? This happens because historically, MySQL users authenticated with the mysql_native_password plugin. However, it is older, weaker, and based on SHA-1 hashing (deprecated). In fact, it was… Read More »
Cassandra version brew list –versions cassandra brew info cassandra cassandra -v Starting Cassandra cassandra -f (foreground) or brew services start cassandra Checking if Cassandra is up brew services list | grep cassandra Connecting to Cassandra jdbc:cassandra://127.0.0.1:9042?localdatacenter=datacenter1 jdbc:cassandra://127.0.0.1:9042/system?localdatacenter=datacenter1 also works. cqlsh DESCRIBE KEYSPACES; DROP KEYSPACE keyspace_name;
Trying to get a UI for Cassandra is not as easy as it should be. DbVisualizer is usually a good option but I had issues and git cloning https://github.com/avalanche123/cassandra-web had hoops to jump through as well. DataStax Studio and TablePlus are popular choices but are commercial options. DBeaver was highly recommended but upon installation, I… Read More »
These 2 videos explain tensors quite well. You might have to watch them a few times and may need a panadol if your head starts to hurt, but it is pretty cool!
The current recommended way to install NodeJS can be seen on Node’s website. Use the script they provide by running: Curl will download the script and “| bash” or pipe bash will run the script immediately, as if you typed it out manually. Then run nvm install 22 (or whatever version you want to install).… Read More »
In Python there are generally 2 options for creating virtual environments. (Virtual environments are a must by the way so I won’t go into the pros and cons. Trust me and just use it). venv Firstly, there is venv which is shipped with Python so you can think of it as a standard library. virtualenv… Read More »
Installing pyenv (brew install pyenv) The first step is to install pyenv which is Python’s version management system. You can read more about where it came from and what it does here but in a nutshell, it is a project that was forked from rbenv and ruby-build, and modified for Python and it let’s you change your… Read More »
This is the command to run to find out the version of your chrome driver
https://echarts.apache.org/examples/en/editor.html?c=geo-beef-cuts