1. New
  2. Home
    1. Get Started - Activities
    2. Posting Policies
    3. Community Standards
    4. Terms of Use
    5. Moderator Team
    6. Member Announcements
    7. Site Map
    8. Quizzes
    9. Articles
      1. Featured Articles
    10. All Blog Posts
      1. Elli's Blog / Articles
  3. Wiki
    1. Wiki Home
    2. FAQ
    3. Classical Epicureanism
    4. Physics
    5. Canonics
    6. Ethics
    7. Search Assistance
    8. Not NeoEpicurean
    9. Foundations
    10. Navigation Outlines
    11. Key Pages
  4. Forum
    1. New Activity
    2. New Threads
    3. Welcome
    4. General Discussion
    5. Featured
    6. Activism
    7. Shortcuts
    8. Dashboard
    9. Full Forum List
    10. Level 3+
    11. Most Discussed
  5. Podcast
    1. Lucretius Today Podcast
    2. Episode Guide
    3. Lucretius Today At Youtube
    4. EpicureanFriends Youtube Page
  6. Texts
    1. Overview
    2. Diogenes Laertius
    3. Principal Doctrines
    4. Vatican Sayings
    5. Lucretius
    6. Herodotus
    7. Pythocles
    8. Menoeceus
    9. Fragments - Usener Collection
    10. Torquatus On Ethics
    11. Velleius On Gods
    12. Greek/Latin Help
  7. Gallery
    1. Featured images
    2. Albums
    3. Latest Images
    4. Latest Comments
  8. Calendar
    1. Upcoming Events List
    2. Zoom Meetings
    3. This Month
    4. Sunday Zoom Meetings
    5. First Monday Zoom Meetings
    6. Wednesday Zoom Meeting
    7. Twentieth Zoom Meetings
    8. Zoom Meetings
  9. Other
    1. Featured Content
    2. Blog Posts
    3. Files
    4. Logbook
    5. EF ToDo List
    6. Link-Database
  • Login
  • Register
  • Search
This Thread
  • Everywhere
  • This Thread
  • This Forum
  • Forum
  • Articles
  • Blog Articles
  • Files
  • Gallery
  • Events
  • Pages
  • Wiki
  • Help
  • FAQ
  • More Options

Welcome To EpicureanFriends.com!

"Remember that you are mortal, and you have a limited time to live, and in devoting yourself to discussion of the nature of time and eternity you have seen things that have been, are now, and are to come."

Sign In Now
or
Register a new account
  1. New
  2. Home
    1. Get Started - Activities
    2. Posting Policies
    3. Community Standards
    4. Terms of Use
    5. Moderator Team
    6. Member Announcements
    7. Site Map
    8. Quizzes
    9. Articles
      1. Featured Articles
    10. All Blog Posts
      1. Elli's Blog / Articles
  3. Wiki
    1. Wiki Home
    2. FAQ
    3. Classical Epicureanism
    4. Physics
    5. Canonics
    6. Ethics
    7. Search Assistance
    8. Not NeoEpicurean
    9. Foundations
    10. Navigation Outlines
    11. Key Pages
  4. Forum
    1. New Activity
    2. New Threads
    3. Welcome
    4. General Discussion
    5. Featured
    6. Activism
    7. Shortcuts
    8. Dashboard
    9. Full Forum List
    10. Level 3+
    11. Most Discussed
  5. Podcast
    1. Lucretius Today Podcast
    2. Episode Guide
    3. Lucretius Today At Youtube
    4. EpicureanFriends Youtube Page
  6. Texts
    1. Overview
    2. Diogenes Laertius
    3. Principal Doctrines
    4. Vatican Sayings
    5. Lucretius
    6. Herodotus
    7. Pythocles
    8. Menoeceus
    9. Fragments - Usener Collection
    10. Torquatus On Ethics
    11. Velleius On Gods
    12. Greek/Latin Help
  7. Gallery
    1. Featured images
    2. Albums
    3. Latest Images
    4. Latest Comments
  8. Calendar
    1. Upcoming Events List
    2. Zoom Meetings
    3. This Month
    4. Sunday Zoom Meetings
    5. First Monday Zoom Meetings
    6. Wednesday Zoom Meeting
    7. Twentieth Zoom Meetings
    8. Zoom Meetings
  9. Other
    1. Featured Content
    2. Blog Posts
    3. Files
    4. Logbook
    5. EF ToDo List
    6. Link-Database
  1. New
  2. Home
    1. Get Started - Activities
    2. Posting Policies
    3. Community Standards
    4. Terms of Use
    5. Moderator Team
    6. Member Announcements
    7. Site Map
    8. Quizzes
    9. Articles
      1. Featured Articles
    10. All Blog Posts
      1. Elli's Blog / Articles
  3. Wiki
    1. Wiki Home
    2. FAQ
    3. Classical Epicureanism
    4. Physics
    5. Canonics
    6. Ethics
    7. Search Assistance
    8. Not NeoEpicurean
    9. Foundations
    10. Navigation Outlines
    11. Key Pages
  4. Forum
    1. New Activity
    2. New Threads
    3. Welcome
    4. General Discussion
    5. Featured
    6. Activism
    7. Shortcuts
    8. Dashboard
    9. Full Forum List
    10. Level 3+
    11. Most Discussed
  5. Podcast
    1. Lucretius Today Podcast
    2. Episode Guide
    3. Lucretius Today At Youtube
    4. EpicureanFriends Youtube Page
  6. Texts
    1. Overview
    2. Diogenes Laertius
    3. Principal Doctrines
    4. Vatican Sayings
    5. Lucretius
    6. Herodotus
    7. Pythocles
    8. Menoeceus
    9. Fragments - Usener Collection
    10. Torquatus On Ethics
    11. Velleius On Gods
    12. Greek/Latin Help
  7. Gallery
    1. Featured images
    2. Albums
    3. Latest Images
    4. Latest Comments
  8. Calendar
    1. Upcoming Events List
    2. Zoom Meetings
    3. This Month
    4. Sunday Zoom Meetings
    5. First Monday Zoom Meetings
    6. Wednesday Zoom Meeting
    7. Twentieth Zoom Meetings
    8. Zoom Meetings
  9. Other
    1. Featured Content
    2. Blog Posts
    3. Files
    4. Logbook
    5. EF ToDo List
    6. Link-Database
  1. EpicureanFriends - Home of Classical Epicurean Philosophy
  2. Forum
  3. Meetings, Resources, and Activism
  4. Brochures, Pamphlets, and Handouts
  • Sidebar
  • Sidebar

Topical Guide

  • Daniel Van Orman
  • May 4, 2018 at 8:00 PM
  • Go to last post
Regularly Checking In On A Small Screen Device? Bookmark THIS page!
  • Daniel Van Orman
    01 - Introductory Member
    Points
    217
    Posts
    37
    • May 4, 2018 at 8:00 PM
    • #1

    A topical guide is a study tool which assists in finding quotations and passages marked with a selected topic. This is helpful for:

    - Quickly learning basics about a specific topic

    - Finding where to search for information on a topic

    - Obtaining evidence to support claims concerning a topic

    This topical guide is implemented as a small SQLite3 database containing many quotes and passages from sources explaining Epicureanism: https://www.dropbox.com/s/1l6ggni6bh7s…alGuide.db?dl=0

    If a pop up asks you to sign into Dropbox, close it using the X in the upper-right corner. You do not need a Dropbox account to download and use this topical guide.

    A categorized list of topics may be found here: https://www.dropbox.com/s/nafyhctcbzaky80/Topics.txt?dl=0

    Table of Contents

    How to Use

    How to Set Up

    Database Structure

    How to Use

    Indexed passages are labeled with certain topics, allowing users to search for a selected topic and obtain a list of related passages.

    For example, searching for the topic "Limit Desires" provides 30 indexed passages, from Epicurus, Diogenes of Oenoanda, Cicero, and Seneca.

    Search results from the topic "Limit Desires".

    Changing the topic to "Friendship" provides 22 indexed passages.

    Search results from the topic "Friendship".

    Available topics may be found in this text file ( https://www.dropbox.com/s/nafyhctcbzaky80/Topics.txt?dl=0 ) or within the topical guide in the table "topics".

    How to Set Up

    To be able to use the topical guide, a program for viewing SQLite3 databases is required. Below is a walkthrough for installing such a program and how to view the topical guide using it.

    Installation

    1. Go to http://sqlitebrowser.org/.

    2. Choose and download the correct installer for your machine.

    3. Run the installer.

    Using Topical Guide

    1. Launch DB Browser for SQLite.

    2. Click on "Open Database" at the top-left. Navigate to your Downloads folder and select "topicalGuide.db".

    a. If you do not see "topicalGuide.db", you may need to download it here: https://www.dropbox.com/s/1l6ggni6bh7s…alGuide.db?dl=0

    3. Click on "Browse Data" tab in the top-left bar. You may now see and filter through passages within the topical guide.

    a. Type keywords into the "Filter" textboxes to limit which passages are displayed. For topics, it is recommended to search for only one topic at a time.

    b. Use the "Table" dropdown menu to view sources or available topics instead of passages.

    Database Structure

    quotes

    A table of indexed passages, the main focus of the topical guide.

    school: The branch of philosophy associated with the passage.

    author: The writer or creator of the passage.

    passage: An indexed quotation.

    source: The book or literature where the passage was taken from.

    reference: The specific part or section where passage was taken from.

    topics: Keywords from available topics which the passage is marked with.

    notes: Miscellaneous information concerning the passage.

    sources

    A table of sources where passages within the quotes table may be found.

    school: The branch of philosophy associated with the passage.

    title: The name of the book or literature which is the source.

    author: The writer or creator of the source.

    translator: If translated into English, the name of the translator.

    datePublication: When the source was published or written.

    dateTranslation: If translated into English, when the source was translated.

    links: URLs pointing to the specific source used.

    notes: Miscellaneous information concerning the source.

    numQuotes: The number of passages within the quotes table taken from the source.

    topics

    A table of available topics used to mark passages within the quotes table.

    category: The broad group containing the topic.

    topic: The keyword used to represent the topic.

    definition: The meaning associated with the topic.

    numOccurrences: The number of passages within the quotes table marked with the topic.

    Images

    • Topic Search - Limit Desires.jpg
      • 422.49 kB
      • 1,350 × 833
      • 1

    Edited 6 times, last by Daniel Van Orman: Major update revising the vast majority of the topical guide and post. (November 6, 2020 at 6:40 PM).

  • Online
    Cassius
    05 - Administrator
    Points
    102,499
    Posts
    14,030
    Quizzes
    9
    Quiz rate
    100.0 %
    • May 4, 2018 at 9:12 PM
    • #2

    Wow! I will look further into this asap - thanks for posting! So you are basically creating an SQL database for the Epicurean texts? What translations are you using?

    I am pretty familiar with the nature of SQL databases but I usually see them associated with some kind of "Front End" to make them more usable. Do you have a goal for that?

    Also, if I read your post correctly, you pretty much jumped directly into the technical details without explaining much about the background and goals of your project, and how it replaces other resources that might already be available. Can you sort of back up and give us the global view of what you are doing? Thanks very much!

  • Daniel Van Orman
    01 - Introductory Member
    Points
    217
    Posts
    37
    • May 5, 2018 at 1:24 PM
    • #3

    I am glad you are excited for this project. I hope it will be useful to many.


    I am creating an SQL database for Epicurean and utilitarian passages/quotes from texts (I am a utilitarian, see the "Background" section for details). The passages have citations and are tagged with topics. One may search using a topic and find a number of passages from multiple sources to find quotes or know where to go to learn more about a topic.

  • Daniel Van Orman
    01 - Introductory Member
    Points
    217
    Posts
    37
    • May 5, 2018 at 1:25 PM
    • #4

    I am unfamiliar with creating front ends, but have experience with backends (I am a college student, studying computer science). I do not know to begin creating a front end for an SQL database and I am new to SQL.


    The background and goals of my project are described in the "Background" section, the very last section of the post, which is available at the bottom of this file: https://www.dropbox.com/s/kg66ayy4a9vt…0Guide.txt?dl=0 (I use a separate file since I hit the character limit for posts on the forum).

  • Daniel Van Orman
    01 - Introductory Member
    Points
    217
    Posts
    37
    • May 5, 2018 at 1:26 PM
    • #5

    I could not find any other resources for searching for passages by topic. As far as I can tell, this is unique.

  • Online
    Cassius
    05 - Administrator
    Points
    102,499
    Posts
    14,030
    Quizzes
    9
    Quiz rate
    100.0 %
    • May 5, 2018 at 1:57 PM
    • #6

    Thank you Daniel! I will follow this with interest.

  • Online
    Cassius
    05 - Administrator
    Points
    102,499
    Posts
    14,030
    Quizzes
    9
    Quiz rate
    100.0 %
    • May 8, 2018 at 9:07 AM
    • #7

    Daniel I wonder if you could post some screen shots of the program in use.

    Also, what is the data you are putting into the database? It would probably be helpful to post a list of the source material so that it would be clear what it is possible to find by searching the database.

  • Daniel Van Orman
    01 - Introductory Member
    Points
    217
    Posts
    37
    • May 8, 2018 at 7:08 PM
    • #8

    Having a screenshot and list of sources in the post are excellent ideas! Thank you.

    How to input data into the database is explained in the "Contributing Passages" section. Please see the "Example" subsection to see what data my Java converter will take. For quality control, I plan to manage any data going into the master copy of the database.

  • Daniel Van Orman November 6, 2020 at 6:41 PM

    Changed the title of the thread from “Work-In-Progress: Topical Guide” to “Topical Guide”.
  • Cassius October 22, 2024 at 9:00 AM

    Moved the thread from forum Technology and Epicurean Educational Content to forum Technology, Content Creation, Social Media.

Unread Threads

    1. Title
    2. Replies
    3. Last Reply
    1. Who are capable of figuring the problem out 5

      • Like 1
      • Patrikios
      • June 5, 2025 at 4:25 PM
      • General Discussion
      • Patrikios
      • June 6, 2025 at 6:54 PM
    2. Replies
      5
      Views
      290
      5
    3. Patrikios

      June 6, 2025 at 6:54 PM
    1. What fears does modern science remove, as Epicurean physics did in antiquity? 31

      • Like 5
      • sanantoniogarden
      • June 2, 2025 at 3:35 PM
      • General Discussion
      • sanantoniogarden
      • June 6, 2025 at 2:05 PM
    2. Replies
      31
      Views
      900
      31
    3. Don

      June 6, 2025 at 2:05 PM
    1. Porphyry - Letter to Marcella -"Vain Is the Word of the Philosopher..." 17

      • Like 1
      • Cassius
      • June 12, 2023 at 11:34 AM
      • Usener Collection
      • Cassius
      • June 3, 2025 at 11:17 PM
    2. Replies
      17
      Views
      5.8k
      17
    3. Bryan

      June 3, 2025 at 11:17 PM
    1. Daily life of ancient Epicureans / 21st Century Epicureans 38

      • Like 3
      • Robert
      • May 21, 2025 at 8:23 PM
      • General Discussion
      • Robert
      • May 29, 2025 at 1:44 PM
    2. Replies
      38
      Views
      2.8k
      38
    3. Pacatus

      May 29, 2025 at 1:44 PM
    1. Emily Austin's "LIving For Pleasure" Wins Award. (H/T to Lowri for finding this!)

      • Like 4
      • Cassius
      • May 28, 2025 at 10:57 PM
      • General Discussion
      • Cassius
      • May 28, 2025 at 10:57 PM
    2. Replies
      0
      Views
      250

Latest Posts

  • Tsouna's On Choices and Avoidances

    Robert June 8, 2025 at 1:37 AM
  • Episode 285 - Not Yet Recorded - Cicero Attacks Epicurus' PD04 And Says Virtue And Honor Is the Way To Overcome Bodily Pain

    Cassius June 7, 2025 at 3:12 PM
  • Updated Thoughts on the Question of "Peace and Safety" in the Works of Norman Dewitt

    Joshua June 7, 2025 at 2:02 PM
  • Who are capable of figuring the problem out

    Patrikios June 6, 2025 at 6:54 PM
  • What fears does modern science remove, as Epicurean physics did in antiquity?

    Don June 6, 2025 at 2:05 PM
  • Sunday, June 15 - Topic: The Letter of Cosma Raimondi

    Cassius June 6, 2025 at 1:46 PM
  • Welcome Balin!

    sanantoniogarden June 6, 2025 at 1:08 PM
  • Sunday, June 8, 2025 - Discussion Topic - "Practice" In Relation To Pain, Pleasure, and Happiness

    Cassius June 6, 2025 at 9:26 AM
  • What if Kyriai Doxai was NOT a list?

    Don June 5, 2025 at 7:12 AM
  • EpicureanFriends WIKI 2025 - Upgrades, Revisions, Planning

    Cassius June 4, 2025 at 2:23 PM

Tags

  • study
  • Soundbite

EpicureanFriends - Classical Epicurean Philosophy

  1. Home
    1. About Us
    2. Classical Epicurean Philosophy
  2. Wiki
    1. Getting Started
  3. Frequently Asked Questions
    1. Site Map
  4. Forum
    1. Latest Threads
    2. Featured Threads
    3. Unread Posts
  5. Texts
    1. Core Texts
    2. Biography of Epicurus
    3. Lucretius
  6. Articles
    1. Latest Articles
  7. Gallery
    1. Featured Images
  8. Calendar
    1. This Month At EpicureanFriends
Powered by WoltLab Suite™ 6.0.22
Style: Inspire by cls-design
Stylename
Inspire
Manufacturer
cls-design
Licence
Commercial styles
Help
Supportforum
Visit cls-design