| Verifying that +nathan_nesbitt is my blockchain ID. https://onename.com/nathan_nesbitt |
Originally the idea was to implement a blogging website using Cassandra, but the requirements changed so we changed to MySQL. I didn't want to loose my notes, and I thought it would be useful to share.
To try something new, this was created using the NOSQL database: Apache Cassandra. The following steps will outline how to install the requirements and package for Apache Cassandra. There were a lot of traps, so I hope someone enjoys the walkthrough.
Since Cassandra is NoSQL we cannot assume consistancy accross tables (we may have the same value in n tables).
Therefore, we need to use batch statements which are precreated queries that run accross multiple tables.
An example of a batch statement is:
BEGIN BATCH
INSERT INTO userpage_posts (username, datestamp) VALUES ('user1', '2020-01-01');
| <!DOCTYPE html> | |
| <html lang="en"> | |
| <body> | |
| <script src="External.js"></script> | |
| </body> | |
| </html> |
| <!DOCTYPE html> | |
| <html lang="en"> | |
| <body> | |
| <script> | |
| // Your JS code can go here! // | |
| </script> | |
| </body> | |
| </html> |
| var greeting = "Hello World!"; | |
| console.log(greeting); |
| var greeting = "Hello World!"; | |
| console.log(greeting); | |
| // Reassigns the variable // | |
| greeting = "Goodbye!" | |
| console.log(greeting); |
| // Creates a constant variable // | |
| const myConstant = 10; | |
| // Tries to reassign the variable but will | |
| // throw TypeError: invalid assignment to const `myVariable' | |
| myConstant = 11; | |
| // Prints 10 // | |
| console.log(myConstant); |
| // Assume this creates a connection to a DB // | |
| var myDatabaseConnection = new CreateConnectionToDatabase(); | |
| // Oops we accidentally overwrote the database connection // | |
| myDatabaseConnection = 10; | |
| // This would throw an error saying WTF?! how do I run this? | |
| myDatabaseConnection.query("SELECT * FROM school"); |
| // Create variable for only the outer block // | |
| let i = 22; | |
| // Create and loop over inner block variable // | |
| for(let i = 0; i < 10; i++) { | |
| console.log(i); | |
| } | |
| // Print outer block variable // | |
| console.log(i); |