{"id":63,"date":"2010-04-17T21:42:41","date_gmt":"2010-04-18T06:42:41","guid":{"rendered":"\/blog\/?p=63"},"modified":"2023-09-21T09:41:20","modified_gmt":"2023-09-21T00:41:20","slug":"sqlite-%ed%94%84%eb%a1%9c%ea%b7%b8%eb%9e%98%eb%b0%8d","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=63","title":{"rendered":"Sqlite \ud504\ub85c\uadf8\ub798\ubc0d"},"content":{"rendered":"\n

Sqlite \ud504\ub85c\uadf8\ub798\ubc0d<\/A><\/H1>\n

\uc724\uc0c1\ubc30<\/A><\/H3>\n
\n
\n

                yundream@join.co.kr
            <\/P><\/DIV><\/DIV>\n

\n\n\n\n\n\n\n\n
\uad50\uc815 \uacfc\uc815<\/B><\/TH><\/TR>\n
\uad50\uc815 0.9<\/TD>\n2004\ub144 2\uc6d4 16\uc77c 8\uc2dc<\/TD>\n <\/TD><\/TR>\n
\ucc38\uace0\ubb38\ud5cc\ubc0f \uc0ac\uc774\ud2b8 \ucd94\uac00<\/TD><\/TR>\n
\uad50\uc815 0.8<\/TD>\n2004\ub144 1\uc6d4 09\uc77c 20\uc2dc<\/TD>\n <\/TD><\/TR>\n
\ucd5c\ucd08 \ubb38\uc11c\uc791\uc131<\/TD><\/TR><\/TBODY><\/TABLE><\/DIV>\n
\n\n
\n
\n
\ucc28\ub840<\/B> \n
1\uc808. \uc18c\uac1c<\/A> \n
2\uc808. Sqlite<\/A> \n
\n
\n
2.1\uc808. Sqlite\uc758 \ud2b9\uc9d5<\/A> \n
2.2\uc808. \uc124\uce58\ud558\uae30<\/A><\/DT><\/DL>\n
3\uc808. Sqlite \uac04\ub2e8 \uc6b4\uc6a9<\/A> \n
\n
\n
3.1\uc808. DB \uc0dd\uc131\ubc0f \uac04\ub2e8\ud55c \ub0b4\ubd80\uba85\ub839\uc5b4\ub4e4<\/A><\/DT><\/DL>\n
4\uc808. C\/C++ Interface<\/A> \n
\n
\n
4.1\uc808. \ud575\uc2ec API<\/A> \n
4.2\uc808. DB \uc5f4\uae30<\/A> \n
4.3\uc808. DB\ub2eb\uae30<\/A> \n
4.4\uc808. SQL \uc2e4\ud589<\/A> \n
4.5\uc808. \uc5d0\ub7ec \ucf54\ub4dc<\/A> \n
4.6\uc808. \uc608\uc81c \ud504\ub85c\uadf8\ub7a8<\/A><\/DT><\/DL>\n
5\uc808. \ucf5c\ubc31\ud568\uc218\ub97c \uc774\uc6a9\ud558\uc9c0 \uc54a\ub294 \ub370\uc774\ud130 \uc811\uadfc<\/A> \n
6\uc808. \ucc38\uace0\ubb38\ud5cc<\/A><\/DT><\/DL><\/DIV>\n
\n
\n\n

1\uc808. \uc18c\uac1c<\/A><\/H1>\n

\uc9c0\uae08\uae4c\uc9c0 Oracle, Mysql, Postgresql \uacfc \uac19\uc740 \ud070 \uaddc\ubaa8\uc758 DB\ud504\ub85c\uadf8\ub798\ubc0d\uc744 \ud574\uc654\uc73c\uba70 \uc791\uc740 \uaddc\ubaa8\uc5d0\uc11c \uac04\ub2e8\ud558\uac8c \uc0ac\uc6a9\ud558\uae30 \uc704\ud55c \uc6a9\ub3c4\ub85c gdbm \uacfc \uac19\uc740 \ub77c\uc774\ube0c\ub7ec\ub9ac\ub97c \uc0ac\uc6a9\ud588\uc5c8\ub2e4. \uc774\ub4e4\uc758 \ubb38\uc81c\ub294 Oracle, Mysql, Postgresql\uc740 \uc801\ub2f9\ud55c \uae30\ub2a5\uc744 \uc9c0\uc6d0\ud558\uae30 \uc704\ud574\uc11c \uc9c0\ub098\uce58\uac8c \ubb34\uac81\ub2e4\ub294 \uc810\uc774\uace0, gdbm\uacfc \uac19\uc740 \uacbd\uc6b0 \ub9e4\uc6b0 \uac00\ubccd\uace0 \uac04\ub2e8\ud558\uae30\ub294 \ud558\uc9c0\ub9cc \uae30\ub2a5\uc774 \ub108\ubb34 \uc81c\ud55c\uc801\uc774\uace0 SQL\ubb38\ubc95\uc744 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294\ub2e4\ub294 \uc810\uc774\ub2e4. \uadf8\ub7ec\ub358\uc911 Sqlite\ub97c \uc54c\uac8c \ub418\uc5c8\ub2e4. \uc6f9\ud504\ub85c\uadf8\ub798\ubc0d\ub3c4 \uacb8\ud558\ub2e4\ubcf4\ub2c8 \uc880\ub354 \uac00\ubcbc\uc6b4 DB\ub3c4\uad6c\ub97c \ucc3e\uc544 \ud5e4\uba54\ub358\uc911 \ubc1c\uacac\ud588\ub2e4. \uc774 \ubb38\uc11c\ub294 Sqlite\uc758 \uc124\uce58\uc640 \ud504\ub85c\uadf8\ub798\ubc0d \ud65c\uc6a9\ubc29\uc548\ub4f1\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc744 \ub2f4\uace0 \uc788\ub2e4. <\/P>\n

\ubb38\uc11c\ub294 Linux OS\ub97c \uae30\uc900\uc73c\ub85c \uc791\uc131\ub418\uc5c8\ub2e4. Windows\ud658\uacbd\uc5d0\uc11c\uc758 SQLite\uc758 \uc124\uce58\uc5d0 \ub300\ud55c \ud78c\ud2b8\ub97c \uc5bb\uace0 \uc2f6\ub2e4\uba74 SWLite Windows<\/A>\ub97c \ucc38\uace0\ud558\uae30 \ubc14\ub780\ub2e4. <\/P>\n

\ub610\ud55c SQLite\uc751\uc6a9 \ud504\ub85c\uc81d\ud2b8\ub3c4 \uc788\uc73c\ub2c8 \uc774 \uae00\uc744 \uc77d\uc740\ud6c4 \uad00\uc2ec\uc774 \uc0dd\uacbc\ub2e4\uba74 \ud55c\ubc88\ucbe4 \ucc3e\uc544\uc8fc\uae38 \ubc14\ub780\ub2e4. SQLiteDBMS \ud504\ub85c\uc81d\ud2b8<\/A>\ub85c \uac00\uae30 <\/P><\/DIV>\n

\n
\n\n

2\uc808. Sqlite<\/A><\/H1>\n

\ud604\uc7ac \uc2dc\uc810\uc5d0\uc11c \ucd5c\uc2e0 \ubc84\uc83c\uc778 sqlite-2.8.9\ub97c \uae30\uc900\uc73c\ub85c \ud55c\ub2e4. <\/P>\n

\n
\n\n

2.1\uc808. Sqlite\uc758 \ud2b9\uc9d5<\/A><\/H2>\n

 <\/P>\n

 <\/P>\n

    \n
  1. SQL92\uc758 \ub300\ubd80\ubd84\uc744 \uc9c0\uc6d0\ud55c\ub2e4. \ub2e4\uc74c\uc740 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294 \uba87 \uac00\uc9c0 \uae30\ub2a5\ub4e4\uc774\ub2e4. \n
  2. \ub2e8\uc77c \ud30c\uc77c\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubaa8\ub4e0\uac83\uc744 \ud3ec\ud568\ud55c\ub2e4. \n
  3. ACID<\/A>(Atomic, Consistent, Isolate, Durable) \ubcf4\uc99d \n
  4. byte order\uc5d0 \uad00\uacc4\uc5c6\uc774 \ub370\uc774\ud130 \ud30c\uc77c\uc758 \uacf5\uc720\uac00 \uac00\ub2a5 \n
  5. 2\ud14c\ub77c\ubc14\uc774\ud2b8 (2^41)\ud06c\uae30\uc758 \ub370\uc774\ud130 \ud30c\uc77c \uc0dd\uc131\uc9c0\uc6d0 \n
  6. \ud6a8\uc728\uc801\uc778 \uba54\ubaa8\ub9ac \uc0ac\uc6a9 : 25k\ub77c\uc778\uc815\ub3c4\uc758 C\ucf54\ub4dc\ub85c \uc774\ub8e8\uc5b4\uc84c\ub2e4. \n
  7. \ub9ce\uc740 \uc77c\ubc18\uc801\uc778 \uba85\ub839\uc744 \uc2e4\ud589\ud558\ub294\ub370 PostgreSql\uacfc Mysql\ubcf4\ub2e4 \ucd5c\uc18c 2\ubc30\uc774\uc0c1 \uba85\ub839\uc5d0 \ub530\ub77c\uc11c 10-20\ubc30 \uc774\uc0c1 \ube60\ub974\ub2e4. \n
  8. \ud558\ub098\uc758 \uad6c\uc870\uccb4\uc640 3\uac1c\uc758 \ud568\uc218\ub9cc \uc0ac\uc6a9\ud558\ub294 \uc815\ub3c4\ub85c sqlite\ub97c \uc0ac\uc6a9\ud558\ub294 C\/C++ \ucf54\ub4dc\ub97c \ub9cc\ub4e4\uc5b4 \ub0bc \uc218 \uc788\ub2e4. \n
  9. TCL, Perl, PHP, .Net, Java, Python, SmallTalk, Ruby\ub4f1\uc758 \ub2e4\uc591\ud55c \uc5b8\uc5b4\uc9c0\uc6d0 \n
  10. \ub2e4\ub978 \ub77c\uc774\ube0c\ub7ec\ub9ac\ub4f1\uc758 \ub3c4\uc6c0\uc5c6\uc774 \uc791\ub3d9\ub41c\ub2e4. libsqlite.so\uc640 sqlite 2\uac1c\uc758 \ud30c\uc77c\uc774\uba74 \uc791\ub3d9 \ud658\uacbd\uc744 \ub9cc\ub4e4 \uc218 \uc788\ub2e4. \n
  11. Public Domain \ub77c\uc774\uc13c\uc2a4\ub97c \uac00\uc9c4\ub2e4. \n
  12. sqlite\ub294 \uc11c\ubc84\/\ud074\ub77c\uc774\uc5b8\ud2b8 \ubaa8\ub378\uc744 \uc9c0\uc6d0\ud558\ub294 RDBMS\uac00 \uc544\ub2c8\ub2e4. \ub85c\uceec\uc5d0\uc11c\ub9cc \uc0ac\uc6a9\uac00\ub2a5\ud558\uba70 \uc778\ud130\ub137\uc751\uc6a9\uc744 \uc6d0\ud55c\ub2e4\uba74 \ubcc4\ub3c4\uc758 \uc11c\ubc84 \ud504\ub85c\uadf8\ub7a8\uc744 \ub9cc\ub4e4\uc5b4\uc57c \ud55c\ub2e4. <\/LI><\/OL>\n

     <\/P><\/DIV>\n

    \n
    \n\n

    2.2\uc808. \uc124\uce58\ud558\uae30<\/A><\/H2>\n

    SQLite \ud648\ud398\uc774\uc9c0<\/A>\uc5d0\uc11c \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc744 \uc218 \uc788\ub2e4. \ud604\uc7ac(2003\/1\/08) sqlite-2.8.9.tar.gz \ubc84\uc83c\uc774 \ucd5c\uc2e0\ubc84\uc83c\uc774\ub2e4. \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc544\uc11c \uc555\ucd95\uae4c\uc9c0 \ud480\uace0 \ubcf4\ub2c8 4M\uc815\ub3c4 \ub418\ub294 \uc791\uc740 \ud06c\uae30\uc600\ub2e4. oracle\uc740 \ub9d0\ud560 \uac83\ub3c4 \uc5c6\uace0 \uc218\uc2ed\uba54\uac00\uc758 \ud06c\uae30\ub97c \uac00\uc9c0\ub294 postgresql\uc774\ub098 mysql\uc5d0 \ube44\ud574\uc11c\ub3c4 \ub9e4\uc6b0 \uc791\uc740 \ud06c\uae30\uc774\ub2e4. <\/P>\n

    rpm\ub3c4 \uc900\ube44\ub418\uc5b4 \uc788\uae30\ub294 \ud55c\ub370, \uc11c\ubc84 \ud504\ub85c\uadf8\ub7a8\ub4e4\uc740 \ubb34\uc870\uac74 \ucef4\ud30c\uc77c\ud574\uc11c \uc124\uce58\ud574\uc57c \ud558\ub294 \uc131\uaca9\uc774\ub77c tarball\uc744 \ubc1b\uc544\uc11c \ucef4\ud30c\uc77c \ud6c4 \uc124\uce58\ud558\uae30\ub85c \ud588\ub2e4. \ub2e4\uc74c\uc740 \ud544\uc790\uac00 \uc0ac\uc6a9\uc911\uc778 \ub9ac\ub205\uc2a4\ubc15\uc2a4\uc758 \uc0ac\uc591\uc774\ub2e4. <\/P>\n

    \ud45c 1. \uc2dc\uc2a4\ud15c \uc0ac\uc591<\/B> \n\n\n\n\n\n
    OS<\/TD>\nLinux<\/TD>\nKernel 2.6.0<\/TD><\/TR>\n
    \ucef4\ud30c\uc77c\ub7ec<\/TD>\ngcc<\/TD>\n2.96<\/TD><\/TR>\n
    cpu<\/TD>\nIntel 800MHZ<\/TD>\n\uc5c5\uadf8\ub808\uc774\ub4dc \uc2dc\ud0a4\uace0 \uc2f6\ub2e4.<\/TD><\/TR><\/TBODY><\/TABLE><\/DIV>\n

     <\/P>\n

    \uc124\uce58\ub294 \ub9e4\uc6b0 \uac04\ub2e8\ud558\ub2e4. <\/P>\n\n\n\n
    # wget http:\/\/www.hwaci.com\/sw\/sqlite\/sqlite-2.8.9.tar.gz
     # mv sqlite-2.8.9.tar.gz \/usr\/src
     # tar -xvzf sqlite-2.8.9.tar.gz
     # cd sqlite
     # .\/configure
     # make
     # make install<\/TD><\/TR><\/TBODY><\/TABLE>\n

    \uc635\uc158\uc5c6\uc774 \uc124\uce58\ud588\uc744 \uacbd\uc6b0 \/usr\/local \ubc11\uc5d0 \uc790\ub9ac\uc7a1\uac8c \ub41c\ub2e4. \uc774\uac78\ub85c \uc124\uce58 \ub05d\uc774\ub2e4. <\/P>\n

     <\/P><\/DIV><\/DIV>\n

    \n
    \n\n

    3\uc808. Sqlite \uac04\ub2e8 \uc6b4\uc6a9<\/A><\/H1>\n
    \n

    3.1\uc808. DB \uc0dd\uc131\ubc0f \uac04\ub2e8\ud55c \ub0b4\ubd80\uba85\ub839\uc5b4\ub4e4<\/A><\/H2>\n

    sqlite [dbname] \uc73c\ub85c \uac04\ub2e8\ud558\uac8c \uc0dd\uc131\ud560 \uc218 \uc788\ub2e4. \ub3d9\uc77c\ud55c \uc774\ub984\uc774 \uc874\uc7ac\ud558\uba74 \uc5f4\uace0 \uadf8\ub807\uc9c0 \uc54a\ub2e4\uba74 \uc0c8\ub85c \uc0dd\uc131\ud55c\ub2e4. <\/P>\n\n\n\n
    # sqlite test.db
     SQLite version 2.8.9
     Enter \".help\" for instructions
     sqlite> <\/TD><\/TR><\/TBODY><\/TABLE>\n

    \uadf8\ub2e4\uc74c \ubd80\ud130\ub294 \uc54c\uace0 \uc788\ub294 Sql query<\/B>\ub97c \uc774\uc6a9\ud574\uc11c \ud544\uc694\ud55c \uc791\uc5c5\uc744 \ud558\uba74 \ub41c\ub2e4. <\/P>\n\n\n\n
    sqlite> create table test(name char<\/A>(80), age int);
     sqlite> insert into test     values<\/A>(\"yundream\", 19);
     sqlite> insert into test     values<\/A>(\"hello world\", 29);
     sqlite> select * from test;
     yundream|19
     hello world|29<\/TD><\/TR><\/TBODY><\/TABLE>\n

    \ub0b4\ubd80\uba85\ub839\uc5b4\uc640 \uad00\ub828\ub41c \ub3c4\uc6c0\ub9d0\uc740 '''.help'''\ub97c \uc785\ub825\ud558\ub294 \uc815\ub3c4\ub85c \uac04\ub2e8\ud788 \ucc38\uc870\ud560 \uc218 \uc788\ub2e4. <\/P>\n

     <\/P>\n

      \n
    1. .databases : \ud604\uc7ac \uc791\uc5c5\uc911\uc778 DB\ud30c\uc77c\uacfc \uad00\ub828\ub41c \ub2e4\ub978 \ud30c\uc77c\ub4e4 \ubaa9\ub85d \ucd9c\ub825 \n
    2. .echo ON|OFF : \uba85\ub839\uc5b4\ub97c \ubc18\ud5a5 \ud560\uac74\uc9c0 \uc5ec\ubd80 \n
    3. .exit : \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc \n
    4. .help : \ub3c4\uc6c0\ub9d0 \n
    5. .schema ?TABLE? : \ud14c\uc774\ube14 \uad6c\uc870 \n
    6. .show : \ud604\uc7ac \ud504\ub85c\uadf8\ub7a8 \uc124\uc815\uac12\uc744 \ubcf4\uc5ec\uc900\ub2e4. \n
    7. .read FILENAME : FILENAME\uc73c\ub85c \ubd80\ud130 SQL\uc744 \uc2e4\ud589\ud55c\ub2e4. \n
    8. .output FILENAME : \ucd9c\ub825\uc744 FILENAME\uc73c\ub85c \ubcf4\ub0c4 \n
    9. .output stdout : \ucd9c\ub824\uc744 \ud654\uba74\uc73c\ub85c \ubcf4\ub0c4(\uae30\ubcf8 \uac12) \n
    10. .output stdout : \ucd9c\ub824\uc744 \ud654\uba74\uc73c\ub85c \ubcf4\ub0c4(\uae30\ubcf8 \uac12) <\/LI><\/OL>\n

       <\/P><\/DIV><\/DIV>\n

      \n
      \n\n

      4\uc808. C\/C++ Interface<\/A><\/H1>\n

      sqlite\ub294 \ub9e4\uc6b0 \uc27d\uac8c \uad00\ub828 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uc81c\uc791\ud560 \uc218 \uc788\ub3c4\ub85d \ub514\uc790\uc778\ub418\uc5b4 \uc788\ub2e4. \uc5ec\uae30\uc5d0\uc11c\ub294 sqlite C\/C++\ud504\ub85c\uadf8\ub798\ubc0d \ubc29\ubc95\uc5d0 \ub300\ud574\uc11c \uc54c\uc544 \ubcf4\uaca0\ub2e4. <\/P>\n

      \n
      \n\n

      4.1\uc808. \ud575\uc2ec API<\/A><\/H2>\n

      sqlite\ub294 3\uac1c\uc758 \ud575\uc2ec \ud568\uc218\uc640 \ud558\ub098\uc758 \uc790\ub8cc\uad6c\uc870\ub97c \uc81c\uacf5\ud55c\ub2e4. \uc774\uc678\uc5d0\ub3c4 \uba87\uac00\uc9c0 \ub9ac\ud134\uac12\uacfc \uc0c1\uc218\ub4e4\uc744 \uac00\uc9c0\uace0 \uc788\ub2e4. <\/P>\n\n\n\n
      typedef struct sqlite sqlite;
       #define SQLITE_OK
       
       sqlite *sqlite_open<\/A>(const char *dbname, int mode, char **errmsg);
       
       void       sqlite_close<\/A>(sqlite *db);
       
       int sqlite_exec
       (
         sqlite *db,
         char *sql,
         int (*      xCallback)<\/A>(void*,int,char**,char**),
         void *pArg,
         char **errmsg
       );<\/TD><\/TR><\/TBODY><\/TABLE>\n

      \uc704\uc758 \ub0b4\uc6a9\ub9cc \uc219\uc9c0\ud558\ub294 \uc815\ub3c4\ub85c C,C++\ud504\ub85c\uadf8\ub7a8\uc744 \ub9cc\ub4e4 \uc218 \uc788\ub2e4. <\/P>\n

       <\/P><\/DIV>\n

      \n
      \n\n

      4.2\uc808. DB \uc5f4\uae30<\/A><\/H2>\n

       <\/P>\n\n\n\n
      sqlite *sqlite_open<\/A>(const char *dbname, int mode, char **errmsg); <\/TD><\/TR><\/TBODY><\/TABLE>\n

      sqlite_open \ud568\uc218\ub97c \uc774\uc6a9\ud574\uc11c SQLite DB\ub97c \uc5f4\uac70\ub098 \uc0c8\ub85c\uc6b4 DB\ub97c \uc0dd\uc131\ud560 \uc218 \uc788\ub2e4. \uccab\ubc88\uc9f8 \uc778\uc790\ub294 DB\uc774\ub984\uc774\ub2e4. \ub450\ubc88\uc9f8 \uc778\uc790\ub294 \ud604\uc7ac \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294\ub2e4. DB\ub97c \uc5ec\ub294 \uc911\uc5d0 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud55c\ub2e4\uba74 errmsg\uc5d0 \uc5d0\ub7ec\uba54\uc2dc\uc9c0\ub97c \ucc44\uc6b0\uac8c \ub41c\ub2e4. \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\uc9c0 \uc54a\uc558\ub2e4\uba74 NULL\uc744 \uac00\ub9ac\ud0a8\ub2e4. <\/P>\n

       <\/P>\n

       <\/P><\/DIV>\n

      \n
      \n\n

      4.3\uc808. DB\ub2eb\uae30<\/A><\/H2>\n

      sqlite_close<\/A>()\ud568\uc218\ub97c \ud638\ucd9c\ud558\uba74 \ub41c\ub2e4. \uc778\uc790\ub85c\ub294 sqlite_open<\/A>()\uc73c\ub85c \uc0dd\uc131\ub41c sqlite \uad6c\uc870\uccb4 \ud3ec\uc778\ud130\uac00 \ub4e4\uc5b4\uac04\ub2e4. sqlite_close<\/A>()\ub97c \ud638\ucd9c\ud588\uc744 \ub54c \ud2b8\ub79c\uc7ad\uc158<\/A>(transaction)\uc774 \ud65c\uc131\ud654 \ub418\uc5b4 \uc788\ub294 \uc0c1\ud0dc\ub77c\uba74 \uc774 \ud2b8\ub79c\uc7ad\uc158\uc740 rolled back \ud558\uac8c \ub41c\ub2e4. <\/P><\/DIV>\n

      \n
      \n\n

      4.4\uc808. SQL \uc2e4\ud589<\/A><\/H2>\n

      sqlite_exec<\/A>()\ub97c \uc774\uc6a9\ud574\uc11c SQL\ucffc\ub9ac\uc640 \uac01\uc885 \uba85\ub839\uc744 \uc218\ud589\ud560 \uc218 \uc788\ub2e4. \uc774 \ud568\uc218\ub294 5\uac1c\uc758 \uc778\uc790\ub97c \uac00\uc9c4\ub2e4. <\/P>\n

       <\/P>\n

        \n
      1. sqlite_open<\/A>()\uc5d0 \uc758\ud574\uc11c \ub9cc\ub4e4\uc5b4\uc9c4 sqlite\uad6c\uc870\uccb4 \ud3ec\uc778\ud130\ub2e4. \n
      2. sql \ucffc\ub9ac\uc640 sql \uba85\ub839\uc744 \uc704\ud55c \ubb38\uc790\uc5f4\uc774 \ub4e4\uc5b4\uac04\ub2e4. \uc774 \ubb38\uc790\uc5f4\uc740 null\ub85c \ub05d\ub09c\ub2e4. \n
      3. \ucf5c\ubc31\ud568\uc218\ub85c\uc368 \ucffc\ub9ac\uc758 \uacb0\uacfc\ub97c \ucc98\ub9ac\ud558\uae30 \uc704\ud574\uc11c \ud638\ucd9c \ub41c\ub2e4. NULL \uc774\ub77c\uba74 \uc544\ubb34\uc77c\ub3c4 \ud558\uc9c0 \uc54a\uac8c \ub41c\ub2e4. \n
      4. \ucf5c\ubc31\ud568\uc218\ub85c \ub118\uaca8\uc904 \uc778\uc790\uc758 \ucc98\uc74c\uc744 \uac00\ub974\ud0a4\ub294 \ud3ec\uc778\ud130\ub2e4. \n
      5. \uc5d0\ub7ec\uba54\uc2dc\uc9c0\ub97c \uac00\ub974\ud0a4\ub294 \ud3ec\uc778\ud130\ub2e4. \uc774 \ud3ec\uc778\ud130\ub294 malloc<\/A>()\ub4f1\uc744 \uc774\uc6a9\ud574\uc11c \ud560\ub2f9\ub41c \uacf5\uac04\uc5d0 \uc50c\uc5ec\uc9c0\uba70 \ud568\uc218\uac00 \uc885\ub8cc\ub418\uba74 free<\/A>() \ub41c\ub2e4. NULL\uc774\ub77c\uba74 \uc5b4\ub5a4 \uc5d0\ub7ec\uba54\uc2dc\uc9c0\ub3c4 \ubcf4\uace0\ub418\uc9c0 \uc54a\uc744 \uac83\uc774\ub2e4. <\/LI><\/OL>\n

         <\/P>\n

        \ucf5c\ubc31<\/A>(callback)\ud568\uc218\ub294 \ucffc\ub9ac\uc758 \uacb0\uacfc\ub97c \ubc1b\uae30 \uc704\ud574\uc11c \uc0ac\uc6a9\ub41c\ub2e4. \ucf5c\ubc31\ud568\uc218\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \uc120\uc5b8\ub418\uc5b4 \uc788\ub2e4. <\/P>\n\n\n\n
        int Callback<\/A>(void *pArg, int argc, char **argv, char **columnNames))
         {
             return 0;
         }<\/TD><\/TR><\/TBODY><\/TABLE>\n

        \ucf5c\ubc31\ud568\uc218\uc758 \uccab\ubc88\uc9f8 \uc778\uc790\ub294 sqlite_exec<\/A>()\uc758 \ub124\ubc88\uc9f8 \uc544\uaddc\uba3c\ud2b8\uc758 \ubcf5\uc0ac\ub2e4. \uc774 \uc778\uc790\ub294 \ud074\ub77c\uc774\uc5b8\ud2b8 \ucf54\ub4dc\ub85c \ubd80\ud130 \ucf5c\ubc31\ud568\uc218\ub85c \uc784\uc758\uc758 \uc815\ubcf4\ub97c \uc804\ub2ec\ud558\uae30 \uc704\ud574\uc11c \uc0ac\uc6a9\ub418\uc5b4 \uc9c4\ub2e4. \ub450\ubc88\uc9f8 \uc778\uc790\ub294 \ucffc\ub9ac\uacb0\uacfc \uc0dd\uc131\ub41c \uceec\ub7fc<\/A>(columns)\uc758 \uac2f\uc218\uc774\ub2e4. \uc138\ubc88\uc9f8 \uc544\uaddc\uba3c\ud2b8\ub294 \uceec\ub7fc\uc758 \uc2e4\uc81c \ub0b4\uc6a9\uc744 \ub2f4\uace0 \uc788\uc73c\uba70 \ud558\ub098\uc758 \uceec\ub7fc \ub0b4\uc6a9\uc740 \ud558\ub098\uc758 \ubc30\uc5f4\uc5d0 \ub300\uc751\ud55c\ub2e4. \ub124\ubc88\uc9f8 \uc778\uc790\ub294 \uceec\ub7fc\uc758 \uc774\ub984\uc774\ub2e4. <\/P>\n

         <\/P>\n

        \ucf5c\ubc31\ud568\uc218\ub294 \uc815\uc0c1\uc801\uc73c\ub85c \uc218\ud589\ub418\uc5c8\uc744 \uacbd\uc6b0 0\uc744 \ub9ac\ud134\ud55c\ub2e4. \ub9cc\uc57d \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud55c\ub2e4\uba74 0\uc774 \uc544\ub2cc \uac12\uc744 \ub9ac\ud134\ud558\uace0 \ucffc\ub9ac\ub294 \ucde8\uc18c\ub41c\ub2e4. \uc774\uacbd\uc6b0 sqlite_exe<\/A>()\ub294 SQLITE_ABORT<\/B>\ub97c \ub9ac\ud134\ud560 \uac83\uc774\ub2e4. <\/P><\/DIV>\n

        \n
        \n\n

        4.5\uc808. \uc5d0\ub7ec \ucf54\ub4dc<\/A><\/H2>\n

        \uc815\uc0c1\uc801\uc73c\ub85c \uc2e4\ud589\ub418\uc5c8\uc744 \uacbd\uc6b0 sqlite_exec<\/A>()\ud568\uc218\ub294 SQLITE_OK\ub97c \ub9ac\ud134\ud55c\ub2e4. \uadf8\ub807\uc9c0 \uc54a\uc744\uacbd\uc6b0 \ub2e4\uc74c\uacfc \uac19\uc740 \uc5d0\ub7ec \ucf54\ub4dc\ub4e4\uc744 \ub9ac\ud134\ud55c\ub2e4. <\/P>\n\n\n\n
        #define SQLITE_OK           0   \/* Successful result *\/
         #define SQLITE_ERROR        1   \/* SQL error or missing database *\/
         #define SQLITE_INTERNAL     2   \/* An internal logic error in SQLite *\/
         #define SQLITE_PERM         3   \/* Access permission denied *\/
         #define SQLITE_ABORT        4   \/* Callback routine requested an abort *\/
         #define SQLITE_BUSY         5   \/* The database file is locked *\/
         #define SQLITE_LOCKED       6   \/* A table in the database is locked *\/
         #define SQLITE_NOMEM        7   \/* A <\/FONT>malloc<\/FONT><\/A>() failed *\/
         #define SQLITE_READONLY     8   \/* Attempt to write a readonly database *\/
         #define SQLITE_INTERRUPT    9   \/* Operation terminated by <\/FONT>        sqlite_interrupt<\/FONT><\/A>() *\/
         #define SQLITE_IOERR       10   \/* Some kind of disk I\/O error occurred *\/
         #define SQLITE_CORRUPT     11   \/* The database disk image is malformed *\/
         #define SQLITE_NOTFOUND    12   \/* (Internal Only) Table or record not found *\/
         #define SQLITE_FULL        13   \/* Insertion failed because database is full *\/
         #define SQLITE_CANTOPEN    14   \/* Unable to open the database file *\/
         #define SQLITE_PROTOCOL    15   \/* Database lock protocol error *\/
         #define SQLITE_EMPTY       16   \/* (Internal Only) Database table is empty *\/
         #define SQLITE_SCHEMA      17   \/* The database schema changed *\/
         #define SQLITE_TOOBIG      18   \/* Too much data for one row of a table *\/
         #define SQLITE_CONSTRAINT  19   \/* Abort due to contraint violation *\/
         #define SQLITE_MISMATCH    20   \/* Data type mismatch *\/
         #define SQLITE_MISUSE      21   \/* Library used incorrectly *\/
         #define SQLITE_NOLFS       22   \/* Uses OS features not supported on host *\/
         #define SQLITE_AUTH        23   \/* Authorization denied *\/
         #define SQLITE_ROW         100  \/* <\/FONT>        sqlite_step<\/FONT><\/A>() has another row ready *\/
         #define SQLITE_DONE        101  \/* <\/FONT>        sqlite_step<\/FONT><\/A>() has finished executing *\/<\/FONT><\/TD><\/TR><\/TBODY><\/TABLE>\n

        \ub2e4\uc74c\uc740 \uac01 \uc5d0\ub7ec\ucf54\ub4dc\ub4e4\uc5d0 \ub300\ud55c \uc124\uba85\uc774\ub2e4. <\/P>\n

         <\/P>\n

        \n
        \n
        SQLITE_OK \n
        \uba85\ub839\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \uc218\ud589\ub418\uc5c8\ub2e4. \n
        SQLITE_INTERMAL \n
        SQLite library\uc758 \ub0b4\ubd80\uc801\uc778 \ubb38\uc81c\ub85c \ubc1c\uc0dd\ud558\ub294\ub370, SQLite \ub77c\uc774\ube0c\ub7ec\ub9ac\uc758 \ubc84\uadf8\uc5d0 \uc758\ud574\uc11c\ub9cc \ubc1c\uc0dd\ub41c\ub2e4\uace0 \ub418\uc5b4 \uc788\ub2e4. \ub9cc\uc57d \uc774 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud588\ub2e4\uba74 SQLite mailing list\uc5d0 \ubb38\uc81c\ub97c \ubcf4\uace0\ud558\uae30 \ubc14\ub780\ub2e4. \n
        SQLITE_ERROR \n
        SQL\uc5d0 \ubb38\uc81c\uac00 \uc788\uc744 \uacbd\uc6b0 \ubc1c\uc0dd\ub41c\ub2e4. \n
        SQLITE_PERM \n
        \ub370\uc774\ud130\ud398\uc774\uc2a4 \ud30c\uc77c\uc744 \uc5f4\uae30\uc704\ud55c \uad8c\ud55c\uc774 \uc5c6\uc744 \uacbd\uc6b0 \ubc1c\uc0dd\ud55c\ub2e4. \n
        SQLITE_ABORT \n
        \ucf5c\ubc31\ud568\uc218\uac00 0\uc774 \uc544\ub2cc \uac12\uc744 \ub9ac\ud134\ud588\uc744 \ub54c \ubc1c\uc0dd\ud55c\ub2e4. \n
        SQLITE_BUSY \n
        \ub2e4\ub978 \ud504\ub85c\uadf8\ub7a8\uc774\ub098 \uc4f0\ub808\ub4dc\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\uace0 \uc788\uc744 \ub54c \ubc1c\uc0dd\ud55c\ub2e4. SQLite\ub294 \ud558\ub098\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub3d9\uc2dc\uc5d0 \ub450\uac1c\ub098 \uadf8 \uc774\uc0c1\uc758 \uc4f0\ub808\ub4dc\uac00 \uc77d\ub294 \uac83\uc744 \ud5c8\uc6a9\ud55c\ub2e4. \uadf8\ub7ec\ub098 \uc4f0\uae30\uc704\ud574\uc11c \uc5f4\uc5c8\uc744 \uacbd\uc6b0\uc5d0\ub294 \ub2e8\uc9c0 \ud558\ub098\ub9cc\uc758 \uc4f0\ub808\ub4dc\ub9cc\uc774 \uc811\uadfc\uc774 \uac00\ub2a5\ud558\ub2e4. \n
        SQLITE_NOMEM \n
        malloc<\/A>()\uc5d0 \uc2e4\ud328\ud588\uc744 \ub54c \ub9ac\ud134\ud55c\ub2e4. \n
        SQLITE_READONLY \n
        \ub2e8\uc9c0 \uc77d\uae30\ub9cc \uac00\ub2a5\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4(\ud639\uc740 \uc77d\uae30 \uc804\uc6a9\uc73c\ub85c \uc5f0) \ud30c\uc77c\uc5d0 \uc4f0\ub824\uace0 \ud588\uc744 \ub54c \ubc1c\uc0dd\ud55c\ub2e4. \n
        SQLITE_FULL \n
        \ub514\uc2a4\ud06c\uc5d0 \ub354\uc774\uc0c1\uc758 \uacf5\uac04\uc774 \uc5c6\uac70\ub098 \ub370\uc5b4\ud130\ubca0\uc774\uc2a4 \ud30c\uc77c\uc774 \ub108\ubb34\ub098 \ud074\uacbd\uc6b0 \ubc1c\uc0dd\ud55c\ub2e4. \n
        SQLITE_AUTH \n
        \uc778\uc99d\uc5d0 \uc2e4\ud328\ud588\ub2e4. <\/DD><\/DL><\/DIV>\n

         <\/P><\/DIV>\n

        \n
        \n\n

        4.6\uc808. \uc608\uc81c \ud504\ub85c\uadf8\ub7a8<\/A><\/H2>\n

        \uc9c0\uae08\uae4c\uc9c0\uc758 \ub0b4\uc6a9\ub4e4\uc744 \uc774\uc6a9\ud574\uc11c sqlite \ub370\uc774\ud130 \ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ud574\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub294 \uac04\ub2e8\ud55c \ud504\ub85c\uadf8\ub7a8\uc744 \ub9cc\ub4e4\uc5b4 \ubcf4\ub3c4\ub85d \ud558\uaca0\ub2e4. <\/P>\n\n\n\n
        #include <stdio.h>
         #include <sqlite.h>
         
         static int callback<\/A>(void *NU, int argc, char **argv, char **azColName)
         {
             int i;
             for (i = 0; i < argc; i++)
             {
                 printf (\"%s = %s\\n\", azColName[i], argv[i] ? argv[i] : \"NULL\");
             }
                     printf<\/A>(\"\\n\");
             return 0;
         }
         int         main<\/A>(int argc, char **argv)
         {
             sqlite *db;
             char *ErrMsg = 0;
             int rc;
         
             if (argc != 3)
             {
                 fprintf(stderr, \"Usge : .\/testsql [dbname] [query]\\n\");
                         exit<\/A>(0);
             }
             db = sqlite_open(argv[1], 0, &ErrMsg);
             if (db == 0)
             {
                 fprintf(stderr, \"Cant open database ; %s\\n\", ErrMsg);
                         exit<\/A>(0);
             }
             rc = sqlite_exec(db, argv[2], callback, 0, &ErrMsg);
             if (rc != SQLITE_OK)
             {
                 fprintf(stderr, \"SQL error : %d\\n\", ErrMsg);
             }
                     sqlite_close<\/A>(db);
             return 0;
         }<\/TD><\/TR><\/TBODY><\/TABLE>\n

        \ud504\ub85c\uadf8\ub7a8\uc758 \uc774\ub984\uc740 testsql<\/B>\ub85c \ud558\uaca0\ub2e4. \ub2e4\uc74c\uacfc \uac19\uc774 \ucef4\ud30c\uc77c\ud6c4 \ud14c\uc2a4\ud2b8 \ud574\ubcf4\uae30 \ubc14\ub780\ub2e4. <\/P>\n\n\n\n
        # gcc -o testsql testsql.c -L\/usr\/local\/lib -lsqlite <\/TD><\/TR><\/TBODY><\/TABLE>\n

        \ub2e4\uc74c\uc740 \ud14c\uc2a4\ud2b8 \uacb0\uacfc\ub2e4 <\/P>\n\n\n\n
        # .\/testsql test.db \"select * from test\"
         name = yundream
         age = 19
         
         name = hello
         age = 22
         # .\/testsql test.db \"insert into test values<\/A>(\\\"kknd\\\", 56);\"
         # .\/testsql test.db \"select * from test\"
         name = yundream
         age = 19
         
         name = hello
         age = 22
         
         name = kknd
         age = 56<\/TD><\/TR><\/TBODY><\/TABLE>\n

        \uace0\uc791 38\ub77c\uc778 \uc815\ub3c4\ub85c \uc81c\ub300\ub85c \uc791\ub3d9\ud558\ub294 DB \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uc791\uc131\ud588\ub2e4. <\/P>\n

         <\/P><\/DIV><\/DIV>\n

        \n
        \n\n

        5\uc808. \ucf5c\ubc31\ud568\uc218\ub97c \uc774\uc6a9\ud558\uc9c0 \uc54a\ub294 \ub370\uc774\ud130 \uc811\uadfc<\/A><\/H1>\n

        sqlite_exec<\/A>() \ud568\uc218\ub294 SQLite \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \ubd80\ud130 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uae30 \uc704\ud55c \ub2e8\uc9c0 \ud55c \uac00\uc9c0 \ubc29\ubc95\ub9cc\uc744 \uc81c\uacf5\ud55c\ub2e4. \ubc29\ubc95\uc774 \uc81c\ud55c\ub418\uc5b4 \uc788\uc73c\ub2c8 \uc774\uac83 \uc800\uac83 \uc2e0\uacbd\uc2a4\uc9c0 \uc54a\uace0 \uac04\ub2e8\ud558\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\uaca0\uc73c\ub098 \ub9ce\uc740 \ud504\ub85c\uadf8\ub798\uba38\ub4e4\uc774 \ucf5c\ubc31\ud568\uc218\ub97c \uc774\uc6a9\ud574\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\ub294 \uac83\uc5d0 \ub9cc\uc871\ud558\uc9c0 \uc54a\uc744 \uc218\ub3c4 \uc788\ub2e4. \uc774\ub7f0 \uc774\uc720\ub85c SQLite 2.7.7\uc774\ud6c4 \ubc84\uc804\uc5d0\uc11c\ub294 \ucf5c\ubc31\ud568\uc218\uac00 \uc544\ub2cc \ub2e4\ub978 \ubc29\ubc95\uc744 \ud1b5\ud574\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc62c \uc218 \uc788\ub3c4\ub85d \uc9c0\uc6d0\ud568\uc218\ub97c \ucd94\uac00\ud588\ub2e4. <\/P>\n

        3\uac1c\uc758 \uc0c8\ub85c\uc6b4 \ud568\uc218\uac00 \ucd94\uac00\ub418\uc5c8\ub294\ub370, sqlite_exec<\/A>()\uc758 \uae30\ub2a5\uc744 3\uac1c\ub85c \ub098\ub204\uc5b4\uc11c \uc880\ub354 \uc138\ubc00\ud558\uac8c \uc81c\uc5b4\ud560 \uc218 \uc788\ub3c4\ub85d \uae30\ub2a5\uc744 \ubd84\ud560 \ud588\ub2e4\uace0 \ubcf4\uba74 \ub41c\ub2e4. <\/P>\n\n\n\n
        typedef struct sqlite_vm sqlite_vm;     
         
         int sqlite_compile
         (
             sqlite *db,          \/* \uc5f4\ub9b0 \ub370\uc774\ud130 \ubca0\uc774\uc2a4 *\/
             const char *zSql,    \/* SQL statement to be compiled *\/
             const char **pzTail, \/* OUT: uncompiled tail of zSql *\/
             sqlite_vm **ppVm,    \/* OUT: the virtual machine to execute zQsql *\/
             char **pzErrmsg      \/* OUT: Error message *\/
         );
         
         int sqlite_step
         (
             sqlite_vm *pVm,           \/* The virtual machine to exeucte *\/
             int *pN,                  \/* OUT: Number of columns in result *\/
             const char ***pazValue,   \/* OUT: Column data *\/
             const char ***pszColName  \/* OUT: Column names and datatypes *\/
         );
         
         int sqlite_finalize
         (
             sqlite_vm *pVm,        \/* The virtual machine to be finalized *\/
             char **pzErrMsg        \/* OUT: Error message *\/
         );<\/TD><\/TR><\/TBODY><\/TABLE>\n

         <\/P><\/DIV>\n

        \n
        \n\n

        6\uc808. \ucc38\uace0\ubb38\ud5cc<\/A><\/H1>\n

         <\/P>\n

         <\/P>\n

          \n
        1. sqlite \ud648\ud398\uc774\uc9c0<\/A> \n
        2. SWLite Windows<\/A> \n
        3. SQLiteDBMS \ud504\ub85c\uc81d\ud2b8<\/A> <\/LI><\/OL><\/DIV>\n","protected":false},"excerpt":{"rendered":"

          Sqlite \ud504\ub85c\uadf8\ub798\ubc0d \uc724\uc0c1\ubc30                 yundream@join.co.kr            \uad50\uc815 \uacfc\uc815 \uad50\uc815 0.9 2004\ub144 2\uc6d4 16\uc77c 8\uc2dc   \ucc38\uace0\ubb38\ud5cc\ubc0f \uc0ac\uc774\ud2b8 \ucd94\uac00 \uad50\uc815 0.8 2004\ub144 1\uc6d4 09\uc77c 20\uc2dc   \ucd5c\ucd08 \ubb38\uc11c\uc791\uc131 \ucc28\ub840 1\uc808. \uc18c\uac1c 2\uc808. Sqlite 2.1\uc808. Sqlite\uc758 \ud2b9\uc9d5 2.2\uc808. \uc124\uce58\ud558\uae30 3\uc808. Sqlite \uac04\ub2e8 \uc6b4\uc6a9 3.1\uc808. DB \uc0dd\uc131\ubc0f […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[19],"tags":[],"class_list":["post-63","post","type-post","status-publish","format-standard","hentry","category-development_lib"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/63","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=63"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/63\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=63"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=63"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=63"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}