Use shared folder to develop with a VirtualBox Ubuntu Server guest

Recently the company that I work for change my Lenovo T440 with Ubuntu 16.04 for a MacBook Air with macOS and although I never really liked Mac (Too expensive for the specs provided) I loved the change but there are several differences that, when it comes to web development, I need to take in account, so I just installed a local Ubuntu 16.04 server with VirtualBox to test my work before to put it out.

To avoid having to pull the source code each time I just wanted to share the development folder with the guest machine and in order to do that we need to make the following steps

Install the VirtualBox Guest Additions in the guest

Continue reading

Change auto increment starting number on SQLite

For SQLite there is a table named SQLITE_SEQUENCE with all the auto incremental values of the tables, so you need to update the value.

UPDATE SQLITE_SEQUENCE SET seq = [starting_number] WHERE name = '[table_name]';

Just change [starting_number] for the desired initial auto increment and [table_name] for the name of the table to update