ﺎﻫ ﻩﺩﺍﺩ ﻞﯿﻠﺤﺗ ﻭ ﻪﯾﺰﺠﺗ ﯼﺍﺮﺑ ﻢﻫ ﺎﺑ SQL ﻭ ﺎﻫﺍﺪﻧﺎﭘ ﺯﺍ ﻩﺩﺎﻔﺘﺳﺍ

.ﺩﺮﮐ ﻢﯿﻫﺍﻮﺧ ﯽﺳﺭﺮﺑ ﺍﺭ ﻥﺁ ﯼﺎﻫﺖﯾﺩﻭﺪﺤﻣ ﻦﯿﻨﭽﻤﻫ ﻭ Pandas ﺏﻮﭼﺭﺎﭼ ﺭﺩ SQL ﺩﺮﮑﻠﻤﻋ ﻡ

SQL ﺕﺪﻣ ،ﻪﺘﻓﺎﯾﺭﺎﺘﺧﺎﺳ ﻮﺟ ﻭ ﺱﺮﭘ ﻥﺎﺑﺯ ﺎﯾﻩﺩﺍﺩ ﺖﯾﺮﯾﺪﻣ ﯼﺍﺮﺑ ﻩﺩﺎﻔﺘﺳﺍ ﺩﺭﻮﻣ ﺭﺍﺰﺑﺍ

.ﺩﺮﮐ ﻢﯿﻫﺍﻮﺧ ﯽﺳﺭﺮﺑ ﺍﺭ ﻥﺁ ﯼﺎﻫﺖﯾﺩﻭﺪﺤﻣ ﻦﯿﻨﭽﻤﻫ ﻭ Pandas ﺏﻮﭼﺭﺎﭼ ﺭﺩ SQL ﺩﺮﮑﻠﻤﻋ ﻡ

... ﻪﮐ ﺖﺳﺍ ﻦﯾﺍ ﺪﯿﺳﺮ

ادامه مطلب →

؟ﻢﯾﺭﺎﻤﺸﺑ ﻥﻮﺘﯾﺎﭘ ﺭﺩ ﺍﺭ MySQL ﻝﻭﺪﺟ ﯼﺎﻫ ﻒﯾﺩﺭ ﺩﺍﺪﻌﺗ ﻪﻧﻮﮕﭼ

.ﺩﺭﺍﺩ ﯽﮕﺘﺴﺑ ﺎﻤﺷ ﻩﮊﻭﺮﭘ ﺹﺎﺧ ﯼﺎﻫﺯﺎﯿﻧ ﻪﺑ ﺪﯿﻨﮐ ﯽﻣ ﺏﺎﺨﺘﻧﺍ ﻪﮐ ﯽﺷﻭﺭ ﻭ ﺩﺭﺍﺩ ﺩﻮﺟﻭ ﻥﻮﺘﯾﺎﭘ

.ﻢﯿﻨﮐ ﯽﻣ ﺭﺍﺮﻗﺮﺑ ﻝﺎﺼﺗﺍ ،ﺩﺭﺍﺩ ﺭﺍﺮﻗ ﻥﺁ ﺭﺩ ﺮﻈﻧ ﺩﺭﻮﻣ MySQL ﻝﻭﺪﺟ ﻪﮐ ﯼﺍ ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﻪ

.ﺪﻨﮐﯽﻣ ﯽﺸﮐﺍﻭ ﻝﻭﺪﺟ ﺯﺍ ﺍﺭ ﺎﻫﻒﯾﺩﺭ ﻡﺎﻤﺗ ﻪﮐ ﺪﯿﻨﮐ ﺍﺮﺟﺍ ﺍﺭ SQL SELECT ﺭﻮﺘﺳﺩ

.ﺪﯾﺮﯿﮕﺑ ﺮﻈﻧ ﺭﺩ ﺍﺭ ﺮﯾﺯ ﺭﺩ ﻩﺪﺷ ﻩﺩﺍﺩ ﻥﺎﺸﻧ SQL ﯼﻮﺟ ﻭ ﺱﺮﭘ

select * from <tableName>

.ﺪﯿﻨﮐ ﯽﺑﺎﯾﺯﺎﺑ ﻥﻮﺘﯾﺎﭘ ﺯﺍ ﻩﺩﺎﻔﺘﺳﺍ ﺎﺑ ﺍﺭ ﻪﺠﯿﺘﻧ ﻭ ﺪﯿﻨﮐ ﻩﺩﺎﻔﺘﺳﺍ ﻝﻭﺪﺟ ﯼﺎﻫﻒﯾﺩﺭ ﺩ

.ﺖﺳﺍ ﻩﺩﺍﺩ ﻒﯾﺩﺭ 4 ﯼﻭﺎﺣ ﻪﮐ ﺖﺷﺍﺩ ﻢ

ادامه مطلب →

؟ﻢﯿﻨﮐ ﺩﺎﺠﯾﺍ SQLite ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﺯﺍ ﻥﺎﺒﯿﺘﺸﭘ ﻪﺨﺴﻧ ﮏﯾ ﻥﻮﺘﯾﺎﭘ ﺯﺍ ﻩﺩﺎﻔﺘﺳﺍ ﺎﺑ ﻪﻧﻮﮕﭼ

SQLite ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﺯﺍ ﻥﺎﺒﯿﺘﺸﭘ ﻪﺨﺴﻧ ﮏﯾ ﻦﺘﺷﺍﺩ ،ﯼﺮﮕﯾﺩ ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﺮﻫ ﺪﻨﻧﺎﻣ ﺖﺳﺭﺩ ،

.ﺩﺮﮐ ﻢﯿﻫﺍﻮﺧ ﯽﻃ ﺍﺭ ﯼﺮﯿﮔ ﻥﺎﺒﯿﺘﺸﭘ ﻥﺩﻮﺑ ﺰﯿﻣﺁ ﺖﯿﻘﻓﻮﻣ ﺪﯿﯾﺄﺗ ﻭ ﻥﺎﺒﯿﺘﺸﭘ ﻞﯾﺎﻓ ﮏﯾ ﺩﺎﺠﯾﺍ

.ﺪﯾﺭﺍﺩ SQLite ﻭ Python ﺯﺍ ﯼﺍ ﻪﯾﺎﭘ ﺶﻧﺍﺩ ﺎﻤﺷ ﻪﮐ ﺩﻮﺷ ﯽﻣ ﺽﺮﻓ ﺵﺯﻮﻣﺁ ﻦﯾﺍ ﺭﺩ

.ﻢﯿﻨﮐ ﺍﺮﺟﺍ ﺍﺭ ﺮﯾﺯ ﺭﻮﺘﺳﺩ ﻢﯿﻧﺍﻮﺗ ﯽﻣ ﻉﻮﺿﻮﻣ ﻦﯿﻤﻫ ﯽﺳﺭﺮﺑ ﯼﺍﺮﺑ ﻭ ﺖﺳﺍ ﻩﺪﺷ ﺐﺼﻧ ﺎﻣ ﻩﺎﮕﺘﺳ

sqlite3

.ﺪﯿﻫﺩ ﻪﻣﺍﺩﺍ ﺮﯾﺯ ﯼﺎﻫ ﻝﺎﺜﻣ ﺎﺑ ﺖﺳﺍ ﺮﺘﻬﺑ ،ﺪﯾﺩﺮﮐ ﺖﻓﺎﯾﺭﺩ ﺖﺳﺍ ﻩﺪﺷ ﻩﺩﺍﺩ ﻥﺎﺸﻧ ﺮﯾﺯ ﺭﺩ ﻪﭽ

SQLite version 3.39.5 2022-10-14

ادامه مطلب →

ﻥﻮﺘﯾﺎﭘ ﺎﺑ CSV ﺯﺍ SQLite ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﺩﺎﺠﯾﺍ

.ﺖﺳﺍ ﺮﯾﺬﭘ ﺱﺎﯿﻘﻣ ﻭ ﻥﺯﻭ ﮏﺒﺳ ،ﻥﺎﺳﺁ ﻥﺁ ﺯﺍ ﻩﺩﺎﻔﺘﺳﺍ ﻪﮐ ﺖﺳﺍ ﺏﻮﺒﺤﻣ ﯼﺍ ﻪﻄﺑﺍﺭ ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎ

.ﺖﻓﺮﮔ ﻢﯿﻫﺍﻮﺧ ﺩﺎﯾ ﺍﺭ ﻥﻮﺘﯾﺎﭘ ﺯﺍ ﻩﺩﺎﻔﺘﺳﺍ ﺎﺑ ،CSV ﯼﺎﻫ ﻞﯾﺎﻓ ﺯﺍ SQLite ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﺩ

؟ﺖﺴﯿﭼ SQLite ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ

SQLite ﯼﺍ ﻪﻄﺑﺍﺭ ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﺖﯾﺮﯾﺪﻣ ﻢﺘﺴﯿﺳ ﮏﯾ ﻪﮐ ﺖﺳﺍ ﯼﺭﺍﺰﻓﺍ ﻡﺮﻧ ﻪﻧﺎﺨﺑﺎﺘﮐ ﮏﯾ (RDB

.ﺖﺷﺍﺩ ﯽﺳﺮﺘﺳﺩ ﺎﻬﻧﺁ ﻪﺑ ﺎﻫ ﻪﻣﺎﻧﺮﺑ ﻂﺳﻮﺗ ﻢﯿﻘﺘﺴﻣ ﺭﻮﻃ ﻪﺑ ﻥﺍﻮﺗ ﯽﻣ ﻭ ﺪﻧﺭﺍﺪﻧ ﺯﺎﯿﻧ ﯼﺍ ﻪﻧﺎ

SQLite ﺩﺭﺍﺪﻧﺎﺘﺳﺍ ﻮﺤﻧ ﺯﺍ ﻭ ﺩﺭﺍﺩ ﺯﺎﯿﻧ ﻊﺑﺎﻨﻣ

ادامه مطلب →

؟ﻢﯿﻫﺩ ﺮﯿﯿﻐﺗ ﺍﺭ SQLite ﻝﻭﺪﺟ ﮏﯾ ﻥﻮﺘﯾﺎﭘ ﺯﺍ ﻩﺩﺎﻔﺘﺳﺍ ﺎﺑ ﻪﻧﻮﮕﭼ

.ﺩﺮﮐ ﻢﯿﻫﺍﻮﺧ ﯽﺳﺭﺮﺑ ﺩﻮﺟﻮﻣ ﻝﻭﺪﺟ ﺯﺍ ﺎﻫﻥﻮﺘﺳ ﻑﺬﺣ ﺎﯾ ﺶﯾﺍﺮﯾﻭ ،ﻥﺩﻭﺰﻓﺍ ﯼﺍﺮﺑ ALTER T

.ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﻝﺎﺼﺗﺍ ﻦﺘﺴﺑ ﻭ ﺕﺍﺮﯿﯿﻐﺗ ﻡﺎﺠﻧﺍ ،ALTER TABLE ﺭﻮﺘﺳﺩ ﯼﺍﺮﺟﺍ ،ﺎﻤﻧ ﻥﺎﮑﻣ ﯽﺷ

SQLite

SQLite ﺭﺩ Python ﻝﻭﮊﺎﻣ ﻪﺑ Python SQLite ﻩﺩﺍﺩ ﯼﺎﻫ ﻩﺎﮕﯾﺎﭘ ﻪﺑ ﯽﺳﺮﺘﺳﺩ ﯼﺍﺮﺑ ﻂﺑﺍﺭ ﮏﯾ

.ﺩﻮﺷ ﯽﻣ ﻩﺩﺎﻔﺘﺳﺍ ﻂﺳﻮﺘﻣ ﺎﺗ ﮏﭼﻮﮐ ﯼﺎﻫ ﻩﮊﻭﺮﭘ ﯼﺍﺮﺑ ﻦﯿﻨﭽﻤﻫ ﻭ ﻞﯾﺎﺑﻮﻣ ﻭ ﺏﻭ ﯼﺩﺮﺑﺭﺎﮐ ﯼﺎﻫ

ﻝﻭﮊﺎﻣ ﻥﺩﺮﮐ ﺩﺭﺍﻭ

ادامه مطلب →

؟ﻢﯿﻨﮐ ﻪﯿﻬﺗ ﻥﺎﺒﯿﺘﺸﭘ ﻪﺨﺴﻧ MySQL ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﺯﺍ ﻥﻮﺘﯾﺎﭘ ﺯﺍ ﻩﺩﺎﻔﺘﺳﺍ ﺎﺑ ﻪﻧﻮﮕﭼ

ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﯽﺑﺎﯾﺯﺎﺑ ﺖﯿﻠ

ﯽﻋﺮﻓ ﻝﻭﮊﺎﻣ ﻥﺍﻮﺗ ﺯﺍ ﻩﺩﺎﻔﺘﺳﺍ :1 ﺵﻭﺭ

.ﻢﯿﻨﮐ ﯽﻣ ﺩﺎﺠﯾﺍ ﺍﺭ MySQL ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﺩﺎﻤﺘﻋﺍ ﻞﺑﺎﻗ ﯼﺎﻫ ﻥﺎﺒﯿﺘﺸﭘ ﻪﺠﯿﺘﻧ ﺭﺩ ،ﻢﯾﺭﻭﺁ ﯽﻣ

ﻝﺎﺜﻣ

.ﺪﻨﮐ ﯽﻣ ﻩﺩﺎﻔﺘﺳﺍ MySQL ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﺯﺍ ﻥﺎﺒﯿﺘﺸﭘ ﻪﺨﺴﻧ ﮏﯾ ﺯﺍ ﺖﻈﻓﺎﺤﻣ ﻭ mysqldump ﺭﻮﺘ

im

ادامه مطلب →

ﻥﺎﯾﺪﺘﺒﻣ ﯼﺎﻤﻨﻫﺍﺭ ﺏﺎﺘﮐ - ﻥﻮﺘﯾﺎﭘ ﺭﺩ SQLite ﺎﺑ ﺭﺎﮐ ﻩﻮﺤﻧ

SQLite ﯼﺍ ﻪﻄﺑﺍﺭ ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﺖﯾﺮﯾﺪﻣ ﯼﺎﻫ ﻢﺘﺴﯿﺳ ﻦﯾﺮﺗ ﺏﻮﺒﺤﻣ ﺯﺍ ﯽﮑﯾ (RDBMS) ﺪﯾﺭﺍﺪﻧ

.ﺪﻨﮐ ﯽﻣ ﯽﻟﺎﻋ ﮏﭼﻮﮐ ﯼﺎﻫ ﻩﮊﻭﺮﭘ ﻭ ﻥﺎﯾﺪﺘﺒﻣ ﯼﺍﺮﺑ ﺍﺭ ﻥﺁ ﻭ ،ﺩﺭﺍﺪﻧ ﺩﻮﺟﻭ ﯼﺍ ﻩﺪﯿﭽﯿﭘ ﺐﺼﻧ ﺪ

SQLite ﺪﯿﺷﺎﺑ ﺪﯾﺪﺟ ﻪﻣﺎﻧﺮﺑ ﮏﯾ ﯼﺯﺎﺳ ﻪﻧﻮﻤﻧ ﺎﯾ ﯽﺼﺨﺷ ﻩﮊﻭﺮﭘ ﮏﯾ ﺖﺧﺎﺳ ﻝﺎﺣ ﺭﺩ ﻪﭼ .ﯽﻓﺎﺿﺍ

:ﻢﯿﻫﺩ ﺶﺷﻮﭘ ﺵﺯﻮﻣﺁ ﻦﯾﺍ ﺭﺩ ﻢﯾﺭﺍﺩ

ادامه مطلب →

ﺎﻫﺍﺪﻧﺎﭘ ﺎﺑ ﯽﻠﻤﻋ ﺶﻨﯿﺑ ﻪﺑ ﺕﻼﻐﺘﺴﻣ ﻭ ﮎﻼﻣﺍ ﯼﺎﻫ ﻩﺩﺍﺩ ﻞﯾﺪﺒﺗ :SQL ﺯﺍ ﺮﺗﺍﺮﻓ

.ﺩﺮﮐ ﺪﯿﻫﺍﻮﺧ ﻝﺎﻤﻋﺍ ﺎﻫ ﻩﺩﺍﺩ ﮎﺭﺩ ﻭ ﻪﯾﺰﺠﺗ ﯼﺍﺮﺑ ﻥﻮﺘﯾﺎﭘ ﺭﺩ ﺍﺭ ﺪﻨﻧﺎﻣ SQL ﻊﺑﺍﻮﺗ ،ﻪﻣﺍﺩﺍ

.ﻢﯿﻨﮐ ﻉﻭﺮﺷ ﺪﯿﯾﺎﯿﺑ

ادامه مطلب →

[ﺎﻫ ﻪﻧﻮﻤﻧ] ﻝﻭﺪﺟ ﻭ ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ :MySQL ﻝﺎﺼﺗﺍ ﺖﯿﻠﺑﺎﻗ ﺎﺑ ﻥﻮﺘﯾﺎﭘ

ﺪﯿﺷﺎﺑ ﻪﺘﺷﺍﺩ ﺍﺭ SQL ﺶﻧﺍﺩ ﺪﯾﺎﺑ ،ﻥﻮﺘﯾﺎﭘ ﺎﺑ MySQL ﻝﺎﺼﺗﺍ ﺯﺍ ﻩﺩﺎﻔﺘﺳﺍ ﯼﺍﺮﺑ

ﻢﯿﻨﮐ ﮎﺭﺩ ﺪﯿﯾﺎﯿﺑ ،ﻖﯿﻤﻋ ﯽﺻﺍﻮﻏ ﺯﺍ ﻞﺒﻗ

MySQL ؟ﺖﺴﯿﭼ

MySQL ﻉﻮﻧ ﻦﯾﺮﺘﻬﺑ ﺯﺍ ﯽﮑﯾ ﻭ ﺯﺎﺑ ﻊﺒﻨﻣ ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﮏﯾ RDBMS (ﯼﺍ ﻪﻄﺑﺍﺭ ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ

ﺲﮑﯿﻧﻮﯾ/ﺲﮐﻮﻨﯿﻟ ،ﺯﻭﺪﻨﯾﻭ ﺭﺩ MySQL Connector Python ﺐﺼﻧ ﻩﻮﺤﻧ

MySQL ﺪﯿﻨﮐ ﺐﺼﻧ ﺲﮑﯿﻧﻮﯾ/ﺲﮐﻮﻨﯿﻟ ﺭﺩ ﺍﺭ:

/http

ادامه مطلب →

[ﻥﻮﺘﯾﺎﭘ ﻪﺨﺴﻧ] ﺎﻫ ﺲﮐﺪﻨﯾﺍ ﺯﺍ ﻩﺩﺎﻔﺘﺳﺍ ﺎﺑ SQL ﯼﺎﻫﻮﺟ ﻭ ﺱﺮﭘ ﻪﺑ ﻥﺪﯿﺸﺨﺑ ﺖﻋﺮﺳ ﻩﻮﺤﻧ

.ﺪﯿﻨﮐ ﻪﯾﺎﻤﻧ ﺩﺎﺠﯾﺍ ﻮﺟ ﻭ ﺱﺮﭘ ﻪﺑ ﻥﺪﯿﺸﺨﺑ ﺖﻋﺮﺳ ﯼﺍﺮﺑ ﻪﻧﻮﮕﭼ ﻪﮐ ﺪﯾﺮﯿﮕﺑ ﺩﺎﯾ ﻦﯿﻨﭽﻤﻫ .ﺪﯾﺮ

.ﺪﻨﻨﮐﯽﻣ ﺭﺎﮐ ﺎﻫﺏﺎﺘﮐ ﯼﺎﻫﻪﯾﺎﻤﻧ ﻪﺑﺎﺸﻣ ﺭﺩ ﺎﻫﺺﺧﺎﺷ

.ﺪﻫﺩ ﯽﻣ ﺶﯾﺍﺰﻓﺍ ﯽﻬﺟﻮﺗ ﻞﺑﺎﻗ ﻥﺍﺰﯿﻣ ﻪﺑ ﺍﺭ ﻮﺟ ﻭ ﺱﺮﭘ ﺖﻋﺮﺳ ﺭﺎﮐ ﻦﯾﺍ .ﺪﯿﻨﮐ ﺩﺎﺠﯾﺍ ﺎﻫ ﻥﻮﺘ

.ﺪﺸﺨﺑ

ادامه مطلب →