Open Sustainability Index

An open, transparent, wikipedia-like sustainability database - aiming to accelerate comparable corporate sustainability data.
https://github.com/open-sustainability-index/open-sustainability-index-backend

Category: Emissions
Sub Category: Carbon Intensity and Accounting

Keywords

remix supabase swagger typescript vite

Last synced: about 20 hours ago
JSON representation

Repository metadata

Backend and API routes for Open Sustainability Index

• Host: GitHub
• URL: https://github.com/open-sustainability-index/open-sustainability-index-backend
• Owner: Open-Sustainability-Index
• License: agpl-3.0
• Created: 2024-04-17T12:50:11.000Z (about 1 year ago)
• Default Branch: main
• Last Pushed: 2024-11-18T09:16:05.000Z (5 months ago)
• Last Synced: 2025-04-18T04:10:45.185Z (9 days ago)
• Topics: remix, supabase, swagger, typescript, vite
• Language: PLpgSQL
• Homepage: https://api.opensustainabilityindex.org/v1/companies?api-key=demo&limit=10&offset=0
• Size: 1.07 MB
• Stars: 8
• Watchers: 1
• Forks: 1
• Open Issues: 5
• Releases: 0
• Metadata Files:
  • Readme: README.md
  • License: LICENSE

README.md

npm run dev

cd supabase

npx supabase start

npx supabase status

npx supabase db pull  # Pull down local db schema from cloud db
npx supabase db push  # Push up your local db schema to cloud db

npx supabase db dump --data-only -f db_data.sql
psql --single-transaction --file db_data.sql --dbname 'postgresql://postgres:postgres@localhost:54332/postgres'

npx supabase db diff -f [migration-name]
# Then normally run: npx supabase db push

npx supabase migration up

npx supabase db reset

SELECT * FROM companies(
	0,                  -- offset_value
	20,                 -- limit_value
	'name',             -- sort_by
	'asc',              -- sort_order
	--  'Technology',   -- industry_filter
	--  true,           -- near_term_filter
	--  'Type A',       -- commitment_type_filter
	--  'Active',       -- commitment_status_filter
	--  'Target 1'      -- target_target_filter
	--  'omx120'        -- tags_filter
);

SELECT * FROM companies_v2(
	0,                  -- offset_value
	20,	                -- limit_value
	'name',             -- sort_by
	'asc'               -- sort_order
	--  'Technology',   -- industry_filter
	--  true,           -- near_term_filter
	--  'Type A',       -- commitment_type_filter
	--  'Active',       -- commitment_status_filter
	--  'Target 1'      -- target_target_filter
	--  ??              -- emissions_required
	--  'omx120'        -- tags_filter
);

SELECT pg_get_functiondef('companies_v2'::regproc);

Owner metadata

• Name: Open Sustainability Index
• Login: Open-Sustainability-Index
• Email: [email protected]
• Kind: organization
• Description:
• Website: opensustainabilityindex.org
• Location:
• Twitter:
• Company:
• Icon url: https://avatars.githubusercontent.com/u/168263944?v=4
• Repositories: 1
• Last ynced at: 2024-05-03T17:18:38.870Z
• Profile URL: https://github.com/Open-Sustainability-Index

GitHub Events

Total

• Watch event: 1
• Delete event: 1
• Issue comment event: 2
• Push event: 14
• Pull request event: 3
• Create event: 1

Last Year

• Watch event: 1
• Delete event: 1
• Issue comment event: 2
• Push event: 14
• Pull request event: 3
• Create event: 1

Committers metadata

Last synced: 6 days ago

Committer domains:

• palander.se: 1
• tomsoderlund.com: 1
• tiburon.se: 1

Issue and Pull Request metadata

Last synced: 2 days ago

Dependencies

Score: 3.6635616461296463