SQLite is a lightweight but powerful database management tool. It occupies a little space on the device – a bit more than 500KB, but offers most of the features that are implemented on other SQL database tools. SQLite is a serverless engine, meaning that the whole database is stored in a single file, and all transactions are reads and write from the file. There are no initial server configurations required – all you need is to create a .db file and start writing queries. This is why SQLite is preferred on small devices like mobile phones, embedded devices, and Raspberry Pi. Previously, we have installed an SQLite into Raspberry Pi, created database and table with only a few lines of script. We performed all the tasks from the command line tool. Eventually, you will want to have full control of the database and see the whole picture. Therefore, you should also consider installing SQLite manager, which brings a graphical user interface to work with SQL databases. To run the SQLite manager, you will need to work from the Raspberry Pi desktop. You may want to connect a monitor, or like me, use a VNC client to access the Raspberry Pi…
Technology is something which has come forward in leaps and bounds over recent years, and it is something which Progressive Automations in particular has taken advantage of. Technological advancements have meant that various computer systems which can be used in the teaching of computer sciences have progressed sharply; if they had not, of course, students would leave their classes unable to handle the more up-to-date versions of computer programs which had come out during the time they had been learning. One such system which has been developed to help in teaching is Raspberry Pi, a system which brings raspberry pi and actuators together to allow students to become proficient in handling linear actuators and the motion systems they are often attached to.
There is a Raspberry Pi 3 out there which is much faster than version 1 and 2. While latest two are faster than first model, I thought it would be great to give some purpose to first Raspberry Pi model B. We share several computers around the house and sometimes need simple file storage solution to make backups, share and store. Rasperry Pi model B is sufficient for simple Network Attached Storage (NAS) solution. Such network automation setup doesn’t need much processing power to manage drive. And there is also an option to have torrent client running 24/7. Other benefits of using Raspberry Pi is low power. Lets go through all steps on how to set up Network Attached Storage on this Raspberry Pi. You can go with several different solutions on setting up NAS. You could go with cloud solution like Owncloud which is similar to Dropbox. This might be convenient in many ways, but I would like to have ability to use drive as portable media when needed. In that case I am going to stick with SAMBA server.
Previously we have configured basic NAS storage on Raspberry Pi. Having such power and doing nothing with storage is a waste. To prove its usefulness Next logical step is to implement torrent client on this machine. The benefit is obvious, you have NAS server which his always available and also torrent client which downloads/seeds files without need power hungry PC. You can find many torrent clients that can be used in Raspberry Pi, but it seems that lots of people prefer Deluge which has plenty of features and requires small memory to run. Deluge is great in its flexibility – the ability to run on desktop, through web interface and through ThinClient. The other popular packet is Transmission, which is also lightweight and has great WebUI. Transmission is able to handle magnet links from web interface. And it seems it is easier to configure. So we are going to stick with Transmission.
When first Raspberry Pi board was introduced it literally changed the understanding of small computers by bringing Linux closer to us. With great support, low board prices and huge community it stayed on top next to Arduino for four years. Of course in to keep that success, updates in hardware and software are mandatory. We know how fast things change computer industry, so time to time Raspberry Pi foundation kept upgrading Pi boards From first, to second and now the newest third generation – Raspberry Pi 3. At first glance you may see that Raspberry Pi 3 board is practically identical to version 2. component layout is same including all peripherals. So all enclosures that worked with Pi2 should fit fine for Pi3 boards. But not the most obvious things that make it stand out.
I was playing with Raspberry Pi Model B for quite a long time. Tweaked few settings, wrote couple helper scripts. After some time second Raspberry Pi 2 arrived. I realized that most settings and scripts that were working on previous should do fine on a new one. I needed to copy few files from one Raspberry to another. For this purpose I decided to use Secure Copy (SCP). This is a file sending command over SSH. Raspbian OS already come with SCP installed so you can use it right away. (it it is missing you can install it by running command sudo apt-get install scp).
Raspberry Pi Model B comes with Ethernet interface built in where you can plug cable and have internet access. In many cases this is enough, but what if you want it to be more portable and still be able to connect to it? One solution would be using Wi-Fi adapter. Since there are couple USB connectors, probably best choice would be using USB based Wi-Fi modules. You can get them in very compact size that aren’t that good at sensitivity and range or choose bigger ones with antenna. No matter what type you select – all of them works pretty same way. For my experiment I am going to use cheap Wireless adapter EDUP model EP-N8508. It supports all necessary features and standards that are needed to have WiFi. Small form factor makes it attractive to use on many devices like Laptop and so on Raspberry Pi. You may need to use powered USB hub to get reliable performance. For now I am using it attached to one of USB ports directly.