DB Browser for SQLite lets you view and edit SQLite databases on Linux. You can design, create, and edit these database files, and peek inside the inner workings of other applications. Here’s how to use this SQLite GUI. The SQLite Database Project The SQLite database library and tools are a phenomenally successful open-source Structured Query Language (SQL) database project. So successful, in fact, it can justifiably call itself the most widely deployed database engine in the world. Since its initial release in 2000, SQLite has seen an absolutely staggering uptake. It’s inside every iPhone and Android phone, and Windows 10 or Mac computer. It’s also in every internet browser, including Chrome, Firefox, and Safari, as well as countless other applications. The incredible reach of the SQLite database is due to its architecture. It’s a fast, lightweight library that’s incorporated (or linked , in developer-speak) in other applications. The database engine becomes an … [Read more...] about How to Use DB Browser for SQLite on Linux
If you’ve ever tried to shoot good-looking portraits with your camera and a basic kit lens , you might have been disappointed that the results didn’t match the images you see on social media or in magazines. Part of this is down to the lenses most often used to shoot professional portraits. Let’s look at what makes them special, and whether you need one to get great portraits. What Is a Portrait Lens? Portrait lenses (or rather, lenses-that-are-often-used-for-portraits-but-can-be-used-for-lots-of-other-stuff-too) have two key features: They have a normal or short telephoto focal length. They have a wide maximum aperture . This means that most portrait lenses designed for full-frame cameras have a focal length of between about 50mm and 105mm, with a maximum aperture of somewhere between f/1.2 and f/2.8, or so. ( The equivalent focal range for crop-sensor cameras is between around 35mm and 70mm , so there’s a lot of overlap.). Some typical portrait lenses … [Read more...] about Do You Need a Special Lens to Take Portrait Photos?
After over three decades of Microsoft Windows success, there have been some clear failures along the way. With that in mind, we’ve picked the six worst versions of Windows. All of these made us want to stick to older, better versions of Windows, or use alternatives like Macs or Linux instead. The Ranking Criteria Most of us know a bad version of Windows when we see it. Maybe we’ve experienced personal pain in wrestling with its bugs, or lost time reinstalling it over and over again, or heard stories about how often it’s crashed. In developing this list, we considered the following metrics: How much people hated each version (appearances on other worst-of lists), how poorly it sold, how slowly it was adopted, how bad its reviews were, the length of its lifespan on the market, and our own personal experiences with the software. For fun, we also googled “Windows [x] Sucks,” and tallied up the results. Honestly, there’s no hard science to this, so you might not agree with … [Read more...] about The 6 Worst Versions of Windows, Ranked