OurBigBook Docs
OurBigBook.com
Site
Source code
OurBigBook Web development
Home
OurBigBook Web
words: 7k
articles: 75
Table of contents
7k
75
1.
Local development server
OurBigBook Web development
504
2.
Generated data
OurBigBook Web development
813
3
2.1.
Wikipedia bot
(wikibot)
Generated data
470
2.2.
Demo data
Generated data
343
1
2.2.1.
Demo data local file output
Demo data
120
3.
Log database queries
OurBigBook Web development
397
6
3.1.
Log all database queries
Log database queries
6
3.2.
DEBUG sql
Log database queries
149
3.3.
OURBIGBOOK_LOG_DB
Log database queries
117
3.4.
PostgreSQL log
Log database queries
50
3.5.
Log specific database queries
Log database queries
50
3.6.
Pretty print SQL queries
Log database queries
25
4.
Local optimized frontend
OurBigBook Web development
210
5.
OurBigBook Web PostgreSQL
OurBigBook Web development
478
9
5.1.
OurBigBook Web PostgreSQL setup
OurBigBook Web PostgreSQL
32
5.2.
Local run as identical to deployment as possible
OurBigBook Web PostgreSQL
99
5.3.
Local development run with PostgreSQL
OurBigBook Web PostgreSQL
70
5.4.
Use a secondary PostgresQL database locally
OurBigBook Web PostgreSQL
48
5.5.
OurBigBook Web PostgreSQL utils
OurBigBook Web PostgreSQL
141
4
5.5.1.
web/bin/pg-kill-queries
OurBigBook Web PostgreSQL utils
25
5.5.2.
Save and restore local PostgreSQL development database
OurBigBook Web PostgreSQL utils
21
5.5.3.
web/bin/psql
OurBigBook Web PostgreSQL utils
70
5.5.4.
web/bin/pg-ls-queries
OurBigBook Web PostgreSQL utils
25
6.
OurBigBook Web without Next.js
OurBigBook Web development
24
7.
OurBigBook Web step debug
OurBigBook Web development
45
8.
OurBigBook Web unit tests
OurBigBook Web development
594
2
8.1.
OurBigBook Web run unit tests in PostgreSQL
OurBigBook Web unit tests
114
8.2.
OurBigBook Web Next.js unit tests
OurBigBook Web unit tests
373
9.
OurBigBook Web static analysis
OurBigBook Web development
85
2
9.1.
OurBigBook Web TypeScript type checking
OurBigBook Web static analysis
56
9.2.
OurBigBook Web TypeScript type linting
OurBigBook Web static analysis
29
10.
OurBigBook Web environment variable
OurBigBook Web development
11.
OurBigBook Web deployment
OurBigBook Web development
2k
21
11.1.
OurBigBook Web admin
OurBigBook Web deployment
147
11.2.
OurBigBook Web database
OurBigBook Web deployment
691
8
11.2.1.
OurBigBook Web database normalization
OurBigBook Web database
62
11.2.2.
Nested set
OurBigBook Web database
171
11.2.3.
OurBigBook Web database table
OurBigBook Web database
1
11.2.3.1.
OurBigBook Web
Ref
database table
OurBigBook Web database table
11.2.4.
OurBigBook Web database migration setup
OurBigBook Web database
415
2
11.2.4.1.
test-migration
OurBigBook Web database migration setup
225
11.2.4.2.
OurBigBook Web nuke DB instead of migrating
OurBigBook Web database migration setup
63
11.2.5.
OurBigBook Web useful queries
OurBigBook Web database
43
11.3.
OurBigBook Web email sending
OurBigBook Web deployment
365
1
11.3.1.
OurBigBook Web email sending with Sendgrid
OurBigBook Web email sending
242
11.4.
OurBigBook Web reCAPTCHA setup
OurBigBook Web deployment
102
11.5.
Heroku deployment
OurBigBook Web deployment
1k
7
11.5.1.
heroku
Heroku deployment
26
11.5.2.
Upgrade PostgreSQL database
Heroku deployment
18
11.5.3.
Custom domain name setup
Heroku deployment
175
11.5.4.
Staging deployment
Heroku deployment
137
11.5.5.
Heroku debugging
Heroku deployment
171
1
11.5.5.1.
Download Heroku database and restore it locally
Heroku debugging
142
11.5.6.
Dependency organization
Heroku deployment
227
12.
OurBigBook Web performance benchmarking
OurBigBook Web development
344
3
12.1.
Next.js web vitals
OurBigBook Web performance benchmarking
58
12.2.
OURBIGBOOK_LOG_PERF
OurBigBook Web performance benchmarking
20
12.3.
OurBigBook Web performance log
OurBigBook Web performance benchmarking
246
13.
OurBigBook Web architecture
OurBigBook Web development
1k
16
13.1.
OurBigBook Web security
OurBigBook Web architecture
13.2.
OurBigBook Web CSRF security
OurBigBook Web architecture
152
13.3.
OurBigBook Web tech stack
OurBigBook Web architecture
33
13.4.
OurBigBook Web UI guidelines
OurBigBook Web architecture
282
1
13.4.1.
OurBigBook Web with JavaScript disabled
OurBigBook Web UI guidelines
120
13.5.
OurBigBook Web URL standards
OurBigBook Web architecture
414
3
13.5.1.
OurBigBook Web URL standards: GET param vs url component
OurBigBook Web URL standards
151
13.5.2.
OurBigBook Web URL standards: article ID comes last due to slash
OurBigBook Web URL standards
63
13.5.3.
OurBigBook Web API standards
OurBigBook Web URL standards
102
13.6.
OurBigBook Web directory structure
OurBigBook Web architecture
427
6
13.6.1.
Web CLI utils
(web/bin)
OurBigBook Web directory structure
302
5
13.6.1.1.
web/bin/normalize
Web CLI utils
60
13.6.1.2.
web/bin/rerender-articles.js
Web CLI utils
167
13.6.1.3.
web/bin/rerender-issues.js
Web CLI utils
5
13.6.1.4.
web/bin/rerender-comments.js
Web CLI utils
5
13.6.1.5.
web/bin/set-password
Web CLI utils
33
Ancestors
(2)
OurBigBook Web
Home
Incoming links
(2)
dist
directory
OurBigBook Web
OurBigBook Docs
OurBigBook.comSite
Source code
OurBigBook Docs
OurBigBook.comSite
Source code