Skip to content

nonameable/photoringSQL

Repository files navigation

PhotoRing

Photoring live screenshot

You can see a live version of this app here!

PhotoRing is a tool that allows someone visualize and traverse a big repository of images across all its dimensions. It offers the user a sense of location within the dataset. A user can change dimensions, jump between sections and zoom in and out in order to see more or less photos.

How to run it

Database configuration

Create an empty mySQL database with the name photoring if you want to use the moma dataset or the name nba_photoring if you want the smaller nba dataset. In the scripts contained in the /sqlscriptsdirectory which you need to run to deploy the project, , the database name is photoring. If you named your database differently, you must change the name in the scripts.

Run the following scripts in the order below:

  1. create_tables.sql. After running this script, insert the data into the table the script created (photos) using the method you prefer.

  2. create_metadata_tables.sql: This scripts create the necessary tables for the operation of Photoring.

Replace the configuration file config.js with the connection to the database you just created.

Running the server

You must have Node.js installed on your machine. All the necessary dependencies are already located in the node_modules directory. Open a terminal in the directory of the proyect and run the following commands:

npm start

o

node server.js

The server should have started listening at http://:::8087 (localhost). If you want to change the listening port of the server, go to the config.js configuration file.

How to use it

Video on how to use Photoring

Spanish here.

English here.

Explanation

Images have metadata. For the image above, it looks like this:

  • Title: Marilyn Monroe, actress, New York
  • Identifier: 275101-28281
  • Date: May 1957
  • Authors: Richard Avendon
  • Nationality: (American, 1923–2004)
  • Camera: Canon-360ks
  • Print: Gelatin silver print, printed 1989, 7 15/16 x 7 13/16" (20.2 x 19.8 cm)
  • … And many more characteristics.

Photoring takes the characteristics of every photo/image in a collection and associates them with a dimension. For the image above, Title, Date, Authors, Nationality, etc, all are going to become dimensions. You can traverse the dataset by any of these dimensions.

Photoring screenshot with coloured boxes showing the 3 panels: Sections panel, action panels and visualization panel

When you open Photoring, it selects a dimension from the metadata of the photos randomly and then brings a batch of photos in the order given by that dimension. The batch is centered around a particular photo that appears in the middle of the Photo visualization panel (Box 3). When we say that the user moves through the dataset, we mean the current photo at the center of the visualization changes and therefore, all photos around it.

In the image above you can see 3 different colored boxes:

  1. Box 1: Dimension sections panel: This panel shows the dimensions sections that the current dimensions has. A section is a group of photos that share a dimension value. (e.g Hamlet and Macbeth share the dimension value Shakespeare in the author dimension)

  2. Box 2: Actions panel: It has the following sequence of buttons:

    1. Previous Dimension
    2. Next Dimension
    3. Previous Section
    4. Previous Photo
    5. Next Photo
    6. Next Section
    7. Zoom out
    8. Zoom in
  3. Box 3. Visualization panel: Panel in which photos/images are showed according to the current zoom level. Photos that belong to the same section have the same background color. As mentioned earlier. Photos are displayed in order, from top to bottom, according to the order associated with the current dimension. A user can also change the current

About

Photoring: Image collection visualization and traversal tool

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published