We use MySQL for Linkqlo app as that was part of the good old stack of PHP-MySQL chosen by the IT vendor we worked with. In 2015~2016 as we gradually refactored PHP endpoints into Haskell, we started running into various issues of MySQL since some of its libraries didn't work well with Haskell or our deployment script. Eventually they were all fixed, but it was a big hassle. For our new Mirror Mirror app, since it was built from scratch, we chose a stack that would fully leverage our technical capability - Haskell for endpoints, React-Native for front-end, PostgreSQL for database, and Nix for deployment.
Just as I was getting comfortable with MySQL, I had to pick up PostgreSQL too. Fortunately, they're rather similar.
List all databases
Connect to the database
List all tables in the current database
Describe this table
Show entries from this table with select command based on column
select * from xxxtable where name_id=555; select * from xxxtable where name like 'starlord';
Begin a transaction block
description of table
update xxxtable set description='Starlord is played by Chris Pratt' where name_id=555;
After update, commit the change
After update, rollback the change if needed to abort the current transaction
' by doubling it as in
'', as explained in this Stack Overflow post
Quit from psql
If you enjoy reading articles like this, a small donation in ETH will go a long way to make sure I spend enough time working on this. My Ethereum address: 0xae56b1f221a48f3dbbaaea110b049d5c1aba6efe.
<< How To Make App Store Submission
>> Convert Multiple Images Into One Single PDF