- Details
- Hits: 9602
I collected on the following pages various SQL queries and their results on a sample database. They use different SQL functions and will help to learn and understand SQL queries. In addition they help for look up most commonSQL syntax examples. A SQL beginner will get a good overview about the capabilities of SQL. Examples are given for select, count, union, where, having, order, limit, views, NULL, like, subselects and joins.
- Details
- Hits: 11000
To learn to use threading in Python you have to have a concrete problem to solve. Just use Raspberry Pi to connet 6 LEDs and manage them via GIO. On the following pages I describe how to customize my sample program to simulate tarffic lights. You also find a video which shows the program in action and a download link for the sample program.
Read more: Raspberry PI Trafficlight Sample Program written in Python with Threading
- Details
- Hits: 5642
At home there are usually a lot of devices using the internet. Unwanted advertisments Unerwünschte Werbung kann man mit diversen Browserplugins in einem can be suppressed with browser plugins but this requires to install a pugin on every device - multiple tablets, multiple smartphones, multiple laptops and multiple desktops.
Read more: Smart AdBlocker for local network: Block unwanted advertising with pihole
- Details
- Hits: 8719
Today I found in c't 22/2014 22/2014 (German computer journal) a nice article with the same title. Examples show how easy you can combine various commandlien tools in Linux and follow the Unix Philosophy and manipulate without any Programming text files, split and join them. Applications are to process csv files, log files or word frequency analysis and much more. recently I had a similar problem with text files which I solved using most of the tools mentioned in the article. But I was suprosed to read that the tools are much more powerful when you use special parameters. It's a good idea to read the man pages of the tools. On following pages I summarized all tools together with their most powerful parameters.