> For the complete documentation index, see [llms.txt](https://jamess-private-organization-1.gitbook.io/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://jamess-private-organization-1.gitbook.io/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/ji-shu-yan-jiu-lian-jie.md).

# 技術研究連結

James Lin. 林俊彥

主題索引 (Topic Index)

{% content-ref url="/pages/UYfmkW4dlYTv6i0jeQWF" %}
[工具-簡易檢測Web PHP 版本(Python)](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/gong-ju-jian-yi-jian-ce-web-php-ban-ben-python.md)
{% endcontent-ref %}

{% content-ref url="/pages/rJwtFSaKLEMhv7OMTB4Q" %}
[資安-詐騙繳費信件分析與識別](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/zi-an-zha-pian-jiao-fei-xin-jian-fen-xi-yu-shi-bie.md)
{% endcontent-ref %}

{% content-ref url="/pages/cELcG9TRREH5rIgznFw1" %}
[開發 AWS 服務，不必連上雲端！LocalStack 讓測試更快、更省、更簡單](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/kai-fa-aws-fu-wu-bu-bi-lian-shang-yun-duan-localstack-rang-ce-shi-geng-kuai-geng-sheng-geng-jian-dan.md)
{% endcontent-ref %}

{% content-ref url="/pages/by6XyXAWUhmJQDO33D3r" %}
[AI-AWS Amazon Bedrock初試體驗](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/aiaws-amazon-bedrock-chu-shi-ti-yan.md)
{% endcontent-ref %}

{% content-ref url="/pages/LVsITqUwlcVkTaXQj6L9" %}
[AI-搭建本地chtgpt生成文字和圖片 - Ollama](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/ai-da-jian-ben-di-chtgpt-sheng-cheng-wen-zi-he-tu-pian-ollama.md)
{% endcontent-ref %}

{% content-ref url="/pages/OE32zGC2wpQK1WCYGOSv" %}
[資安-CVE-2024-3094重大漏洞檢查](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/zi-an-cve20243094-zhong-da-lou-dong-jian-cha.md)
{% endcontent-ref %}

{% content-ref url="/pages/kyWU9RmCiSaFxFHmf3Id" %}
[AI - PostgreSQL應用- PostgresML研究測試 與客製化編譯建置](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/ai-postgresql-ying-yong-postgresml-yan-jiu-ce-shi-yu-ke-zhi-hua-bian-yi-jian-zhi.md)
{% endcontent-ref %}

{% content-ref url="/pages/8Wh2dxLMTxchKzw6YhdB" %}
[GPU加速對DB效能提升](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/gpu-jia-su-dui-db-xiao-neng-ti-sheng.md)
{% endcontent-ref %}

{% content-ref url="/pages/N8lfSfVCro7JzfTMIQPH" %}
[效能調優-PG之全表掃描排序調優前後對照](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/xiao-neng-diao-you-pg-zhi-quan-biao-sao-miao-pai-xu-diao-you-qian-hou-dui-zhao.md)
{% endcontent-ref %}

{% content-ref url="/pages/AUutly9qeS6hTlhiRxuT" %}
[資安-挖礦病毒清除紀錄](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/zi-an-wa-kuang-bing-du-qing-chu-ji-lu.md)
{% endcontent-ref %}

{% content-ref url="/pages/MYfaCD6lN7A0WogtG5CA" %}
[Windows用原生Visual C++編譯PostgreSQL](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/windows-yong-yuan-sheng-visual-c++-bian-yi-postgresql.md)
{% endcontent-ref %}

{% content-ref url="/pages/qVJSbq75qjJagwqJN0uF" %}
[客製PostgreSQL之el9之rpm (Redhat/CentOS/Rocky/Oracle)](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/ke-zhi-postgresql-zhi-el9-zhi-rpm-redhatcentosrockyoracle.md)
{% endcontent-ref %}

{% content-ref url="/pages/UCkzCVqXDOo97KJwTTVz" %}
[PostgreSQL data to Redis by Bucardo](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/cdc-replication/postgresql-data-to-redis-by-bucardo.md)
{% endcontent-ref %}

{% content-ref url="/pages/aGcKRYhuK9gHSH2VB1pt" %}
[PostgreSQL的高可用和讀寫分離和負載均衡](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/gao-ke-yong-du-xie-fen-li-fu-zai-ping-heng-hareadwrite-splittingloadbalance/postgresql-de-gao-ke-yong-he-du-xie-fen-li-he-fu-zai-jun-heng.md)
{% endcontent-ref %}

{% content-ref url="/pages/oNb6bxWfZQv6kDBETXw8" %}
[原生C /C++(libpq)和 C# (npgsql) 的接口設定高可用和讀寫分離範例](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/gao-ke-yong-du-xie-fen-li-fu-zai-ping-heng-hareadwrite-splittingloadbalance/postgresql-de-gao-ke-yong-he-du-xie-fen-li-he-fu-zai-jun-heng/yuan-shengcc++libpq-he-cnpgsql-de-jie-kou-she-ding-gao-ke-yong-he-du-xie-fen-li-fan-li.md)
{% endcontent-ref %}

{% content-ref url="/pages/bPG76vdPcK5twwNp6ENT" %}
[Python的接口設定高可用和讀寫分離範例](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/gao-ke-yong-du-xie-fen-li-fu-zai-ping-heng-hareadwrite-splittingloadbalance/postgresql-de-gao-ke-yong-he-du-xie-fen-li-he-fu-zai-jun-heng/python-de-jie-kou-she-ding-gao-ke-yong-he-du-xie-fen-li-fan-li.md)
{% endcontent-ref %}

{% content-ref url="/pages/CLHN2MRDrcozTtDOrNL4" %}
[PostgreSQL監控、告警、權限安全性](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/postgresql-jian-kong-gao-jing-quan-xian-an-quan-xing.md)
{% endcontent-ref %}

{% content-ref url="/pages/e18ZAoDOBO4d2I62bTcy" %}
[Oracle 23c Free 簡易快速安裝於Rocky Linux 8](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/oracle-23c-free-jian-yi-kuai-su-an-zhuang-wu-rocky-linux-8.md)
{% endcontent-ref %}

{% content-ref url="/pages/xi7fuM2LnB16kQ6KgRgz" %}
[時序列資料庫-Influxdb enterprise](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/shi-xu-lie-zi-liao-ku-influxdb-enterprise.md)
{% endcontent-ref %}

{% content-ref url="/pages/7hi7Ti6Ycj8lLHkFnJoL" %}
[效能: PostgreSQL中的integer效能計算參考 (Integer vs plpython vs C-Language Functions) vs Oracle 23c](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/xiao-neng-postgresql-zhong-de-integer-xiao-neng-ji-suan-can-kao-integer-vs-plpython-vs-clanguage-fun.md)
{% endcontent-ref %}

{% content-ref url="/pages/9zmaOHSm4XR63Z7ECTTx" %}
[壓力測試比較: Benchmark: Oracle 23c vs PostgreSQL 16](/postgresql-ji-shu-jameslin-yan-jiu-bi-ji/ya-li-ce-shi-bi-jiao-benchmark-oracle-23c-vs-postgresql-16.md)
{% endcontent-ref %}