ProHoster > Блог > ozi ịntanetị > Mwepụta nke DBMS SQLite 3.44

Mwepụta nke DBMS SQLite 3.44

Ntọhapụ nke SQLite 3.44, DBMS dị fechaa emebere dị ka ọba akwụkwọ nkwụnye, ka ebipụtala. A na-ekesa koodu SQLite dịka ngalaba ọha, ya bụ. enwere ike iji ya na-enweghị mgbochi yana n'efu maka ebumnuche ọ bụla. Nkwado ego maka ndị mmepe SQLite bụ ụlọ ọrụ emebere nke ọma, nke gụnyere ụlọ ọrụ dịka Bentley, Bloomberg, Expensify na Data Standard Navigation.

Isi mgbanwe:

  • Ọrụ mkpokọta na-enye ohere nkebiokwu "ORDER BY" ka emechara oke ikpeazụ iji hazie arụmụka ọrụ n'usoro akọwapụtara, nke nwere ike ịba uru maka ọrụ dịka string_agg() na json_group_array().
  • Nkwado agbakwunyere maka ọrụ SQL scalar concat () na concat_ws(), dakọtara na PostgreSQL, MS SQL Server na MySQL.
  • Nkwado agbakwunyere maka ọrụ mkpokọta string_agg(), dakọtara na PostgreSQL na MS SQL Server.
  • Nkwado agbakwunyere maka nkọwapụta "%e", "%F", "%I", "%k", "%l", "%p", "%P", "%R" na ọrụ SQL strftime ( ) "%T" na "%u".
  • Ọtụtụ njehie jikọtara na nkwupụta CREATE TABLE bụ ugbu a ka emechara nkwupụta CREATE TABLE, karịa ka ejiri tebụl mee ihe na nke mbụ.
  • Iwu "PRAGMA integrity_check" na-arụ ọrụ ịlele ịdị n'otu nke ọdịnaya nke tebụl mebere arụnyere na FTS3, FTS4, FTS5, RTREE na GEOPOLY.
  • Tebụlụ mebere arụnyere arụnyere na FTS3, FTS4, FTS5, RTREE na GEOPOLY ndọtị ka a na-ahapụ ka eji mee ihe n'ime ihe na-akpalite.
  • Mgbe ị na-akọwa ntọala SQLITE_DBCONFIG_DEFENSIVE, a na-enye nchebe megide ime ka ọnọdụ “PRAGMA writable_schema”.
  • Mgbe ejikọtara ya na Microsoft C compiler, a na-akwado ntọala SQLITE_USE_SEH (Structured Exception Handling) na ndabara.
  • Emeela ihe kachasị mma na onye na-eme atụmatụ ajụjụ metụtara nyocha nke akụkụ index mgbe a na-akọwa uru mgbe niile maka kọlụm tebụl n'ime ahịrịokwu WHERE. N'ihi nrụgharị achọpụtara, njikarịcha nyocha nyocha agbakwunyere na ụdị 3.42.0 agbanyụrụ.
  • Na-enye nkwenye oge ịgba ọsọ nke nkwado usoro maka ụdị "ogologo okpukpu abụọ" na nke ziri ezi dị elu karịa nke ụdị "okpukpu abụọ".
  • N'ime iwu Windows interface, UTF-8 na-akwado ntinye koodu site na ndabara maka ntinye na mmepụta (nhọrọ "--no-utf8" ka enyere iji gbanyụọ ya).

isi: opennet.ru

Tinye a comment