[ More Info ]

[/software/database/collectorz] permanent link

[More Info]

[/software/database/sqlite/db_browser] permanent link

[/software/database/collectorz] permanent link

1. Within the Book Collector program, click on Clz Cloud on the menu bar at the top of the program window.
2. Select Synchronize.
3. Click on View my collection in CLZ Cloud if you wish to view the books stored in the copy of the database in the CLZ Cloud in a webpage in your default browser before deleting everything in that version, then click on the Clear CLZ Cloud button at the bottom of the program window to remove all book entries from the version of the database stored in the cloud.
4. You should then see zero cloud changes to be downloaded.

   

   If you wish to then synchronize your local copy of the database to a copy stored in the cloud, you can click on Sync Changes. When you do so you should see "sending items to cloud." Be prepared to wait a few minutes for the synchronization operation to complete if you have a large number of books in your Book Collector database. You will see the number of "Adds/Edits" decrease to zero as books are uploaded. When the process is complete you will see the message "Finished syncing changes. Would you like to view your collection in CLZ Cloud?"

[/software/database/collectorz] permanent link

<lockinfo><writable><client pcname="YYYYYYYY" name="5c22840efc7a3db854c44b0b780f8abc" key="xxxxxxxxxxxx" username="zzzzzzzz"/></writable></lockinfo>

In cases where Book Collector was not closed normally, you can either choose "yes" at the prompt or delete the .bkclck file before opening Book Collector as its presence is what causes the message to appear.

[/software/database/collectorz] permanent link

1. Download the image of the author. If you wish, you can place the image in the location where book cover images are stored, i.e. the images directory beneath the Book Collector directory where you store the book database.
2. If you are editing an entry for a book by the author, you can right-click on the icon of three horizontal bars to the left of the author's name while editing the book entry and select "Edit this author entry." Or from the main Book Collector window, you can select "Edit" then "Manage Pick Lists" to select the author picklist where you can select the relevant author—you can double-click on the author entry then to edit it.
3. In the Edit Author window, click on the Images tab.
4. For the "Template Image" field, browse to where you downloaded the image of the author. Once you have selected the image, click on OK. Leave the "Image (will be scaled to 16x16)" field blank. You can then close the entry where you are editing the author's information. When viewing the entry for a book by the author from the book list in the home screen for Book Collector, you should then see a small thumbnail picture of the author.

If you don't have an image, but want to add a picture to the author's entry, check to see if there is a Wikipedia entry for the author or if the author has a website.

You can use similar steps to add an image for a publisher's entry in the database.

[ More Info ]

[/software/database/collectorz] permanent link

I have an SQLite database that I use to track approval of tasks. Every Monday, I need to generate a count of the number of tasks approved from the prior Tuesday through the Monday on which I'm creating the report. The approval dates are stored in the database as an integer and I enter them in the form 2018-05-14. I use the following SQL command in a Python script to determine the number I've approved in the last week:

sql = 'SELECT COUNT(*) FROM Tasks WHERE Approved >= date(CURRENT_DATE,"-6 day")'

But I noticed that the count didn't always include the tasks I approved on the prior Tuesday. E.g., when I ran the script tonight, May 14, the number reported was 5, yet I expected the result to be 7.

[ More Info ]

[/software/database/sqlite] permanent link

I have an SQLite database stored on my MacBook Pro laptop that I use to track work requests. The database file is named CRQ.db, since it tracks work done under a Change Request (CRQ). Within that database are several tables two of which are "Equipment" and "Device". For every CRQ that I need to deal with, I store records with the CRQ number in a "CRQ" column and an identifier for each piece of equipment affected by work done under that CRQ in a "Device" column. information on equipment that is affected by the CRQ in the Equipment table. I have another table named "Device" that holds details for each device, including the manufacturer and model number as well as the physical location of the device. The information in the "Description" column in the "Device" table matches the "Device" name in the "Equipment" table. The two tables have the following structure:

Equipment.Device = Device.Description

[ More Info ]

[/software/database/sql] permanent link

[/software/database/sql] permanent link

You can backup a table in a MySQL or MariaDB database by using the mysqldump backup tool included with both database management systems. To backup a specific table you can use the command mysqldump database_name table_name where database_name is the name of the database that contains the table and table_name is the name of the particular table you wish to backup. E.g.:

mysqldump -u ptolemy -p Planets Mars > Mars.sql

In the above case, if I have a database named Planets with a table within it named Mars, I could backup just that one table from the database with the command above. The -u option to the command allows you to specify a MySQL/MariaDB username that has access to the database and the -p option will prompt you for the password associated with that username. The Mars.sql file will then contain all of the Structured Query Language (SQL) commands needed to recreate the table structure and the data in the table. E.g., it will contain insert SQL commands that will insert entries in the table.

[ More Info ]

[/software/database/mysql] permanent link