<?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: Abdullah Kaya</title>
    <description>The latest articles on DEV Community by Abdullah Kaya (@kaya-abdullah).</description>
    <link>https://dev.to/kaya-abdullah</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%2F4071930%2Ff88a2a36-4ddb-4bdf-8e5a-e39ff360f99d.jpg</url>
      <title>DEV Community: Abdullah Kaya</title>
      <link>https://dev.to/kaya-abdullah</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/kaya-abdullah"/>
    <language>en</language>
    <item>
      <title>What getting into thirteen database projects' docs actually took</title>
      <dc:creator>Abdullah Kaya</dc:creator>
      <pubDate>Fri, 02 Oct 2026 22:11:51 +0000</pubDate>
      <link>https://dev.to/kaya-abdullah/what-getting-into-thirteen-database-projects-docs-actually-took-1g15</link>
      <guid>https://dev.to/kaya-abdullah/what-getting-into-thirteen-database-projects-docs-actually-took-1g15</guid>
      <description>&lt;p&gt;Thirteen database projects now list LibreDB Studio, our open source browser SQL IDE, in their official documentation: &lt;a href="https://www.postgresql.org/download/products/1#:~:text=LibreDB%20Studio" rel="noopener noreferrer"&gt;PostgreSQL&lt;/a&gt;, &lt;a href="https://redis.io/docs/latest/develop/tools/#libredb-studio" rel="noopener noreferrer"&gt;Redis&lt;/a&gt;, &lt;a href="https://clickhouse.com/docs/integrations/connectors/tools/gui#libredb-studio" rel="noopener noreferrer"&gt;ClickHouse&lt;/a&gt;, &lt;a href="https://mariadb.com/docs/server/clients-and-utilities/graphical-and-enhanced-clients/libredb-studio" rel="noopener noreferrer"&gt;MariaDB&lt;/a&gt;, &lt;a href="https://duckdb.org/docs/preview/guides/sql_editors/libredb_studio" rel="noopener noreferrer"&gt;DuckDB&lt;/a&gt;, &lt;a href="https://trino.io/ecosystem/client-application#libredb-studio" rel="noopener noreferrer"&gt;Trino&lt;/a&gt;, &lt;a href="https://docs.yugabyte.com/stable/integrations/tools/libredb-studio/" rel="noopener noreferrer"&gt;YugabyteDB&lt;/a&gt;, &lt;a href="https://docs.starrocks.io/docs/integrations/IDE_integrations/LibreDB_Studio/" rel="noopener noreferrer"&gt;StarRocks&lt;/a&gt;, &lt;a href="https://www.dragonflydb.io/docs/integrations/libredb-studio" rel="noopener noreferrer"&gt;DragonflyDB&lt;/a&gt;, &lt;a href="https://opensearch.org/community-projects/#:~:text=LibreDB%20Studio" rel="noopener noreferrer"&gt;OpenSearch&lt;/a&gt;, &lt;a href="https://cloudberry.apache.org/docs/ecosystem/sql-clients/libredb-studio/" rel="noopener noreferrer"&gt;Apache Cloudberry&lt;/a&gt;, &lt;a href="https://druid.apache.org/libraries/#:~:text=LibreDB%20Studio" rel="noopener noreferrer"&gt;Apache Druid&lt;/a&gt; and Aiven (&lt;a href="https://aiven.io/docs/products/postgresql/howto/connect-libredb-studio" rel="noopener noreferrer"&gt;PostgreSQL&lt;/a&gt;, &lt;a href="https://aiven.io/docs/products/mysql/howto/connect-libredb-studio" rel="noopener noreferrer"&gt;MySQL&lt;/a&gt;).&lt;/p&gt;

&lt;p&gt;Each listing went through that project's own review. Here is what that looked like.&lt;/p&gt;

&lt;h2&gt;
  
  
  How long it took
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;DuckDB merged the same day the pull request was opened, and so did Aiven's second guide. Aiven's first one took under three days.&lt;/li&gt;
&lt;li&gt;Apache Cloudberry took about five days.&lt;/li&gt;
&lt;li&gt;OpenSearch took about two weeks, YugabyteDB about two and a half.&lt;/li&gt;
&lt;li&gt;Apache Druid merged in a week, then waited almost six weeks for its site to be republished, which came with the Druid 38.0.0 release.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Read the contributing guide before the docs page
&lt;/h2&gt;

&lt;p&gt;Every project wants the entry in a different shape: a YAML row, a full guide page, one line in a list. Copying what the last tool did in the same file worked better than anything we wrote from scratch.&lt;/p&gt;

&lt;h2&gt;
  
  
  Test against the engine first
&lt;/h2&gt;

&lt;p&gt;A docs page is a claim that the tool works with that engine. Before opening a pull request we ran the product against a live instance of it, so the page describes what we measured.&lt;/p&gt;

&lt;h2&gt;
  
  
  Be specific about compatibility
&lt;/h2&gt;

&lt;p&gt;Our compatibility table lists 28 engines that connect through another engine's driver: 18 work fully, 9 partially, 1 only in the query editor. Being specific made reviews shorter.&lt;/p&gt;

&lt;h2&gt;
  
  
  Why bother
&lt;/h2&gt;

&lt;p&gt;A docs page is where someone lands after they already chose a database and want to know what to use with it. That is a better first impression than an ad, and it only happens if the maintainers agree.&lt;/p&gt;




&lt;p&gt;LibreDB Studio is MIT licensed. You deploy it next to your database and open it in the browser.&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;docker run -p 3000:3000 ghcr.io/libredb/libredb-studio:latest
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;

&lt;p&gt;Repo: &lt;a href="https://github.com/libredb/libredb-studio" rel="noopener noreferrer"&gt;https://github.com/libredb/libredb-studio&lt;/a&gt;&lt;/p&gt;

</description>
      <category>opensource</category>
      <category>database</category>
      <category>postgres</category>
      <category>showdev</category>
    </item>
    <item>
      <title>[Boost]</title>
      <dc:creator>Abdullah Kaya</dc:creator>
      <pubDate>Sun, 13 Sep 2026 19:16:52 +0000</pubDate>
      <link>https://dev.to/kaya-abdullah/-ibc</link>
      <guid>https://dev.to/kaya-abdullah/-ibc</guid>
      <description>&lt;div class="ltag__link--embedded"&gt;
  &lt;div class="crayons-story "&gt;
  &lt;a href="https://dev.to/cevheri/designing-a-plugin-architecture-for-third-party-database-providers-in-a-typescript-application-348h" class="crayons-story__hidden-navigation-link"&gt;Designing a plugin architecture for third-party database providers in a TypeScript application&lt;/a&gt;


  &lt;div class="crayons-story__body crayons-story__body-full_post"&gt;
    &lt;div class="crayons-story__top"&gt;
      &lt;div class="crayons-story__meta"&gt;
        &lt;div class="crayons-story__author-pic"&gt;

          &lt;a href="/cevheri" class="crayons-avatar  crayons-avatar--l  "&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.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F124261%2F81397ff8-17dc-4c5a-a8ad-02436af6ebee.png" alt="cevheri profile" class="crayons-avatar__image"&gt;
          &lt;/a&gt;
        &lt;/div&gt;
        &lt;div&gt;
          &lt;div&gt;
            &lt;a href="/cevheri" class="crayons-story__secondary fw-medium m:hidden"&gt;
              Cevheri
            &lt;/a&gt;
            &lt;div class="profile-preview-card relative mb-4 s:mb-0 fw-medium hidden m:inline-block"&gt;
              
                Cevheri
                
                
              
              &lt;div id="story-author-preview-content-4645149" class="profile-preview-card__content crayons-dropdown branded-7 p-4 pt-0"&gt;
                &lt;div class="gap-4 grid"&gt;
                  &lt;div class="-mt-4"&gt;
                    &lt;a href="/cevheri" class="flex"&gt;
                      &lt;span class="crayons-avatar crayons-avatar--xl mr-2 shrink-0"&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.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F124261%2F81397ff8-17dc-4c5a-a8ad-02436af6ebee.png" class="crayons-avatar__image" alt=""&gt;
                      &lt;/span&gt;
                      &lt;span class="crayons-link crayons-subtitle-2 mt-5"&gt;Cevheri&lt;/span&gt;
                    &lt;/a&gt;
                  &lt;/div&gt;
                  &lt;div class="print-hidden"&gt;
                    
                      Follow
                    
                  &lt;/div&gt;
                  &lt;div class="author-preview-metadata-container"&gt;&lt;/div&gt;
                &lt;/div&gt;
              &lt;/div&gt;
            &lt;/div&gt;

          &lt;/div&gt;
          &lt;a href="https://dev.to/cevheri/designing-a-plugin-architecture-for-third-party-database-providers-in-a-typescript-application-348h" class="crayons-story__tertiary fs-xs"&gt;&lt;time&gt;Sep 13&lt;/time&gt;&lt;span class="time-ago-indicator-initial-placeholder"&gt;&lt;/span&gt;&lt;/a&gt;
        &lt;/div&gt;
      &lt;/div&gt;

    &lt;/div&gt;

    &lt;div class="crayons-story__indention"&gt;
      &lt;h2 class="crayons-story__title crayons-story__title-full_post"&gt;
        &lt;a href="https://dev.to/cevheri/designing-a-plugin-architecture-for-third-party-database-providers-in-a-typescript-application-348h" id="article-link-4645149"&gt;
          Designing a plugin architecture for third-party database providers in a TypeScript application
        &lt;/a&gt;
      &lt;/h2&gt;
        &lt;div class="crayons-story__tags"&gt;
            &lt;a class="crayons-tag  crayons-tag--monochrome " href="/t/sql"&gt;&lt;span class="crayons-tag__prefix"&gt;#&lt;/span&gt;sql&lt;/a&gt;
            &lt;a class="crayons-tag  crayons-tag--monochrome " href="/t/nosql"&gt;&lt;span class="crayons-tag__prefix"&gt;#&lt;/span&gt;nosql&lt;/a&gt;
            &lt;a class="crayons-tag  crayons-tag--monochrome " href="/t/typescript"&gt;&lt;span class="crayons-tag__prefix"&gt;#&lt;/span&gt;typescript&lt;/a&gt;
            &lt;a class="crayons-tag  crayons-tag--monochrome " href="/t/javascript"&gt;&lt;span class="crayons-tag__prefix"&gt;#&lt;/span&gt;javascript&lt;/a&gt;
        &lt;/div&gt;
      &lt;div class="crayons-story__bottom"&gt;
        &lt;div class="crayons-story__details"&gt;
          &lt;a href="https://dev.to/cevheri/designing-a-plugin-architecture-for-third-party-database-providers-in-a-typescript-application-348h" class="crayons-btn crayons-btn--s crayons-btn--ghost crayons-btn--icon-left"&gt;
            &lt;div class="multiple_reactions_aggregate"&gt;
              &lt;span class="multiple_reactions_icons_container"&gt;
                  &lt;span class="crayons_icon_container"&gt;
                    &lt;img src="https://assets.dev.to/assets/exploding-head-daceb38d627e6ae9b730f36a1e390fca556a4289d5a41abb2c35068ad3e2c4b5.svg" width="18" height="18"&gt;
                  &lt;/span&gt;
              &lt;/span&gt;
              &lt;span class="aggregate_reactions_counter"&gt;1&lt;span class="hidden s:inline"&gt;&amp;nbsp;reaction&lt;/span&gt;&lt;/span&gt;
            &lt;/div&gt;
          &lt;/a&gt;
            &lt;a href="https://dev.to/cevheri/designing-a-plugin-architecture-for-third-party-database-providers-in-a-typescript-application-348h#comments" class="crayons-btn crayons-btn--s crayons-btn--ghost crayons-btn--icon-left flex items-center"&gt;
              

              1&lt;span class="hidden s:inline"&gt;&amp;nbsp;comment&lt;/span&gt;
            &lt;/a&gt;
        &lt;/div&gt;
        &lt;div class="crayons-story__save"&gt;
          &lt;small class="crayons-story__tertiary fs-xs mr-2"&gt;
            2 min read
          &lt;/small&gt;
        &lt;/div&gt;
      &lt;/div&gt;
    &lt;/div&gt;
  &lt;/div&gt;
&lt;/div&gt;

&lt;/div&gt;


</description>
    </item>
    <item>
      <title>I got tired of opening ports just to query my own database</title>
      <dc:creator>Abdullah Kaya</dc:creator>
      <pubDate>Tue, 11 Aug 2026 11:19:24 +0000</pubDate>
      <link>https://dev.to/kaya-abdullah/i-got-tired-of-opening-ports-just-to-query-my-own-database-4oea</link>
      <guid>https://dev.to/kaya-abdullah/i-got-tired-of-opening-ports-just-to-query-my-own-database-4oea</guid>
      <description>&lt;p&gt;Every time I spun up a managed Postgres, the workflow was identical: database ready in 40 seconds, then open a port, dig an SSH tunnel, or install a desktop app on whichever machine I happened to be at.&lt;/p&gt;

&lt;p&gt;So I built something that deploys next to the data, not onto your laptop.&lt;/p&gt;

&lt;p&gt;&lt;a href="//github.com/libredb/libredb-studio"&gt;github.com/libredb/libredb-studio&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;What it does&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;A self-hosted SQL IDE in a container. You reach it from any browser. Nothing faces outward.&lt;/p&gt;

&lt;p&gt;&lt;code&gt;docker run -d -p 3000:3000 ghcr.io/libredb/libredb-studio:latest&lt;/code&gt;&lt;/p&gt;

&lt;p&gt;Ten plus engines behind one interface: PostgreSQL, MySQL, Oracle, SQL Server, SQLite, MongoDB, Redis, Couchbase, ClickHouse, Druid... Same ER diagrams, same schema diff, same Monaco editor across all of them.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;The things that actually matter day-to-day:&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Schema diff with auto-generated migration SQL&lt;/li&gt;
&lt;li&gt;Interactive ER diagrams (auto-layout, PNG/SVG export)&lt;/li&gt;
&lt;li&gt;NL2SQL with any LLM — Gemini, OpenAI, or local Ollama&lt;/li&gt;
&lt;li&gt;ORM code generator (TypeScript, Prisma, Go, Python, Java)&lt;/li&gt;
&lt;li&gt;OIDC SSO — in the MIT build, not behind a paywall&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;strong&gt;53 seconds demo:&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;  &lt;iframe src="https://www.youtube.com/embed/wJPWPe1mJes"&gt;
  &lt;/iframe&gt;
&lt;/p&gt;

&lt;p&gt;8 months in. Happy to answer questions about any design decision; drop them below.&lt;/p&gt;

</description>
      <category>showdev</category>
      <category>opensource</category>
      <category>database</category>
      <category>webdev</category>
    </item>
  </channel>
</rss>
