OurBigBook
OurBigBook Web development
OurBigBook Project
OurBigBook Web
toc
nosplit
words:
7k
articles:
68
Table of contents
7k
68
1. Local development server
link
nosplit
OurBigBook Web development
486
2. Generated data
link
nosplit
OurBigBook Web development
738
3
2.1. Wikipedia bot (wikibot)
link
nosplit
Generated data
395
2.2. Demo data
link
nosplit
Generated data
343
1
2.2.1. Demo data local file output
link
nosplit
Demo data
120
3. Log database queries
link
nosplit
OurBigBook Web development
333
6
3.1. Log all database queries
link
nosplit
Log database queries
6
3.2. DEBUG sql
link
nosplit
Log database queries
149
3.3.
OURBIGBOOK_LOG_DB
link
nosplit
Log database queries
53
3.4. PostgreSQL log
link
nosplit
Log database queries
50
3.5. Log specific database queries
link
nosplit
Log database queries
50
3.6. Pretty print SQL queries
link
nosplit
Log database queries
25
4. Local optimized frontend
link
nosplit
OurBigBook Web development
210
5. OurBigBook Web PostgreSQL
link
nosplit
OurBigBook Web development
616
9
5.1. OurBigBook Web PostgreSQL setup
link
nosplit
OurBigBook Web PostgreSQL
32
5.2. Local run as identical to deployment as possible
link
nosplit
OurBigBook Web PostgreSQL
99
5.3. Local development run with PostgreSQL
link
nosplit
OurBigBook Web PostgreSQL
70
5.4. Use a secondary PostgresQL database locally
link
nosplit
OurBigBook Web PostgreSQL
48
5.5. OurBigBook Web PostgreSQL utils
link
nosplit
OurBigBook Web PostgreSQL
279
4
5.5.1. web/bin/pg-kill-queries
link
nosplit
OurBigBook Web PostgreSQL utils
64
5.5.2. Save and restore local PostgreSQL development database
link
nosplit
OurBigBook Web PostgreSQL utils
21
5.5.3. web/bin/psql
link
nosplit
OurBigBook Web PostgreSQL utils
110
5.5.4. web/bin/pg-ls-queries
link
nosplit
OurBigBook Web PostgreSQL utils
84
6. OurBigBook Web without Next.js
link
nosplit
OurBigBook Web development
24
7. OurBigBook Web step debug
link
nosplit
OurBigBook Web development
45
8. OurBigBook Web unit tests
link
nosplit
OurBigBook Web development
594
2
8.1. OurBigBook Web run unit tests in PostgreSQL
link
nosplit
OurBigBook Web unit tests
114
8.2. OurBigBook Web Next.js unit tests
link
nosplit
OurBigBook Web unit tests
373
9. OurBigBook Web TypeScript type checking
link
nosplit
OurBigBook Web development
56
10. OurBigBook Web environment variable
link
nosplit
OurBigBook Web development
15
1
10.1.
OURBIGBOOK_LOG_PERF
link
nosplit
OurBigBook Web environment variable
15
11. OurBigBook Web deployment
link
nosplit
OurBigBook Web development
2k
21
11.1. OurBigBook Web admin
link
nosplit
OurBigBook Web deployment
147
11.2. OurBigBook Web database
link
nosplit
OurBigBook Web deployment
694
8
11.2.1. OurBigBook Web database normalization
link
nosplit
OurBigBook Web database
62
11.2.2. Nested set
link
nosplit
OurBigBook Web database
174
11.2.3. OurBigBook Web database table
link
nosplit
OurBigBook Web database
1
11.2.3.1. OurBigBook Web
Ref
database table
link
nosplit
OurBigBook Web database table
11.2.4. OurBigBook Web database migration setup
link
nosplit
OurBigBook Web database
415
2
11.2.4.1. test-migration
link
nosplit
OurBigBook Web database migration setup
225
11.2.4.2. OurBigBook Web nuke DB instead of migrating
link
nosplit
OurBigBook Web database migration setup
63
11.2.5. OurBigBook Web useful queries
link
nosplit
OurBigBook Web database
43
11.3. OurBigBook Web email sending
link
nosplit
OurBigBook Web deployment
324
1
11.3.1. OurBigBook Web email sending with Sendgrid
link
nosplit
OurBigBook Web email sending
242
11.4. OurBigBook Web reCAPTCHA setup
link
nosplit
OurBigBook Web deployment
102
11.5. Heroku deployment
link
nosplit
OurBigBook Web deployment
1k
7
11.5.1. heroku
link
nosplit
Heroku deployment
46
11.5.2. Upgrade PostgreSQL database
link
nosplit
Heroku deployment
18
11.5.3. Custom domain name setup
link
nosplit
Heroku deployment
177
11.5.4. Staging deployment
link
nosplit
Heroku deployment
137
11.5.5. Heroku debugging
link
nosplit
Heroku deployment
129
1
11.5.5.1. Download Heroku database and restore it locally
link
nosplit
Heroku debugging
100
11.5.6. Dependency organization
link
nosplit
Heroku deployment
227
12. OurBigBook Web performance benchmarking
link
nosplit
OurBigBook Web development
77
13. OurBigBook Web architecture
link
nosplit
OurBigBook Web development
1k
13
13.1. OurBigBook Web security
link
nosplit
OurBigBook Web architecture
13.2. OurBigBook Web CSRF security
link
nosplit
OurBigBook Web architecture
152
13.3. OurBigBook Web tech stack
link
nosplit
OurBigBook Web architecture
33
13.4. OurBigBook Web UI guidelines
link
nosplit
OurBigBook Web architecture
88
13.5. OurBigBook Web URL standards
link
nosplit
OurBigBook Web architecture
400
3
13.5.1. OurBigBook Web URL standards: GET param vs url component
link
nosplit
OurBigBook Web URL standards
145
13.5.2. OurBigBook Web URL standards: article ID comes last due to slash
link
nosplit
OurBigBook Web URL standards
63
13.5.3. OurBigBook Web API standards
link
nosplit
OurBigBook Web URL standards
108
13.6. OurBigBook Web directory structure
link
nosplit
OurBigBook Web architecture
614
4
13.6.1. Web CLI utils
link
nosplit
OurBigBook Web directory structure
489
3
13.6.1.1. web/bin/normalize
link
nosplit
Web CLI utils
192
13.6.1.2. web/bin/rerender-articles.js
link
nosplit
Web CLI utils
224
13.6.1.3. web/bin/rerender-issues.js
link
nosplit
Web CLI utils
73
Ancestors
OurBigBook Web
OurBigBook Project
Incoming links
dist
directory
OurBigBook Web