How to Use My Online Database
Welcome to My Online Database! This user-friendly web application allows you to create, manage, and organize your data easily. Follow the steps below to get started.
A Big Thank You! 🥳
We want to extend our heartfelt thanks to a few incredible tools, projects, and iconic inspirations that make everything we do just a little bit more awesome.
-
DB Browser for SQLite: An intuitive, open-source tool that makes managing SQLite databases a breeze. It's a huge help in making data management both easy and powerful.
-
Symphytum: This user-friendly personal database software keeps our data organized and accessible. Big thanks to the developer community behind Symphytum for creating such a versatile tool!
-
Doge (Kabosu): The legendary Shiba Inu who inspired an entire internet culture. Kabosu, your adorable face and personality continue to bring joy and humor to the world every day. Much wow, such awesome! 🐶
Thank you all for being awesome! 🌟
Collections
In My Online Database, your tables are called "Collections." You can create multiple collections to organize your data based on different categories or purposes.
Storing Images
Need to store images and access them easily? We've got you covered! Follow these simple steps:
- Sign up for a free account on Imgur.
- Upload your image to Imgur.
- Right-click on the uploaded image and select "Open image in new tab."
- Copy the URL from the address bar of the new tab.
- Paste the copied URL wherever you want to use the image in My Online Database.
Embedding Videos
In My Online Database, you can embed YouTube, Imgur, and TikTok videos directly into your collections.
YouTube Example
Imgur Example
this link
https://i.imgur.com/MIMRYK7.mp4
embedded in a URL type column in the table
TikTok Example
Form View
Switch to the Form View to see a more detailed view of each record. The Form View allows for easier editing of individual records and provides navigation between records.
Search and Filtering
Use the search bar to find specific records. The search function looks through all fields in the table. You can also filter records by specific columns using the filter inputs in the table headers.
Sorting Data
Sort the data by clicking on the column headers. Clicking once sorts ascending, clicking again sorts descending. The current sort column and direction are indicated by an arrow icon.
Editing Data
Edit data directly in the table view by double-clicking on a cell. Changes are saved automatically when you click out of the cell or press Enter. You can also edit data in the Form View for a more focused editing experience.
Keyboard Navigation
Navigate between cells in the table using the arrow keys. Pressing Enter on a cell enters edit mode, and pressing Esc cancels the edit. Use Tab and Shift+Tab to move between fields in the Form View.
Undo/Redo
Undo your last action using Ctrl+Z
(or Cmd+Z
on Mac). Redo an undone action using Ctrl+Y
(or Cmd+Y
on Mac). The undo/redo functionality applies to most data editing actions.
Managing Columns
My Online Database provides easy column management options. Simply right-click on a column header to access the following options:
- Rename Column: Change the name of the column to better suit your needs.
- Hide Column: Hide the column from view if you don't need it displayed.
Deletion Safety
We understand that accidental deletions can be frustrating. That's why we've implemented safety measures to prevent unintended data loss:
- Delete Table: The "Delete Table" button is disabled by default. You need to toggle the settings to enable it, ensuring you don't accidentally delete an entire table.
- Delete Row: Row deletion is also disabled by default. You need to toggle the settings to make the row delete option appear.
- Delete Column: To delete a column, you first need to toggle the settings for column visibility. This extra step helps prevent accidental column deletions.
Toggling Settings
To access the deletion options and other advanced features, you need to toggle the settings. Here's how:
- Click on the "Settings" button in the top navigation bar.
- In the settings panel, look for the "Enable Deletion" option.
- Toggle the switch to enable or disable deletion options.
- Close the settings panel, and the corresponding deletion buttons will appear based on your settings.
Importing and Exporting Data
My Online Database supports importing and exporting data in various formats, making it easy to migrate your data from other sources or back up your collections.
Importing Data
- Click on the "Import" button in the top navigation bar.
- Choose the format of your data file (CSV, TSV, Google Sheets, etc.).
- Select the file from your computer or provide the URL if importing from a web source.
- Map the columns in your file to the corresponding fields in your collection.
- Click "Import" to start the import process.
Exporting Data
- Open the collection you want to export.
- Click on the "Export" button in the top navigation bar.
- Choose the desired export format (CSV, TSV, JSON, etc.).
- Specify any additional export options, such as field delimiter or including headers.
- Click "Export" to download the exported file.
Customizing Themes
My Online Database allows you to personalize your workspace with different themes. To change your theme:
- Click on the "Settings" button in the top navigation bar.
- In the settings panel, navigate to the "Appearance" section.
- Select your desired theme from the available options.
- The new theme will be applied automatically.
Keyboard Shortcuts
Boost your productivity with these handy keyboard shortcuts:
- Ctrl + F or Cmd + F: Search within a collection.
- Ctrl + N or Cmd + N: Create a new collection.
- Ctrl + S or Cmd + S: Save changes to a record.
- Ctrl + Z or Cmd + Z: Undo the last action.
Remember, My Online Database is designed to be intuitive and user-friendly. If you have any further questions or need assistance, don't hesitate to reach out to our support team.
Happy Database Management!