How to Sideload Apps on Google TV

---

• How to Sideload Apps on Google TV
• How to Add Block Quotes in Microsoft Word
• How to Use DB Browser for SQLite on Linux
• How to Control Android Device With Your Eyes Using ‘Look To Speak’
• How to Wipe Your Browsing History Automatically in Safari on Mac
• When Will Google Delete Data in Inactive Accounts?

How to Sideload Apps on Google TV Posted: 16 Dec 2020 08:44 AM PST Google TV devices have access to Android apps and games specifically made for TVs. If you want an app that doesn't appear in the Play Store on the TV, you can "sideload" it. We'll show you how to do it. Apps and games that haven't been specifically enabled for TVs won't show up in the Play Store on your Google TV device. However, that doesn't mean that they won't work on the TV. You'll just have to download them from someplace else. That's where sideloading comes in. Sideloading is the act of installing an app from outside the Play Store. Rather than the Play Store handling the download and installation process, you'll have to do it manually. Sideloading on Google TV is a little different than on Android TV. RELATED: What’s the Difference between Google TV and Android TV? Before we can do any sideloading, you'll need to download an app. APK Mirror is a trusted source for downloading apps, and you won't be pirating. Visit the website, find the app you want, and download the APK file. After downloading the APK, you'll need to move it to Google TV. The easiest way to do this is with a cloud storage service such as Google Drive. Upload the file to the Drive website or mobile app. Lastly, you'll need a way to access your Google Drive on the TV. We recommend an app called "File Commander," which is what we'll be using in this guide. Download the app and sign in with your Google account. The first step in sideloading is enabling the ability to install apps from unknown sources, which is disabled by default as a security feature. First, select your profile icon in the top-right corner of the Google TV home screen. Select "Settings" from the menu. Scroll down and select "System." Next, click "About" from the System settings. Scroll all the way down to "Android TV OS Build" and select it repeatedly until a message appears and says "You Are Now A Developer." You have now enabled the Developer Options, which makes it possible to allow installing apps from unknown sources. Next, go back to the main Settings menu and then select "Apps." Scroll down to the bottom and select "Security & Restrictions." Navigate to "Unknown Sources." Lastly, toggle the switch on for "File Commander." If we hadn't enabled Developer Options first, this option would be grayed out. Now that we've enabled installing apps from unknown sources, we can finally sideload. Open File Commander on your Google TV and navigate to the Google Drive section. Locate the APK file you previously moved and select it. On the pop-up message, click "Install." After it has finished installing, select "Open." It's important to remember that not all apps or games will work correctly on Google TV. Some will be completely broken, while others won't be functional with a remote. However, plenty of unsupported apps work fine. You'll just have to test and see. See details

How to Add Block Quotes in Microsoft Word Posted: 16 Dec 2020 06:30 AM PST Block quotes are used to indent and separate a quoted comment from your own writing. Unlike normal indents, adding block quotes in Microsoft Word requires some additional steps. Because academic writing is written to strict styling standards, the requirements for block quotes in Word differ from style to style. Thankfully, you can tweak the size of any indents by using the ruler bar or by using the "Paragraph" settings in the "Layout" menu or "Paragraph" settings window. RELATED: How to Use Rulers in Microsoft Word Using the Layout Menu The quickest way to add block quotes to a Microsoft Word document is to use the "Paragraph" settings that are visible in the "Layout" tab on the ribbon bar. To add a block quote using this menu, open your Word document and select your quote text. From the ribbon bar, click the "Layout" tab to display the "Paragraph" settings. Block quotes in both the APA and MLA style must start on their own line and have indents to the left that are 0.5cm in size. In the APA style, block quotes must be at least 40 words in length, while in the MLA style, quotes must be at least four lines long. If you use a different academic style, please refer to your style guide to ensure that the indent sizing you use is correct. As both APA and MLA use 0.5cm indents for block quotes, set the "Left Indent" value to "0.5 cm" and hit the enter key to confirm. Alternatively, use the arrow buttons on the right to increase the indent sizing using increments of 0.1cm. This will change the indent size for the text you selected, creating a block quote in the process. You can then add formatting, such as italics, to make the text stand out further. You'll need to repeat these steps for each additional block quote you add to your document. Using the Ruler Bar In earlier editions of Microsoft Word, the easiest way to add a block quote to a Word document was to use the ruler bar, which shows the margins and indents currently in use. However, the ruler bar is no longer visible by default in more recent versions. While it remains a quick and easy method for adding a block quote, you'll need to enable the ruler bar first. To do this, open your Word document and click the "View" tab on the ribbon bar. In the "Show" category, select the checkbox next to the "Ruler" option to enable the ruler. This will display the ruler at the top and to the left of your document. The areas in white are within the print area of the document, matching the margins of the document page. Each point on the ruler is 0.25cm in size. To set a block quote indent, select your quote, then drag the hourglass-style icons on the top of the menu bar until both the top and bottom icons sit at the 0.5cm point. This will create a block quote indent that is 0.5cm in size, suitable for APA and MLA academic style documents. Using the Paragraph Settings Menu You can also use the "Paragraph" settings menu in Microsoft Word to set a block quote indent. To do this, select the text containing the block quote in your document, right-click the text, then choose the "Paragraph" option from the menu. In the "Indents And Spacing" tab of the "Paragraph" menu, you can apply an indent to your selected text. As APA and MLA block quotes require 0.5cm left indents, set the "Left Indentation" value to "0.5 cm" and hit enter. If you're using another academic style, check your style quide for the correct sizing to use here. You can type the value manually or use the arrow keys on the text box to increase the indent in 0.1cm increments. Click "OK" to save your settings and apply the block quote indent to your selected text. Once saved, the 0.5cm indent will be applied to your text, creating a block quote in the process. You'll need to repeat these steps for each additional block quote you add to your document. See details

How to Use DB Browser for SQLite on Linux Posted: 16 Dec 2020 05:27 AM PST Fatmawati Achmad Zaenuri/Shutterstock 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 integral part of the product. This means you don't have to provide an external SQL database server, like MySQL, MariaDB, or Microsoft SQL Server. SQLite also has a command-line tool for manipulating databases, but it's the library that's made it a triumph. Having a capable, self-contained database engine tucked away inside your application removes a lot of problems. It simplifies your application's installation routines and lowers the minimum hardware requirements for your application. Additionally, because SQLite uses a single cross-platform file for its database tables, indexes, and schemas, the entire database can be moved to another computer. You can even move it to a machine running a different operating system by copying one file. In fact, SQLite's database file format is so well regarded, it's one of only a handful recommended by the Library of Congress for long-term data storage. Because SQLite is a developer's library, however, there isn't a front-end for it, meaning it doesn't have a Graphical User Interface. It's the application using the library that provides the user interface. The command-line utility can run in an interactive mode, but it still isn't a GUI. DB Browser for SQLite (DB4S) fits the bill nicely. It's a visual tool developed by another open-source project to allow the creation and manipulation of SQLite databases from within a GUI. DB Browser for SQLite DB Browser for SQLite has been around (in one incarnation or another) since 2003 and has undergone several name changes. Previously, it was called SQLite Browser, but that caused confusion. People thought it had been written by the SQLite team, and thus, were forwarding feature requests and support queries about DB4S to SQLite. So, SQLite Browser was renamed DB Browser for SQLite. You'll still see references to the old name here and there. In fact, the website for the project still uses "sqlitebrowser" as its domain, and the old name is also used during the installation of DB4S. With DB4S you can: Create databases. Import and export database schemas, tables, and data in SQL format. Import and export tables and data in CSV format. Create, edit, and delete tables and indexes. Add, edit, and delete records. Browse and search for database records. Edit and run SQL commands. You can make sure the command does what you think it's going to before you hard-code some SQL into your application. Installing DB Browser for SQLite To install DB4S on Ubuntu, use the following command (again, note the installation still uses the old name): sudo apt-get install sqlitebrowser On Fedora, you type: sudo dnf install sqlitebrowser On Manjaro, we use pacman: sudo pacman -Sy sqlitebrowser Importing a Database from an SQL File When DB4S starts, it doesn't have a database loaded into it. We're going to look at two ways you can import both data and database table definitions, as well as how you can create your own database. Sometimes, you might be given or sent a database dump file in SQL format. This contains the instructions necessary to re-create a database and insert its data into a database. Another common format used to import table definitions and data is the comma-separated values (CSV) format. You can use a data-generation site, such as Database Test Data, to generate dummy data for practicing purposes. You can then export your data as SQL or CSV. Below is an SQL file we created on that site. After it was exported, we edited it and added a line at the top of the file, which is required for SQLite: BEGIN TRANSACTION; We then saved the file. In DB4S, we click File > Import > Database from SQL File. A file selection dialog opens so we can choose our SQL file. In our example, it's called "database_dump.sql," and it's located in the root of our home directory. With the file selected, we click "Open," and a file-save dialog opens. You now have to name your new database and decide where to save it. We called ours "geekbase.sqlite3," and we're saving it in our home directory. Click "Save" when you're ready to proceed. We've identified our source SQL file and named our new database, so the import process can now begin. After it's complete, you'll see the notification dialog below. Because we've added tables and data to the database, we're prompted to save those changes, so we click "Save" to do so. The main DB4S window will now display the structure of our database. There are two tables created, although there was only a definition for one in the SQL file. This is because the "id" field was defined as an auto-incrementing field. It will be added automatically whenever a new record is added to the database. SQLite creates a table to keep track of auto-incrementing fields. Click the "Browse Data" tab to see your newly added records. Of course, the power of a database lies in its ability to search and extract records. With an SQL-enabled database, we use the SQL language to do this. To get started, the "Execute SQL" tab. We've added the following SQL command: SELECT * FROM account_details WHERE last_name LIKE "%ll%" ORDER BY state This will search for people with a double "l" in their last name, and the results will be sorted by state. Click the blue arrow (it looks like a "Play" button) to run your SQL command. The results are displayed in the lower pane. We have four records that contain double "l" in the last name, and they're sorted alphabetically by state, from Arizona to Wisconsin. Importing a Database Table from a CSV File We can also import tables from suitable CSV files. The most convenient way to do so is to have the table field names in the CSV file as the first row of text. Below is a short section of a CSV file. The first line holds the field names: first_name, last_name, created, email, state, and ID. The other lines hold the data values for each record that will be added to the table. This is the same data as before; only the file format has changed. When you import CSV data, you have to create an empty database so you have something to import it to. To do so, click "New Database" in the toolbar. A file-save dialog opens. Name your new database and decide where to save it. We're going to call ours "howtogeek.sqlite3" and save it in our home directory. When the "Edit Table Definition" dialog appears, click "Cancel." Back in the main DB4S window, click File > Import > Table From CSV File. A file selection dialog opens in which you can choose your CSV file. In our example, it's called "users.csv," and it's located in the root of our home directory. Click "Open," and a preview dialog appears to show you how DB4S will interpret the CSV data. The name of the file is used as the name of the table. You can edit this if you want, just make sure you select the checkbox next to "Column Names in First Line." Click "OK" (it's off-screen in the image above). The data is imported and, if all is well, you should see the "Import Completed" dialog; click "OK." Click "Browse Data," and you'll see the imported data. We still have a small tweak to make, though. Click the "Database Structure" tab, select the name of the table, and then click "Modify Table" in the toolbar. In the "Edit Table Definition" dialog, select the "AI" (auto-incrementing) checkbox in the "id" field. The "PK" (Primary Key) checkbox is automatically selected for you; click "OK." This sets the "id" field to be auto-incrementing. We can now add a new record to the database to verify it's working. Click the "Execute SQL" tab, and then type the following SQL in the upper pane (note that we're supplying values for all the fields except "id"): INSERT INTO "users" ("first_name","last_name","created","email","state") VALUES ('Dave','McKay','12/08/2020','dave@llk.com','Idaho'); Click the blue arrow (that looks a Play button) to run your SQL command. Click "Browse Data" and scroll to the bottom. You should see your newly added record with an automatically provided "id" field holding a value that's one higher than the previous highest "id" value. Creating a Database Manually If you don't have an SQL or CVS file to import, you'll have to create your database manually. To get started, click "New Database" and a file-save dialog appears. Type the name of your new database and where you want to save it. We've named ours "geeksrock.sqlite3," and we're saving it in the "Documents" directory. After you name your database and navigate to the location in which you want to save it, click "Save." When asked to confirm your choices, click "Save" once again. The "Edit Table Definition" dialog appears. Name your new table (we've called ours "eagles"), and then click "Add Field." You can now type a name for the field and select the type of information it will contain from the "Type" drop-down menu. We've added a text field to hold the name of the eagle, and a real (floating point) numeric field to hold the wingspan. The checkboxes and other options next to each field allow you to add the following behaviors: NN (Not Null): When this option is set, the field can't be left empty. If you try to add a record without providing a value for this field, it will be rejected. PK (Primary Key): A field (or group of fields) that provides a unique identifier for the records in the table. This might be a simple numeric value, like the auto-incrementing integer fields we covered above. In a table of user accounts, though, it might be a username. There can only be one primary key in a table. AI (Auto-Incrementing): Numeric fields can be automatically filled in, with the next highest unused value. We used this in the "id" field in the example we covered above. U (Unique): This field in each record must hold a unique value, meaning there can't be any duplicates in this field in the table. Default: A default value will be provided if a record is added that has no value in this field. Check: A field can have a check performed on it when a record is added. For example, you might check that the value in a phone number field has at least 10 characters. Collation: Sqlite can use different methods of string comparison. The default is BINARY. Other options are NOCASE, which is case-insensitive, and RTRIM, which ignores trailing white space. In most cases, you can leave this to the default value. Foreign Key: A field or group of fields in a record that must match a key in another table. For example, in a database of workshop tools, you might have a table of individual tools and another table of tool categories. If the tool categories are "hammer," "spanner," and "screwdriver," you can't add a record of type "chisel." Click "OK" after you add the fields you want. After your database is created and your first table is added, you can add some records. In the "Execute SQL" tab, we used the SQL INSERT statement several times to add some records to the table. We can also use the "Browse Data" tab to see our new records. If you prefer to add new records through the user interface, click "New Record" on the toolbar. You can then input the values for the new record without understanding SQL. Other Application's Databases You can also use DB4S to see the SQLite databases that belong to other applications. Examining the structure or contents of other databases can be instructive (or just interesting). It's important that you don't make changes to databases owned by other applications, though, or you might adversely affect the operation of that application. Let's look at one of the SQLite databases Firefox creates and maintains. Click "Open Database" on the toolbar, and a file-open dialog will appear. Firefox keeps its files in a directory called "firefox," which is inside a hidden directory called ".mozilla" that sits in your home directory. On our test machine, we found the Firefox SQLite databases at this location: "home/dave/.mozilla/firefox/vpvuy438.default-release"; yours will be in a similar location. We're going to open the "cookies.sqlite" database, so we highlight the file, and then click "Open." With the database opened, you can examine its table structure, field definitions, and data. Here, we can see a variety of Google and YouTube cookies. Exporting Provides Insights Exporting a database (by clicking File > Export > Database to SQL File) is useful, as well. By looking at the SQL dump of a database, you can see the entire schema of the database rendered in SQL statements. See details

How to Control Android Device With Your Eyes Using ‘Look To Speak’ Posted: 15 Dec 2020 10:12 PM PST People with speech impairments can now use Google's Look to Speak Android app to communicate with others. Google recently launched a new app known as 'Look To Speak.' With this app, users can make their Android smartphone speak phrases out loud just by using their eyes. The app is based on Eye Gaze technology that uses your phone's camera to pick up your pupils' light reflections and translate your eyes' movement into actions. Previously, the technology is only limited to desktop computers, but with Look to Speak, Google somehow managed to bring the technology to smartphones. You can ask your Android device to speak pre-written phrases aloud by moving your eyes with Look to Speak. We have downloaded the app and found that it's working, but it's not 100% accurate. Sometimes it fails to detect eye movement. Also read: How To Control Your PC Using Android Device Steps to Control Android Device With Your Eyes Using 'Look To Speak' To Set up Look To Speak on Android, you need to position your Android device below the eye level. Google recommends the use of a phone mount for a better app experience. This article will share a detailed guide on how to download & install Look to Speak on Android. Let's check out. Step 1. First of all, download & install Look to Speak on Android. Step 2. Once installed, open the app and grant the camera permission. Step 3. Now the app will show you a video guide on how to use the app. Simply go through the tutorial or tap on the 'Skip' button. Step 4. Now you need to position the device, so your head appears in the circle. Step 5. Once done, you will now see the main interface of the app. Simply select the phrase with the eye movement. Once you select the list of phrases by looking left, right, or up. Google will narrow down the words, leaving only one to pick. That's it! You are done. This is how you can control Android with your eyes using the Look to Speak app. This article is all about how to control Android with your eyes using Google's Look to Speak. I hope this article helped you! Please share it with your friends also. If you have any doubts related to this, let us know in the comment box below. See details

How to Wipe Your Browsing History Automatically in Safari on Mac Posted: 15 Dec 2020 01:24 PM PST Your browser records all your web activity. Therefore, for added privacy, it's best to regularly clear your browsing history. Safari on your Mac can take care of this for you and automatically wipe your history every once in a while. Here's how to set it up. Launch Safari on your Mac from the Launchpad or by looking it up on Spotlight. Next, click "Safari" from the left corner of the menu bar and select "Preferences." Alternatively, you can press Cmd+comma on your keyboard to head directly into this menu. Under the "General" tab, locate the "Remove History Items" option. From the dropdown beside it, you can select how often Safari should delete your browsing history. You can have it cleared as frequently as every day or every year. When you enable this setting, Safari automatically wipes logs of the websites you visit, your web searches, and more. If you prefer reviewing your browsing history before clearing it, you can choose "Manually" from the dropdown and periodically erase your web activity from Safari yourself. At the bottom of the "General" section, you'll also find a separate setting called "Remove download list items." With this option, you can configure Safari to automatically remove the list of files you downloaded (but not the files themselves). You can have them wiped after a day, as soon as you quit Safari, or when the download is unsuccessful. Enabling these won't affect your Safari browsing data on other Apple devices such as an iPhone or an iPad. As of yet, the options to automatically wipe your browsing history and the download list are not available on Safari's iOS and iPadOS apps. There's a lot more you can do for a more secure experience on Safari, including browsing in incognito mode by default and optimizing it for maximum privacy. See details

When Will Google Delete Data in Inactive Accounts? Posted: 15 Dec 2020 10:06 AM PST If you have an account with Google cloud services, such as Photos, Drive, or Gmail, your content is subject to being deleted. Inactive accounts will have their data cleaned up after a certain amount of time. Google's storage policies are intended to clean up inactive accounts to make the experience better for everyone else. In other words, Google doesn't want people who aren't using its services to clog things up for people who are. RELATED: Google Will Delete Your Photos and Documents if You Aren’t Active Enough The good news is the cutoff time for inactive accounts is pretty generous. So, there's no reason to worry if you don't sign in every day, or even every month. What Counts Toward My Google Storage? Before we dive into the timelines, you should know what actually counts toward your storage allotment. As always, Google Drive, Google Photos, and Gmail count. Beginning June 1, 2021, however, the following will also count: New photos or videos uploaded to Google Photos (including those of high quality). New Docs, Sheets, Slides, Drawings, Forms, or Jamboard files. However, anything uploaded to these services before June 1, 2021, will not count; only files that are modified after that date will. How Long Until My Data Is Deleted? Starting June 1, 2021, Google will also implement a few new policies for deleting data on inactive accounts. Google might delete data in the following circumstances: If your account is inactive for two years. If you're over your storage limit for two years. The two-year countdown begins on June 1, 2021. So, if you're inactive, 2023 is the earliest anything would be deleted. Google will also send you multiple alerts before anything is removed. How Do I Keep My Google Account Active? You might be wondering what you have to do to keep your account from becoming "inactive." Well, it's simple. Just visit Gmail, Google Drive, or Google Photos while signed in to your Google account on the web or mobile. That's it! You don't actually have to do anything in the services. Generally, this isn't something anyone who even occasionally uses Google services needs to worry about, though. These policies are intended for people who have completely moved on from their Google accounts. See details

You are subscribed to email updates from My Blog. To stop receiving these emails, you may unsubscribe now.	Email delivery powered by Google
Google, 1600 Amphitheatre Parkway, Mountain View, CA 94043, United States