.ﺩﺮﮐ ﻢﯿﻫﺍﻮﺧ ﯽﺳﺭﺮﺑ ﺍﺭ ﻥﺁ ﯼﺎﻫﺖﯾﺩﻭﺪﺤﻣ ﻦﯿﻨﭽﻤﻫ ﻭ Pandas ﺏﻮﭼﺭﺎﭼ ﺭﺩ SQL ﺩﺮﮑﻠﻤﻋ ﻡ
SQL ﺕﺪﻣ ،ﻪﺘﻓﺎﯾﺭﺎﺘﺧﺎﺳ ﻮﺟ ﻭ ﺱﺮﭘ ﻥﺎﺑﺯ ﺎﯾﻩﺩﺍﺩ ﺖﯾﺮﯾﺪﻣ ﯼﺍﺮﺑ ﻩﺩﺎﻔﺘﺳﺍ ﺩﺭﻮﻣ ﺭﺍﺰﺑﺍ
.ﺩﺮﮐ ﻢﯿﻫﺍﻮﺧ ﯽﺳﺭﺮﺑ ﺍﺭ ﻥﺁ ﯼﺎﻫﺖﯾﺩﻭﺪﺤﻣ ﻦﯿﻨﭽﻤﻫ ﻭ Pandas ﺏﻮﭼﺭﺎﭼ ﺭﺩ SQL ﺩﺮﮑﻠﻤﻋ ﻡ
... ﻪﮐ ﺖﺳﺍ ﻦﯾﺍ ﺪﯿﺳﺮ
ادامه مطلب →.ﺩﺭﺍﺩ ﯽﮕﺘﺴﺑ ﺎﻤﺷ ﻩﮊﻭﺮﭘ ﺹﺎﺧ ﯼﺎﻫﺯﺎﯿﻧ ﻪﺑ ﺪﯿﻨﮐ ﯽﻣ ﺏﺎﺨﺘﻧﺍ ﻪﮐ ﯽﺷﻭﺭ ﻭ ﺩﺭﺍﺩ ﺩﻮﺟﻭ ﻥﻮﺘﯾﺎﭘ
.ﻢﯿﻨﮐ ﯽﻣ ﺭﺍﺮﻗﺮﺑ ﻝﺎﺼﺗﺍ ،ﺩﺭﺍﺩ ﺭﺍﺮﻗ ﻥﺁ ﺭﺩ ﺮﻈﻧ ﺩﺭﻮﻣ MySQL ﻝﻭﺪﺟ ﻪﮐ ﯼﺍ ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﻪ
.ﺪﻨﮐﯽﻣ ﯽﺸﮐﺍﻭ ﻝﻭﺪﺟ ﺯﺍ ﺍﺭ ﺎﻫﻒﯾﺩﺭ ﻡﺎﻤﺗ ﻪﮐ ﺪﯿﻨﮐ ﺍﺮﺟﺍ ﺍﺭ SQL SELECT ﺭﻮﺘﺳﺩ
.ﺪﯾﺮﯿﮕﺑ ﺮﻈﻧ ﺭﺩ ﺍﺭ ﺮﯾﺯ ﺭﺩ ﻩﺪﺷ ﻩﺩﺍﺩ ﻥﺎﺸﻧ SQL ﯼﻮﺟ ﻭ ﺱﺮﭘ
select * from <tableName>.ﺪﯿﻨﮐ ﯽﺑﺎﯾﺯﺎﺑ ﻥﻮﺘﯾﺎﭘ ﺯﺍ ﻩﺩﺎﻔﺘﺳﺍ ﺎﺑ ﺍﺭ ﻪﺠﯿﺘﻧ ﻭ ﺪﯿﻨﮐ ﻩﺩﺎﻔﺘﺳﺍ ﻝﻭﺪﺟ ﯼﺎﻫﻒﯾﺩﺭ ﺩ
.ﺖﺳﺍ ﻩﺩﺍﺩ ﻒﯾﺩﺭ 4 ﯼﻭﺎﺣ ﻪﮐ ﺖﺷﺍﺩ ﻢ
ادامه مطلب →SQLite ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﺯﺍ ﻥﺎﺒﯿﺘﺸﭘ ﻪﺨﺴﻧ ﮏﯾ ﻦﺘﺷﺍﺩ ،ﯼﺮﮕﯾﺩ ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﺮﻫ ﺪﻨﻧﺎﻣ ﺖﺳﺭﺩ ،
.ﺩﺮﮐ ﻢﯿﻫﺍﻮﺧ ﯽﻃ ﺍﺭ ﯼﺮﯿﮔ ﻥﺎﺒﯿﺘﺸﭘ ﻥﺩﻮﺑ ﺰﯿﻣﺁ ﺖﯿﻘﻓﻮﻣ ﺪﯿﯾﺄﺗ ﻭ ﻥﺎﺒﯿﺘﺸﭘ ﻞﯾﺎﻓ ﮏﯾ ﺩﺎﺠﯾﺍ
.ﺪﯾﺭﺍﺩ SQLite ﻭ Python ﺯﺍ ﯼﺍ ﻪﯾﺎﭘ ﺶﻧﺍﺩ ﺎﻤﺷ ﻪﮐ ﺩﻮﺷ ﯽﻣ ﺽﺮﻓ ﺵﺯﻮﻣﺁ ﻦﯾﺍ ﺭﺩ
.ﻢﯿﻨﮐ ﺍﺮﺟﺍ ﺍﺭ ﺮﯾﺯ ﺭﻮﺘﺳﺩ ﻢﯿﻧﺍﻮﺗ ﯽﻣ ﻉﻮﺿﻮﻣ ﻦﯿﻤﻫ ﯽﺳﺭﺮﺑ ﯼﺍﺮﺑ ﻭ ﺖﺳﺍ ﻩﺪﺷ ﺐﺼﻧ ﺎﻣ ﻩﺎﮕﺘﺳ
sqlite3.ﺪﯿﻫﺩ ﻪﻣﺍﺩﺍ ﺮﯾﺯ ﯼﺎﻫ ﻝﺎﺜﻣ ﺎﺑ ﺖﺳﺍ ﺮﺘﻬﺑ ،ﺪﯾﺩﺮﮐ ﺖﻓﺎﯾﺭﺩ ﺖﺳﺍ ﻩﺪﺷ ﻩﺩﺍﺩ ﻥﺎﺸﻧ ﺮﯾﺯ ﺭﺩ ﻪﭽ
SQLite version 3.39.5 2022-10-14 ادامه مطلب →.ﺖﺳﺍ ﺮﯾﺬﭘ ﺱﺎﯿﻘﻣ ﻭ ﻥﺯﻭ ﮏﺒﺳ ،ﻥﺎﺳﺁ ﻥﺁ ﺯﺍ ﻩﺩﺎﻔﺘﺳﺍ ﻪﮐ ﺖﺳﺍ ﺏﻮﺒﺤﻣ ﯼﺍ ﻪﻄﺑﺍﺭ ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎ
.ﺖﻓﺮﮔ ﻢﯿﻫﺍﻮﺧ ﺩﺎﯾ ﺍﺭ ﻥﻮﺘﯾﺎﭘ ﺯﺍ ﻩﺩﺎﻔﺘﺳﺍ ﺎﺑ ،CSV ﯼﺎﻫ ﻞﯾﺎﻓ ﺯﺍ SQLite ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﺩ
SQLite ﯼﺍ ﻪﻄﺑﺍﺭ ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﺖﯾﺮﯾﺪﻣ ﻢﺘﺴﯿﺳ ﮏﯾ ﻪﮐ ﺖﺳﺍ ﯼﺭﺍﺰﻓﺍ ﻡﺮﻧ ﻪﻧﺎﺨﺑﺎﺘﮐ ﮏﯾ (RDB
.ﺖﺷﺍﺩ ﯽﺳﺮﺘﺳﺩ ﺎﻬﻧﺁ ﻪﺑ ﺎﻫ ﻪﻣﺎﻧﺮﺑ ﻂﺳﻮﺗ ﻢﯿﻘﺘﺴﻣ ﺭﻮﻃ ﻪﺑ ﻥﺍﻮﺗ ﯽﻣ ﻭ ﺪﻧﺭﺍﺪﻧ ﺯﺎﯿﻧ ﯼﺍ ﻪﻧﺎ
SQLite ﺩﺭﺍﺪﻧﺎﺘﺳﺍ ﻮﺤﻧ ﺯﺍ ﻭ ﺩﺭﺍﺩ ﺯﺎﯿﻧ ﻊﺑﺎﻨﻣ
ادامه مطلب →.ﺩﺮﮐ ﻢﯿﻫﺍﻮﺧ ﯽﺳﺭﺮﺑ ﺩﻮﺟﻮﻣ ﻝﻭﺪﺟ ﺯﺍ ﺎﻫﻥﻮﺘﺳ ﻑﺬﺣ ﺎﯾ ﺶﯾﺍﺮﯾﻭ ،ﻥﺩﻭﺰﻓﺍ ﯼﺍﺮﺑ ALTER T
.ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﻝﺎﺼﺗﺍ ﻦﺘﺴﺑ ﻭ ﺕﺍﺮﯿﯿﻐﺗ ﻡﺎﺠﻧﺍ ،ALTER TABLE ﺭﻮﺘﺳﺩ ﯼﺍﺮﺟﺍ ،ﺎﻤﻧ ﻥﺎﮑﻣ ﯽﺷ
SQLite ﺭﺩ Python ﻝﻭﮊﺎﻣ ﻪﺑ Python SQLite ﻩﺩﺍﺩ ﯼﺎﻫ ﻩﺎﮕﯾﺎﭘ ﻪﺑ ﯽﺳﺮﺘﺳﺩ ﯼﺍﺮﺑ ﻂﺑﺍﺭ ﮏﯾ
.ﺩﻮﺷ ﯽﻣ ﻩﺩﺎﻔﺘﺳﺍ ﻂﺳﻮﺘﻣ ﺎﺗ ﮏﭼﻮﮐ ﯼﺎﻫ ﻩﮊﻭﺮﭘ ﯼﺍﺮﺑ ﻦﯿﻨﭽﻤﻫ ﻭ ﻞﯾﺎﺑﻮﻣ ﻭ ﺏﻭ ﯼﺩﺮﺑﺭﺎﮐ ﯼﺎﻫ
ادامه مطلب →
ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﯽﺑﺎﯾﺯﺎﺑ ﺖﯿﻠ
.ﻢﯿﻨﮐ ﯽﻣ ﺩﺎﺠﯾﺍ ﺍﺭ MySQL ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﺩﺎﻤﺘﻋﺍ ﻞﺑﺎﻗ ﯼﺎﻫ ﻥﺎﺒﯿﺘﺸﭘ ﻪﺠﯿﺘﻧ ﺭﺩ ،ﻢﯾﺭﻭﺁ ﯽﻣ
.ﺪﻨﮐ ﯽﻣ ﻩﺩﺎﻔﺘﺳﺍ MySQL ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﺯﺍ ﻥﺎﺒﯿﺘﺸﭘ ﻪﺨﺴﻧ ﮏﯾ ﺯﺍ ﺖﻈﻓﺎﺤﻣ ﻭ mysqldump ﺭﻮﺘ
im ادامه مطلب →SQLite ﯼﺍ ﻪﻄﺑﺍﺭ ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﺖﯾﺮﯾﺪﻣ ﯼﺎﻫ ﻢﺘﺴﯿﺳ ﻦﯾﺮﺗ ﺏﻮﺒﺤﻣ ﺯﺍ ﯽﮑﯾ (RDBMS) ﺪﯾﺭﺍﺪﻧ
.ﺪﻨﮐ ﯽﻣ ﯽﻟﺎﻋ ﮏﭼﻮﮐ ﯼﺎﻫ ﻩﮊﻭﺮﭘ ﻭ ﻥﺎﯾﺪﺘﺒﻣ ﯼﺍﺮﺑ ﺍﺭ ﻥﺁ ﻭ ،ﺩﺭﺍﺪﻧ ﺩﻮﺟﻭ ﯼﺍ ﻩﺪﯿﭽﯿﭘ ﺐﺼﻧ ﺪ
SQLite ﺪﯿﺷﺎﺑ ﺪﯾﺪﺟ ﻪﻣﺎﻧﺮﺑ ﮏﯾ ﯼﺯﺎﺳ ﻪﻧﻮﻤﻧ ﺎﯾ ﯽﺼﺨﺷ ﻩﮊﻭﺮﭘ ﮏﯾ ﺖﺧﺎﺳ ﻝﺎﺣ ﺭﺩ ﻪﭼ .ﯽﻓﺎﺿﺍ
:ﻢﯿﻫﺩ ﺶﺷﻮﭘ ﺵﺯﻮﻣﺁ ﻦﯾﺍ ﺭﺩ ﻢﯾﺭﺍﺩ
ادامه مطلب →.ﺩﺮﮐ ﺪﯿﻫﺍﻮﺧ ﻝﺎﻤﻋﺍ ﺎﻫ ﻩﺩﺍﺩ ﮎﺭﺩ ﻭ ﻪﯾﺰﺠﺗ ﯼﺍﺮﺑ ﻥﻮﺘﯾﺎﭘ ﺭﺩ ﺍﺭ ﺪﻨﻧﺎﻣ SQL ﻊﺑﺍﻮﺗ ،ﻪﻣﺍﺩﺍ
.ﻢﯿﻨﮐ ﻉﻭﺮﺷ ﺪﯿﯾﺎﯿﺑ
ﺪﯿﺷﺎﺑ ﻪﺘﺷﺍﺩ ﺍﺭ SQL ﺶﻧﺍﺩ ﺪﯾﺎﺑ ،ﻥﻮﺘﯾﺎﭘ ﺎﺑ MySQL ﻝﺎﺼﺗﺍ ﺯﺍ ﻩﺩﺎﻔﺘﺳﺍ ﯼﺍﺮﺑ
ﻢﯿﻨﮐ ﮎﺭﺩ ﺪﯿﯾﺎﯿﺑ ،ﻖﯿﻤﻋ ﯽﺻﺍﻮﻏ ﺯﺍ ﻞﺒﻗ
MySQL ﻉﻮﻧ ﻦﯾﺮﺘﻬﺑ ﺯﺍ ﯽﮑﯾ ﻭ ﺯﺎﺑ ﻊﺒﻨﻣ ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ ﮏﯾ RDBMS (ﯼﺍ ﻪﻄﺑﺍﺭ ﻩﺩﺍﺩ ﻩﺎﮕﯾﺎﭘ
/http
ادامه مطلب →.ﺪﯿﻨﮐ ﻪﯾﺎﻤﻧ ﺩﺎﺠﯾﺍ ﻮﺟ ﻭ ﺱﺮﭘ ﻪﺑ ﻥﺪﯿﺸﺨﺑ ﺖﻋﺮﺳ ﯼﺍﺮﺑ ﻪﻧﻮﮕﭼ ﻪﮐ ﺪﯾﺮﯿﮕﺑ ﺩﺎﯾ ﻦﯿﻨﭽﻤﻫ .ﺪﯾﺮ
.ﺪﻨﻨﮐﯽﻣ ﺭﺎﮐ ﺎﻫﺏﺎﺘﮐ ﯼﺎﻫﻪﯾﺎﻤﻧ ﻪﺑﺎﺸﻣ .ﺪﻫﺩ ﯽﻣ ﺶﯾﺍﺰﻓﺍ ﯽﻬﺟﻮﺗ ﻞﺑﺎﻗ ﻥﺍﺰﯿﻣ ﻪﺑ ﺍﺭ ﻮﺟ ﻭ ﺱﺮﭘ ﺖﻋﺮﺳ ﺭﺎﮐ ﻦﯾﺍ .ﺪﯿﻨﮐ ﺩﺎﺠﯾﺍ ﺎﻫ ﻥﻮﺘ .ﺪﺸﺨﺑ