Pallas’s Hub is an innovative web application designed to serve as a comprehensive platform for researchers and scholars to collaborate, share knowledge, and secure funding opportunities. It addresses the fragmented nature of current tools by offering integrated features tailored to the needs of the scientific community.
chmod +x ./db.sh
./db.sh [PRIVATE_KEY_FILE] [RDS_ENDPOINT] [IP_ADDRESS]Then, connect in your database client on localhost:5432 using the credentials.
goose -dir migrations create [MIGRATION_NAME] sqlIn the 'up' portion of the file add the queries (usually DDL statements). Do not use the 'down' portion to undo changes in 'up' Instead, simply create another migration. This will ensure an easy trail of changes to the database (since we're always connecting directly to the production instance via SSH).
goose -dir migrations postgres [SQL_CONNECTION_STRING] upCheck the output of goose to see if the migrations run successfully and adjust the queries if an error occurred.
See more information about goose usage in its documentation.
First, create/update the SQL queries inside server/queries. See documentation on how to use annotations to tell sqlc what code to generate.
Then, use sqlc to generate Go code based on those SQL queries:
cd server
sqlc generateMake sure you commit all the code added/removed by sqlc and yourself in server/queries and server/generated directories.
cd client
npm i
npm run devexport DB="<get the database connection string from a peer>"
export GMAL_USERNAME="<get the credential from a peer>"
export GMAIL_PASSWORD="[<get the credential from a peer>"
export JWT_SECRET_KEY="[<get the key from a peer>"cd server
go run .Alternatively, run live reload dev server using Air:
cd server
airLinks to the wireframes: