Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай High Performance SQLite, а также все другие курсы, прямо сейчас!
Премиум
  • Урок 1. 00:04:33
    01. Introduction to this course
  • Урок 2. 00:05:12
    02. Introduction to SQLite
  • Урок 3. 00:03:04
    03. SQLite is safe
  • Урок 4. 00:03:17
    04. It's just a file
  • Урок 5. 00:02:56
    05. Running SQLite locally
  • Урок 6. 00:06:23
    06. Good uses for SQLite
  • Урок 7. 00:03:52
    07. SQLite's limitations
  • Урок 8. 00:02:28
    08. The documentation
  • Урок 9. 00:04:39
    09. SQLite's structure
  • Урок 10. 00:03:52
    10. SQLite's file format
  • Урок 11. 00:09:22
    11. Dot commands
  • Урок 12. 00:06:10
    12. Pragmas
  • Урок 13. 00:03:48
    13. Virtual tables
  • Урок 14. 00:05:43
    14. Flexible types
  • Урок 15. 00:10:26
    15. Types
  • Урок 16. 00:05:41
    16. Strict types
  • Урок 17. 00:07:59
    17. Dates
  • Урок 18. 00:01:02
    18. Booleans
  • Урок 19. 00:07:27
    19. Floating point
  • Урок 20. 00:11:02
    20. Rowid tables
  • Урок 21. 00:06:47
    21. Auto increme
  • Урок 22. 00:03:26
    22. Without rowid
  • Урок 23. 00:06:49
    23. Generated columns
  • Урок 24. 00:04:30
    24. Locking
  • Урок 25. 00:04:16
    25. Rollback mode
  • Урок 26. 00:04:13
    26. WAL mode
  • Урок 27. 00:05:37
    27. WAL vs Journal benchmarks
  • Урок 28. 00:04:29
    28. Busy timeout
  • Урок 29. 00:04:21
    29. Transaction modes
  • Урок 30. 00:06:48
    30. Vacuum
  • Урок 31. 00:05:16
    31. Analyze & Optimize
  • Урок 32. 00:05:23
    32. Suggested pragmas
  • Урок 33. 00:01:32
    33. Faster inse
  • Урок 34. 00:05:33
    34. Introduction to indexes
  • Урок 35. 00:05:01
    35. B+ trees
  • Урок 36. 00:08:07
    36. Primary, secondary, and clustered indexes
  • Урок 37. 00:01:56
    37. Without rowid tables
  • Урок 38. 00:07:04
    38. Benchmarking without rowid tables
  • Урок 39. 00:03:24
    39. Imposter tables
  • Урок 40. 00:04:02
    40. Primary key data types
  • Урок 41. 00:11:43
    41. Where to add indexes
  • Урок 42. 00:09:14
    42. Index selectivity
  • Урок 43. 00:11:38
    43. Composite indexes
  • Урок 44. 00:03:01
    44. Composite ordering
  • Урок 45. 00:09:33
    45. Covering indexes
  • Урок 46. 00:08:07
    46. Partial indexes
  • Урок 47. 00:05:02
    47. Indexes on expressions
  • Урок 48. 00:04:23
    48. Automatic indexes
  • Урок 49. 00:06:17
    49. Duplicate indexes
  • Урок 50. 00:08:32
    50. Indexing joins
  • Урок 51. 00:06:14
    51. Explain
  • Урок 52. 00:03:47
    52. Index obfuscation
  • Урок 53. 00:09:01
    53. Joins
  • Урок 54. 00:11:38
    54. Subqueries
  • Урок 55. 00:06:37
    55. Unions
  • Урок 56. 00:03:48
    56. CTEs
  • Урок 57. 00:09:26
    57. Recursive CTEs
  • Урок 58. 00:10:53
    58. Window functions
  • Урок 59. 00:03:36
    59. Dealing with NULLs
  • Урок 60. 00:10:12
    60. Row value syntax
  • Урок 61. 00:06:12
    61. Indexed sorting
  • Урок 62. 00:07:56
    62. Upse
  • Урок 63. 00:03:34
    63. Returning
  • Урок 64. 00:09:59
    64. Aggregates
  • Урок 65. 00:05:29
    65. Triggers
  • Урок 66. 00:10:57
    66. Altering schema
  • Урок 67. 00:04:24
    67. Altering schema with tools
  • Урок 68. 00:02:20
    68. Multi-database
  • Урок 69. 00:11:34
    69. Multi-tenancy
  • Урок 70. 00:04:26
    70. Backups
  • Урок 71. 00:05:37
    71. Expo
  • Урок 72. 00:03:04
    72. How to corrupt SQLite
  • Урок 73. 00:03:40
    73. Intro to JSON
  • Урок 74. 00:05:07
    74. JSON vs. JSONB
  • Урок 75. 00:09:19
    75. Argument types- path, value, JSON
  • Урок 76. 00:03:20
    76. JSON5
  • Урок 77. 00:07:13
    77. Valid JSON
  • Урок 78. 00:02:43
    78. Creating JSON obje + arrays
  • Урок 79. 00:06:47
    79. JSON Extraction
  • Урок 80. 00:07:11
    80. Updating JSON
  • Урок 81. 00:05:14
    81. JSON aggregates
  • Урок 82. 00:07:43
    82. JSON table functions
  • Урок 83. 00:07:49
    83. Indexing JSON
  • Урок 84. 00:13:56
    84. Creating tables
  • Урок 85. 00:10:45
    85. Performing searches
  • Урок 86. 00:05:58
    86. Ranking resu
  • Урок 87. 00:05:52
    87. Highlighting matches
  • Урок 88. 00:54:00
    88. DHH discusses SQLite in Ruby on Rails
  • Урок 89. 00:54:37
    89. Distributed SQLite with Litestream and LiteFS
  • Урок 90. 01:21:25
    90. Offline-first, multiplayer SQLite
  • Урок 91. 01:02:53
    91. Production SQLite with Turso and libSQL
  • Урок 92. 00:54:00
    92. DHH discusses SQLite in Ruby on Rails
  • Урок 93. 01:22:39
    93. Ruby on Rails with SQLite