首页

投稿

HighPerformanceSQLite - High Performance SQLite 2024-9

4605

1

2024-11-04 23:45:52

https://highperformancesqlite.com/ 课程资料：度盘/s/1QzdcGiWszghQpZDRgamzVA?pwd=av7s 提取码: av7s

HighPerformanceSQLit

空白得很发消息

01. Introduction to this course

04:33

02. Introduction to SQLite

05:12

03. SQLite is safe

03:04

04. It's just a file

03:17

05. Running SQLite locally

02:56

06. Good uses for SQLite

06:23

07. SQLite's limitations

03:52

08. The documentation

02:28

09. SQLite's structure

04:39

10. SQLite's file format

03:52

11. Dot commands

09:22

12. Pragmas

06:10

13. Virtual tables

03:48

14. Flexible types

05:43

15. Types

10:26

16. Strict types

05:41

17. Dates

07:59

18. Booleans

01:02

19. Floating point

07:27

20. Rowid tables

11:02

21. Auto increments

06:47

22. Without rowid

03:26

23. Generated columns

06:49

24. Locking

04:30

25. Rollback mode

04:16

26. WAL mode

04:13

27. WAL vs Journal benchmarks

05:37

28. Busy timeout

04:29

29. Transaction modes

04:22

30. Vacuum

06:48

31. Analyze & Optimize

05:16

32. Suggested pragmas

05:23

33. Faster inserts

01:32

34. Introduction to indexes

05:33

35. B+ trees

05:01

36. Primary, secondary, and clustered indexes

08:07

37. Without rowid tables

01:56

38. Benchmarking without rowid tables

07:04

39. Imposter tables

03:24

40. Primary key data types

04:02

41. Where to add indexes

11:43

42. Index selectivity

09:14

43. Composite indexes

11:38

44. Composite ordering

03:01

45. Covering indexes

09:34

46. Partial indexes

08:07

47. Indexes on expressions

05:02

48. Automatic indexes

04:23

49. Duplicate indexes

06:17

50. Indexing joins

08:32

51. Explain

06:14

52. Index obfuscation

03:47

53. Joins

09:02

54. Subqueries

11:38

55. Unions

06:37

56. CTEs

03:48

57. Recursive CTEs

09:26

58. Window functions

10:53

59. Dealing with NULLs

03:36

60. Row value syntax

10:12

61. Indexed sorting

06:12

62. Upserts

07:56

63. Returning

03:34

64. Aggregates

09:59

65. Triggers

05:30

66. Altering schema

10:57

67. Altering schema with tools

04:24

68. Multi-database

02:20

69. Multi-tenancy

11:34

70. Backups

04:26

71. Exports

05:37

72. How to corrupt SQLite

03:04

73. Intro to JSON

03:40

74. JSON vs. JSONB

05:07

75. Argument types- path, value, JSON

09:19

76. JSON5

03:21

77. Valid JSON

07:13

78. Creating JSON objects + arrays

02:43

79. JSON Extraction

06:47

80. Updating JSON

07:11

81. JSON aggregates

05:14

82. JSON table functions

07:43

83. Indexing JSON

07:49

84. Creating FTS tables

13:56

85. Performing searches

10:45

86. Ranking results

05:58

87. Highlighting matches

05:52

88. DHH discusses SQLite in Ruby on Rails

54:00

89. Distributed SQLite with Litestream and LiteFS

54:37

90. Offline-first, multiplayer SQLite

01:21:25

91. Production SQLite with Turso and libSQL

01:02:53

92. DHH discusses SQLite in Ruby on Rails_2

54:00

93. Ruby on Rails with SQLite

01:22:40

顶部