<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: MInhTriet</title>
    <description>The latest articles on DEV Community by MInhTriet (@lordofdarkness).</description>
    <link>https://dev.to/lordofdarkness</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F417957%2F5d83802a-55a5-466c-a4d3-4b8bc3877905.png</url>
      <title>DEV Community: MInhTriet</title>
      <link>https://dev.to/lordofdarkness</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/lordofdarkness"/>
    <language>en</language>
    <item>
      <title>New extension: Note Taking Manager</title>
      <dc:creator>MInhTriet</dc:creator>
      <pubDate>Fri, 28 Aug 2026 14:11:18 +0000</pubDate>
      <link>https://dev.to/lordofdarkness/new-extension-note-taking-manager-31kj</link>
      <guid>https://dev.to/lordofdarkness/new-extension-note-taking-manager-31kj</guid>
      <description>&lt;p&gt;I have a friend who likes to read books or academic materials. Most of the time, to take notes to later review, he will use Zotero. However, its note taking features in the browser have very limited capabilities.&lt;/p&gt;

&lt;p&gt;So that's why I decided to create and also learn how to create a browser extension.&lt;/p&gt;

&lt;p&gt;You can take a look at my GitHub repository.&lt;/p&gt;


&lt;div class="ltag-github-readme-tag"&gt;
  &lt;div class="readme-overview"&gt;
    &lt;h2&gt;
      &lt;img src="https://assets.dev.to/assets/github-logo-5a155e1f9a670af7944dd5e12375bc76ed542ea80224905ecaf878b9157cdefc.svg" alt="GitHub logo"&gt;
      &lt;a href="https://github.com/TrietMinh799" rel="noopener noreferrer"&gt;
        TrietMinh799
      &lt;/a&gt; / &lt;a href="https://github.com/TrietMinh799/Note-Taking-Manager" rel="noopener noreferrer"&gt;
        Note-Taking-Manager
      &lt;/a&gt;
    &lt;/h2&gt;
    &lt;h3&gt;
      Extension to help you taking notes easier and more manageable
    &lt;/h3&gt;
  &lt;/div&gt;
  &lt;div class="ltag-github-body"&gt;
    
&lt;div id="readme" class="md"&gt;&lt;div class="markdown-heading"&gt;
&lt;h1 class="heading-element"&gt;📚 Academic Notes - Snippet Saver&lt;/h1&gt;
&lt;/div&gt;
&lt;p&gt;&lt;a href="https://developer.chrome.com/docs/extensions/mv3/intro/" rel="nofollow noopener noreferrer"&gt;&lt;img src="https://camo.githubusercontent.com/f355e0a1fe39acd395b386128fd328869469bf9c5c04482b936e48b298c91d44/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f4d616e69666573742d56332d626c75653f7374796c653d666c61742d737175617265" alt="Manifest V3"&gt;&lt;/a&gt;
&lt;a href="https://github.com/TrietMinh799/Note-Taking-Manager#-privacy-security-transparency--store-policies" rel="noopener noreferrer"&gt;&lt;img src="https://camo.githubusercontent.com/a948827ecd622a1891b305eaf82bb8c407b44cc9d3c4a475c9c8d13e14fdac7b/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f507269766163792d3130302532352532304c6f63616c2d2d46697273742d737563636573733f7374796c653d666c61742d737175617265" alt="Local First"&gt;&lt;/a&gt;
&lt;a href=""&gt;&lt;img src="https://camo.githubusercontent.com/c66d103b4d5755c1f81e414d8c979ef5db8815662e54242a61ffdc2eb91a8c3c/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f476f6f676c6525323053796e632d43726f73732d2d4465766963652532302841707044617461292d3432383546343f7374796c653d666c61742d737175617265266c6f676f3d676f6f676c65" alt="Google Sync"&gt;&lt;/a&gt;
&lt;a href="https://github.com/TrietMinh799/Note-Taking-Manager#-5-sqlite-webassembly-wasm-local-database-engine" rel="noopener noreferrer"&gt;&lt;img src="https://camo.githubusercontent.com/79f0719e097de7bc98a793a8641c6bc671f2cc2389a16ef6594027504bed6069/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f44617461626173652d53514c6974652532305741534d2532302873716c2e6a73292d696e666f726d6174696f6e616c3f7374796c653d666c61742d737175617265" alt="SQLite WASM"&gt;&lt;/a&gt;
&lt;a href="https://github.com/TrietMinh799/Note-Taking-Manager#-4-zotero-direct-cloud--desktop-sync" rel="noopener noreferrer"&gt;&lt;img src="https://camo.githubusercontent.com/1985e2e7a31a361029a0fd542af98859cc4ebc93047efed9f33869de2750350b/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f5a6f7465726f2d446972656374253230436c6f756425323053796e63253230284150492532307633292d7265643f7374796c653d666c61742d737175617265" alt="Zotero Sync"&gt;&lt;/a&gt;
&lt;a href="https://github.com/TrietMinh799/Note-Taking-Manager#-5-multi-app-export-ecosystem" rel="noopener noreferrer"&gt;&lt;img src="https://camo.githubusercontent.com/f3d56c96cf0a16e90b918fa81e968b0b7b2731539db0d9d790c9e976f6d20714/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f4578706f7274732d4f6273696469616e2532302537432532304e6f74696f6e2532302537432532304c6f67736571253230253743253230416e6b692532302537432532305a6f7465726f2d707572706c653f7374796c653d666c61742d737175617265" alt="Multi-App Export"&gt;&lt;/a&gt;
&lt;a href="https://github.com/TrietMinh799/Note-Taking-Manager#-installation--setup" rel="noopener noreferrer"&gt;&lt;img src="https://camo.githubusercontent.com/1f0706b3b598d9162dcb5a45f890430c07c64fb909bf747fcbc046f706ac6a93/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f42726f77736572732d4368726f6d652532302537432532304564676525323025374325323046697265666f782532302537432532304d6f62696c652d6f72616e67653f7374796c653d666c61742d737175617265" alt="Cross Browser"&gt;&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Academic Notes &amp;amp; Snippet Saver&lt;/strong&gt; is a high-performance, lightweight, and privacy-first browser extension designed for students, researchers, academics, and knowledge workers. It enables effortless capture of snippets from research papers, academic journals, online PDFs, and YouTube video lectures—automatically extracting bibliographic citations, organizing notes into hierarchical folders, syncing seamlessly across devices via &lt;strong&gt;Google Sign-In &amp;amp; Google Drive AppData&lt;/strong&gt;, and integrating directly with &lt;strong&gt;Zotero&lt;/strong&gt;, &lt;strong&gt;Obsidian&lt;/strong&gt;, &lt;strong&gt;Notion&lt;/strong&gt;, &lt;strong&gt;Logseq&lt;/strong&gt;, &lt;strong&gt;Anki&lt;/strong&gt;, and &lt;strong&gt;SQLite&lt;/strong&gt;.&lt;/p&gt;

&lt;div class="markdown-heading"&gt;
&lt;h2 class="heading-element"&gt;📑 Table of Contents&lt;/h2&gt;
&lt;/div&gt;
&lt;ul&gt;
&lt;li&gt;
&lt;a href="https://github.com/TrietMinh799/Note-Taking-Manager#-key-features" rel="noopener noreferrer"&gt;✨ Key Features&lt;/a&gt;
&lt;ul&gt;
&lt;li&gt;&lt;a href="https://github.com/TrietMinh799/Note-Taking-Manager#-1-effortless-capture--quick-save" rel="noopener noreferrer"&gt;📌 1. Effortless Capture &amp;amp; Quick-Save&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://github.com/TrietMinh799/Note-Taking-Manager#-2-file-explorer--tree-folder-system" rel="noopener noreferrer"&gt;🌲 2. File Explorer &amp;amp; Tree Folder System&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://github.com/TrietMinh799/Note-Taking-Manager#-3-youtube-video-highlighting-synced-transcripts--slide-capture" rel="noopener noreferrer"&gt;🎥 3. YouTube Video Highlighting, Synced Transcripts &amp;amp; Slide Capture&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://github.com/TrietMinh799/Note-Taking-Manager#-4-zotero-direct-cloud--desktop-sync-api-v3" rel="noopener noreferrer"&gt;📚 4. Zotero Direct Cloud &amp;amp; Desktop Sync (API v3)&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://github.com/TrietMinh799/Note-Taking-Manager#-5-multi-app-export-ecosystem" rel="noopener noreferrer"&gt;💎 5. Multi-App Export Ecosystem&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://github.com/TrietMinh799/Note-Taking-Manager#-6-sqlite-webassembly-wasm-local-database-engine" rel="noopener noreferrer"&gt;💾 6. SQLite WebAssembly (WASM) Local Database Engine&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://github.com/TrietMinh799/Note-Taking-Manager#-7-anti-copy-bypass-force-unlock-mode" rel="noopener noreferrer"&gt;🔓 7. Anti-Copy Bypass ("Force Unlock" Mode)&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://github.com/TrietMinh799/Note-Taking-Manager#-8-automated-academic-metadata-extraction" rel="noopener noreferrer"&gt;🏷️ 8. Automated Academic Metadata Extraction&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;
&lt;a href="https://github.com/TrietMinh799/Note-Taking-Manager#-9-native-pdf-integration--reader" rel="noopener noreferrer"&gt;📄 9.&lt;/a&gt;…&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;/ul&gt;&lt;/div&gt;
  &lt;/div&gt;
  &lt;div class="gh-btn-container"&gt;&lt;a class="gh-btn" href="https://github.com/TrietMinh799/Note-Taking-Manager" rel="noopener noreferrer"&gt;View on GitHub&lt;/a&gt;&lt;/div&gt;
&lt;/div&gt;


&lt;p&gt;I already published it to the Firefox store. You can go download it to use :&amp;gt;. (I tested it and it works on most chromium browser based ones, even Edge)&lt;/p&gt;


&lt;div class="crayons-card c-embed text-styles text-styles--secondary"&gt;
    &lt;div class="c-embed__content"&gt;
        &lt;div class="c-embed__cover"&gt;
          &lt;a href="https://addons.mozilla.org/en-US/firefox/addon/academic-notes-snippet-saver/" class="c-link align-middle" rel="noopener noreferrer"&gt;
            &lt;img alt="" src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Faddons.mozilla.org%2Fstatic-frontend%2F02ea754b37fd50cca41d6aa1747a3848.png" height="630" class="m-0" width="1200"&gt;
          &lt;/a&gt;
        &lt;/div&gt;
      &lt;div class="c-embed__body"&gt;
        &lt;h2 class="fs-xl lh-tight"&gt;
          &lt;a href="https://addons.mozilla.org/en-US/firefox/addon/academic-notes-snippet-saver/" rel="noopener noreferrer" class="c-link"&gt;
            Academic Notes - Snippet Saver – Get this Extension for 🦊 Firefox (en-US)
          &lt;/a&gt;
        &lt;/h2&gt;
          &lt;p class="truncate-at-3"&gt;
            Download Academic Notes - Snippet Saver for Firefox. Capture academic snippets &amp;amp;amp; citations. 1-click export to Obsidian, Notion, Logseq, Anki, Zotero, Bear &amp;amp;amp; EndNote with SQLite WASM.
          &lt;/p&gt;
        &lt;div class="color-secondary fs-s flex items-center"&gt;
            &lt;img alt="favicon" class="c-embed__favicon m-0 mr-2 radius-0" src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Faddons.mozilla.org%2Ffavicon.ico%3Fv%3D3" width="32" height="32"&gt;
          addons.mozilla.org
        &lt;/div&gt;
      &lt;/div&gt;
    &lt;/div&gt;
&lt;/div&gt;


</description>
      <category>note</category>
      <category>notetaking</category>
      <category>javascript</category>
      <category>extensions</category>
    </item>
    <item>
      <title>Introduction to SQL: Day 1 - A Beginner's Guide to Databases</title>
      <dc:creator>MInhTriet</dc:creator>
      <pubDate>Mon, 02 Dec 2024 11:28:10 +0000</pubDate>
      <link>https://dev.to/lordofdarkness/introduction-to-sql-day-1-a-beginners-guide-to-databases-5ehm</link>
      <guid>https://dev.to/lordofdarkness/introduction-to-sql-day-1-a-beginners-guide-to-databases-5ehm</guid>
      <description>&lt;p&gt;It is known in the programming world that there are a variety of languages for a diversity of tasks. We, as humans, can’t master every single programming language out there. We can just look at each of them and learn the basics.&lt;/p&gt;

&lt;p&gt;So, over the next 15 days, I will guide you through SQL to build a solid foundation. This will be beneficial for you should you decide to continue further learning after this series.&lt;/p&gt;




&lt;h2&gt;
  
  
  1. History
&lt;/h2&gt;

&lt;p&gt;SQL was developed in 1974, nearly 50 years prior to the writing of this article. SQL, which stands for &lt;strong&gt;Structured Query Language&lt;/strong&gt;, serves as a standard language for managing and manipulating relational databases. &lt;/p&gt;

&lt;p&gt;Over the years, SQL has gained widespread adoption thanks to its robust capabilities in managing large datasets and its adaptability across various applications, including:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Data analysis&lt;/li&gt;
&lt;li&gt;Backend development&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;When you look up SQL tables online, you'll find various examples. In this series, we will create our own identical tables for practical understanding.&lt;/p&gt;




&lt;h2&gt;
  
  
  2. Overview
&lt;/h2&gt;

&lt;h3&gt;
  
  
  What are databases?
&lt;/h3&gt;

&lt;p&gt;Databases store organized information in a structured format. Among these, &lt;strong&gt;Relational Databases (RDBMS)&lt;/strong&gt; are the most widely used type.&lt;/p&gt;

&lt;h3&gt;
  
  
  Key Components of an RDBMS:
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;
&lt;strong&gt;Tables&lt;/strong&gt;: Store data in rows (records) and columns (fields).&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Rows&lt;/strong&gt;: Each row represents a single record.&lt;/li&gt;
&lt;li&gt;
&lt;strong&gt;Columns&lt;/strong&gt;: Define the attributes or properties of the data.&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  Popular SQL-Compatible RDBMS:
&lt;/h3&gt;

&lt;ul&gt;
&lt;li&gt;MySQL&lt;/li&gt;
&lt;li&gt;PostgreSQL&lt;/li&gt;
&lt;li&gt;SQLite&lt;/li&gt;
&lt;li&gt;Microsoft SQL Server&lt;/li&gt;
&lt;li&gt;Oracle Database&lt;/li&gt;
&lt;/ul&gt;

&lt;h3&gt;
  
  
  Variety of Uses:
&lt;/h3&gt;

&lt;ol&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Data Retrieval for Reporting&lt;/strong&gt;&lt;br&gt;&lt;br&gt;
Fetching data to generate reports and dashboards.&lt;br&gt;&lt;br&gt;
&lt;em&gt;Example:&lt;/em&gt; A sales report showing monthly revenue trends.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Data Management for Businesses&lt;/strong&gt;&lt;br&gt;&lt;br&gt;
Managing large datasets, such as customer databases or inventory systems.&lt;br&gt;&lt;br&gt;
&lt;em&gt;Example:&lt;/em&gt; An e-commerce platform tracking product stock levels.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Data Analysis&lt;/strong&gt;&lt;br&gt;&lt;br&gt;
Performing complex queries and analyses.&lt;br&gt;&lt;br&gt;
&lt;em&gt;Example:&lt;/em&gt; Identifying customer purchasing patterns or market trends.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Backend Development&lt;/strong&gt;&lt;br&gt;&lt;br&gt;
Storing and retrieving user data for web applications.&lt;br&gt;&lt;br&gt;
&lt;em&gt;Example:&lt;/em&gt; Managing login credentials or user preferences.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Transaction Processing&lt;/strong&gt;&lt;br&gt;&lt;br&gt;
Handling transaction data and ensuring accuracy and consistency.&lt;br&gt;&lt;br&gt;
&lt;em&gt;Example:&lt;/em&gt; Banking transactions or online payment processing.&lt;/p&gt;&lt;/li&gt;
&lt;/ol&gt;




&lt;h2&gt;
  
  
  3. Syntax
&lt;/h2&gt;

&lt;p&gt;Here is the basic syntax of the language. You can probably look at it and make some guesses.&lt;/p&gt;

&lt;p&gt;At the moment, I’m not gonna focus on it too much as it will be explained in the next lessons. something like this:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight sql"&gt;&lt;code&gt;&lt;span class="k"&gt;SELECT&lt;/span&gt; &lt;span class="o"&gt;*&lt;/span&gt; &lt;span class="k"&gt;FROM&lt;/span&gt; &lt;span class="n"&gt;Customers&lt;/span&gt;&lt;span class="p"&gt;;&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Paste this in the &lt;a href="https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all" rel="noopener noreferrer"&gt;W3Schools&lt;/a&gt; SQL editor, you can see the following results:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fdqdjp5i11g0ha1nfvg0t.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fdqdjp5i11g0ha1nfvg0t.png" alt="Screen of the W3school SQL editor" width="800" height="241"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Wrapping Up Day 1
&lt;/h2&gt;

&lt;p&gt;The amount of content above is for day 1. Specifically, it provided a brief time lapse history of when and who created SQL, an overview of some of its practical uses, and finally, the code. While some will say that this is maybe useless, in my opinion, it provides you with a solid knowledge of what you are going to learn and use. You don’t want to learn something and don’t know what you will use it for, right?&lt;/p&gt;

&lt;p&gt;As we move forward, the next lesson will focus on setting up the database system on your computer and setting up an SQL database for future use. I hope you found this article informative and enjoyable. At this point, there isn’t much for you to know and learn, however, stay tuned for more exploration and learning in the upcoming lessons.&lt;/p&gt;

</description>
      <category>sql</category>
      <category>database</category>
      <category>tutorial</category>
      <category>programming</category>
    </item>
  </channel>
</rss>
