issues
search
zipperer
/
migrate_database_with_michael
0
stars
0
forks
source link
issues
Newest
Newest
Most commented
Recently updated
Oldest
Least commented
Least recently updated
Meeting 20240326
#52
zipperer
closed
3 months ago
1
Describe process to make site for application
#51
zipperer
opened
4 months ago
2
Make application that uses the database to link message numbers with <timestamp, book, chapter, verse> entries
#50
zipperer
opened
4 months ago
6
Project overview
#49
zipperer
opened
4 months ago
0
Meeting 20240130
#48
zipperer
closed
5 months ago
0
Make prototype of linux container that runs postgres
#47
zipperer
closed
5 months ago
1
Meeting 20240125 -- share version 0 of the database to link message numbers with <timestamp, book, chapter, verse> entries
#46
zipperer
closed
5 months ago
2
Retrace steps. Make walkthrough from initial files through to query to join message # with entries. Record as procedure to follow. Want model of what we are doing and why and the commands to do it.
#45
zipperer
opened
5 months ago
1
Implement table `file_timestamped_entry_book_chapter_verse` and make process to populate it
#44
zipperer
closed
5 months ago
4
Draft tables that will allow us to query a presentation id and get all the timestamped entries for that presentation
#43
zipperer
closed
5 months ago
6
Make table with columns 1. BDA filename 2. entry from BDA filename
#42
zipperer
closed
5 months ago
7
Bible Display App files -- take csv that maps the filename to the date, put contents into database, query to join (a) presentation titles file content and (b) Bible Display App filenames
#41
zipperer
closed
5 months ago
1
Bible Display App files -- make csv that maps the filename to the date
#40
zipperer
closed
5 months ago
1
Presentation titles file -- separate SN090901 column into three columns (day, morning_or_night, date)
#39
zipperer
closed
5 months ago
1
Write program to remove Strong's numbers from excerpts, except for numbers that correspond to focus word
#38
zipperer
closed
5 months ago
2
Meeting 20240117
#37
zipperer
closed
5 months ago
3
Paypal csv: make script to use from commandline to process paypal csv
#36
zipperer
closed
5 months ago
4
Meeting 20240115
#35
zipperer
closed
5 months ago
3
Meeting 20240116
#34
zipperer
closed
5 months ago
2
collect resources on postgres and python and share
#33
zipperer
closed
5 months ago
1
Make two postgres clusters. Make one cluster the main. Make other cluster the replica. Forward operations from main to replica.
#32
zipperer
closed
5 months ago
1
Meeting 20231219
#31
zipperer
closed
5 months ago
3
tracking changes in db: steps to set up functions and triggers: conne…
#30
zipperer
closed
7 months ago
0
Update psql-interactions-while-setting-up-database-table-functions-an…
#29
zipperer
closed
7 months ago
0
Prototype with glabels
#28
zipperer
closed
5 months ago
4
Keep up-to-date spreadsheet that tracks sessions
#27
zipperer
opened
7 months ago
0
Add column to tables that tracks datetime when edited most recently, last_updated_time
#26
zipperer
closed
5 months ago
3
Add default values for columns
#25
zipperer
closed
5 months ago
4
Scheduled backups in place and confirm occurring
#24
zipperer
closed
5 months ago
8
Perform backup and restore
#23
zipperer
closed
7 months ago
1
Add data to table in postgres via SQL
#22
zipperer
closed
7 months ago
1
Create table in postgres
#21
zipperer
closed
7 months ago
1
Create database in postgres
#20
zipperer
closed
7 months ago
1
On production server, install, run, and configure postgres cluster
#19
zipperer
opened
7 months ago
1
Choose machine to be production server
#18
zipperer
opened
7 months ago
0
Make new user -- non-admin user
#17
zipperer
opened
7 months ago
0
Copy data into table in postgres from CSV
#16
zipperer
closed
7 months ago
1
Create table in postgres, which table will contain data from table in Lotus Approach
#15
zipperer
closed
5 months ago
1
For a table in Lotus Approach, use exported CSV to import into postgres table
#14
zipperer
closed
5 months ago
2
TablePlus -- use GUI to add new row to table and commit change, query contents of table
#13
zipperer
closed
7 months ago
1
TablePlus -- connect to postgres instance, see database and tables
#12
zipperer
closed
7 months ago
1
install TablePlus
#11
zipperer
closed
7 months ago
1
Connect to postgres database from computer different from the computer that hosts the database
#10
zipperer
opened
7 months ago
0
Make password for admin user
#9
zipperer
closed
7 months ago
1
Execute commands to log in to postgres instance
#8
zipperer
closed
7 months ago
1
Try glabels program for making labels and printing
#7
zipperer
closed
5 months ago
2
For table `mailing_list` make new column to identify listener, use integer that increments automatically
#6
zipperer
closed
5 months ago
4
Import data into table in postgres for `mailing_list`
#5
zipperer
closed
5 months ago
4
Import data into table in postgres for each table in Lotus Approach
#4
zipperer
closed
5 months ago
1
Meeting 20231128
#3
zipperer
closed
7 months ago
3
Next