Ecosyste.ms: OpenCollective

An open API service for software projects hosted on Open Collective.

github.com/openfoodfacts/openfoodfacts-query

This extracts key product data from MongoDB into a Postgres database to speed up OFF
https://github.com/openfoodfacts/openfoodfacts-query

Support for unfiltered count

c24d55b6a4043f44868607261b4e455977bd036c authored over 1 year ago by John Gomersall <[email protected]>
Add select service for testing

c203ab04432f77989ad65b28334819df49434eb7 authored over 1 year ago by John Gomersall <[email protected]>
Merge pull request #6 from openfoodfacts:production-deploy

Remove docker network for production deployment

43abcb70a5d89af6fc3aa2435ff7d52e7a76618b authored over 1 year ago by john-gom <[email protected]>
Remove docker network for production deployment

57efc060a9d73f4fa7182acc168d45788543130f authored over 1 year ago by John Gomersall <[email protected]>
Merge pull request #5 from openfoodfacts:makefile

Makefile and set ports for testing

52bdb79ae6d365baf34adb3f6b8f1211e9cb735b authored over 1 year ago by john-gom <[email protected]>
Expose ports conditionally

af0dde80b237ee9b159bd727400c5d783fe9d808 authored over 1 year ago by John Gomersall <[email protected]>
More make targets

2d8d26cf7a72d23851b011f2c2501022399f8e74 authored over 1 year ago by John Gomersall <[email protected]>
Cattch specific number of errors

63b0e5dd4102e40e6e79fd76b898a5ad4fee1d6a authored over 1 year ago by John Gomersall <[email protected]>
Catch health check error for clearer logging

61022089484b4ab1d1809f398441223ac434f5b9 authored over 1 year ago by John Gomersall <[email protected]>
Add a basic makefile

b84580abad7602776a4f174f6b6196a65ac7f28b authored over 1 year ago by John Gomersall <[email protected]>
Merge pull request #4 from openfoodfacts:line-endings

Health check

2fde9729e8a316973b32a3d0e114b91a627266f6 authored over 1 year ago by john-gom <[email protected]>
Added health check

a3b17499d06ec2b8aa05469bd3cf6361ad9d97cf authored over 1 year ago by John Gomersall <[email protected]>
Additional fix

4cf6afb710beec9b8e4d6907e5da0e818fea1137 authored over 1 year ago by John Gomersall <[email protected]>
Don't convert line endings

258e78f5372d24621e7eef94e12e78bedce95997 authored over 1 year ago by John Gomersall <[email protected]>
Merge pull request #2 from openfoodfacts/dependabot/npm_and_yarn/mongodb-5.8.0

Bump mongodb from 5.7.0 to 5.8.0

a5ba9f6a4cc71c11d57191306419f72857a57909 authored over 1 year ago by john-gom <[email protected]>
Merge branch 'main' into dependabot/npm_and_yarn/mongodb-5.8.0

57b4fbb54a38a6e4d307bf0fc80acee0800f5250 authored over 1 year ago by john-gom <[email protected]>
Merge pull request #3 from openfoodfacts/multiple-filters

Support multiple match filters

a97b46526661262ee4fbfa628014869d37594364 authored over 1 year ago by john-gom <[email protected]>
Count to also support more than 2 matches

2b39e1e0d3dfa664b029f8440b468571a5f3acee authored over 1 year ago by John Gomersall <[email protected]>
Support multiple matches on an aggregate

77854119d5ceb7d5b630a4d7672a12221cba4b06 authored over 1 year ago by John Gomersall <[email protected]>
Merge branch 'main' into multiple-filters

1f9e51e477c882f895b832b557e14ca6e5105c28 authored over 1 year ago by John Gomersall <[email protected]>
Run checks on pull request

faa2c917885a5910653d95ba5c5fcee33ce85537 authored over 1 year ago by John Gomersall <[email protected]>
Failing test

a73f43f7987590db5796886d3a9192dcd7cd0e22 authored over 1 year ago by John Gomersall <[email protected]>
Run tests as part of build process

06684fab40df99a90efb0eef76f196e13d825ac1 authored over 1 year ago by John Gomersall <[email protected]>
Add COMPOSE_PATH_SEPARATOR

cf84da9ea43e6dcfe5e5b60570eea913af213890 authored over 1 year ago by John Gomersall <[email protected]>
Add Readme TODOs

6d9af89ca1e0dc1425951a8245d725ec802d416a authored over 1 year ago by John Gomersall <[email protected]>
Bump mongodb from 5.7.0 to 5.8.0

Bumps [mongodb](https://github.com/mongodb/node-mongodb-native) from 5.7.0 to 5.8.0.
- [Release ...

c93dcc2ce6f3b4d05c7f62979b37bf771d896dab authored over 1 year ago by dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
Readme uypdates

3ec90387c48dada7e41a292a6addace51906800b authored over 1 year ago by John Gomersall <[email protected]>
Run tests in a container version of postgres

bc62a25aea08e6b2f76b9a8e9bc409d5e573e90b authored over 1 year ago by John Gomersall <[email protected]>
Removed Graphana step

2f6179e9e18c883a5aa8157f6990ba3cf17ce44c authored over 1 year ago by John Gomersall <[email protected]>
Use PO webnet network in staging

1d8381df01537958f91628caf9440e6fae17dcdb authored over 1 year ago by John Gomersall <[email protected]>
Missed MONGO_URI from docker-compose

58a01a1708515615c28736ccf5d3b1488162b6f1 authored over 1 year ago by John Gomersall <[email protected]>
Use leteral "main" tag for trigger

66ea3dc369385ff20201aa9be10c121232961a6b authored over 1 year ago by John Gomersall <[email protected]>
Got rid of remove-orphans

0562ee031a37ade33a1f9de53e4c8b2f0c3b42b0 authored over 1 year ago by John Gomersall <[email protected]>
Additional tests

c4391e185a8a41a4b683bb509dd10f59dbcea192 authored over 1 year ago by John Gomersall <[email protected]>
Fix production HOST

14640bd1493d9f4a6900d87f53b94d5f7778dd0c authored over 1 year ago by John Gomersall <[email protected]>
Conteiner deploy

0f0c7a432b0118130e58acb40e4d8a7c93136de2 authored over 1 year ago by John Gomersall <[email protected]>
Use MONGO_URI to be consistent with Robotoff

29db61ee5196f6eebbecfad71bfb1106ea5ea019 authored over 1 year ago by John Gomersall <[email protected]>
Alweqays have own postgres for now to keep it simple

9b6a6462cc25cfcfe60d00592fb623acd4821f2e authored over 1 year ago by John Gomersall <[email protected]>
Squashed migrations

c3f8947ae412ec153265ef7384208c17f43da538 authored over 1 year ago by John Gomersall <[email protected]>
Add cascade for tags

fb2e9c240af5d332cb4820c2f316adda3f21e107 authored over 1 year ago by John Gomersall <[email protected]>
Move init to server start to simplify containers

4fd9c50a1bca77b1399f92b4febeafcf32dae5e1 authored over 1 year ago by John Gomersall <[email protected]>
Container build

8bd798b56ca5cace3a087ec3e719daebbdf3e07e authored over 1 year ago by John Gomersall <[email protected]>
Removed creator tags table as get data directly from product

ac6e07b92785a74f96313b773a7a95f832a367c0 authored over 1 year ago by John Gomersall <[email protected]>
Ensure the data directory is available always

503d0932274be1b0b856d17914c063a86857e312 authored over 1 year ago by John Gomersall <[email protected]>
Remove unused fields, extra date validation and skip for debugging

6a4fcb087a5e65ad2d51992576eb2da67decfbae authored over 1 year ago by John Gomersall <[email protected]>
Add mapping to local data folder

f9b169b304ebf121d31a2405344ec6b077f7829a authored over 1 year ago by John Gomersall <[email protected]>
More readme

dce9e970592c0817cb07181a3733a26f21c05fff authored over 1 year ago by John Gomersall <[email protected]>
Split out docker-compose.yml

4068fa8806211eba1a61ecae238f4eddafda469e authored over 1 year ago by John Gomersall <[email protected]>
Stop just from picking up built mikro-orm config

e41405cb27c7d66a8dcd2afea3c0e104c9f02589 authored over 1 year ago by John Gomersall <[email protected]>
Rename schema to "query"

1186f54e73e58c0924d20abbed9ad591c4d36d5d authored over 1 year ago by John Gomersall <[email protected]>
Readme updates and switch ports

2911e3c6776d88af292c455f5b0b8e4b936a4677 authored over 1 year ago by John Gomersall <[email protected]>
Some code reuse and support throw exception for unsupported tag

1a8807d9775968807082f6b08bf9f5e55bbc8df6 authored over 1 year ago by John Gomersall <[email protected]>
Count with not tags

65c445767fc30e9ffb609ddf9969ecd034d4dd39 authored over 1 year ago by John Gomersall <[email protected]>
Query Service count test

854a2817a73b35e0a376c9cde7321523734bb314 authored over 1 year ago by John Gomersall <[email protected]>
Basic test

18f0cfa46d866d9f2af435b9bbfee2ccdecafa7f authored over 1 year ago by John Gomersall <[email protected]>
Delete unused tags

8a9660ff8a1d731282246d808faf416ab7a39376 authored over 1 year ago by John Gomersall <[email protected]>
Added missing tags and commenting unused

9857d314fefd538d313b8bec455065c665580332 authored over 1 year ago by John Gomersall <[email protected]>
Tweaks for running with PO

960106671f0668e414f0810fb5ff44148a89787a authored over 1 year ago by John Gomersall <[email protected]>
No need to update tags twice

66538bcf38159ac8bbbb1e44107c4efb49051f26 authored over 1 year ago by John Gomersall <[email protected]>
Switch primary key and add index

fe917b218bae98ee87a62b47a755c2958fb96b29 authored over 1 year ago by John Gomersall <[email protected]>
Work out from using database if empty

873f58cd1a2ea70ce3e4a033e4d2bebda969dbf9 authored over 1 year ago by John Gomersall <[email protected]>
Re-order functions

a3ccaac3031c2f30411a0518f17d84ade3ef1f6d authored over 1 year ago by John Gomersall <[email protected]>
Separate simple count from aggregation

28268fd640abde7e025e276ea504ec9be5e1995b authored over 1 year ago by John Gomersall <[email protected]>
Improve count distinct performance and only limit when requested

3a7e7c0253d2861aa0568fab473f5504bd7bfdb2 authored over 1 year ago by John Gomersall <[email protected]>
Remove sequence

bdb84e6fc884344579685ce3002538237649e111 authored over 1 year ago by John Gomersall <[email protected]>
Document count support

46fe9ee0e539278e41c5d29c0c89a8a18b1102a3 authored over 1 year ago by John Gomersall <[email protected]>
Support count queries

f5c03423c67781442d1cf7abc6dbaca820910186 authored over 1 year ago by John Gomersall <[email protected]>
Incorporate obsolete into import from MongoDB

a39f88dc796089414c0a6f23c194185c513e2080 authored over 1 year ago by John Gomersall <[email protected]>
Use bulk insert for tags from data

169cb7d746d42a3f12657ccf9038ab51b8378c1e authored over 1 year ago by John Gomersall <[email protected]>
Query controller

1ce22c7da38899dd7f8a30f6a3b1d32f957b8afd authored over 1 year ago by John Gomersall <[email protected]>
All the tag tables

ca3d8682a9b3bd75f483a85bb11f3c4d96306d83 authored over 1 year ago by John Gomersall <[email protected]>
Basic support for tag per table

bf3c10c300e8db2e9c0f41d71ba529f896036c62 authored over 1 year ago by John Gomersall <[email protected]>
An option to export with a Ulid to reduce data size

a8db6db5c5def6fcb16f2c95e817d8b8f3abae82 authored over 1 year ago by John Gomersall <[email protected]>
Generate CSV

d9ee79bc7d295235aa31ee0f7299f04b7bd8820a authored over 1 year ago by John Gomersall <[email protected]>
Simple query API

cf763a7d72b5a76438dc0d2ea216ae8b1a53587f authored over 1 year ago by John Gomersall <[email protected]>
Use set operation to create tags

fe65454821def712bfe5d39029e8d383f5b02dab authored over 1 year ago by John Gomersall <[email protected]>
Added last modified and import script

d1b6a0fade4058405ace613a2d4e5a79371d187a authored over 1 year ago by John Gomersall <[email protected]>
Import all tags

4ab0b336fdb837ba50f2e1fb69f41e03f656c8f9 authored over 1 year ago by John Gomersall <[email protected]>
Basic import functions

96307268e67005e45e4c1d4d087c3ae29ffb5354 authored over 1 year ago by John Gomersall <[email protected]>
Basic entities with first migration

a358af3973aad4f82f415e59f1172aa563d38827 authored over 1 year ago by John Gomersall <[email protected]>
Basic NestJS project

a2f6da5809e39d58c3ef0e60c2970d0dc11f3292 authored over 1 year ago by John Gomersall <[email protected]>
Initial commit

f19ebc24ca1c281adbbc670f37a48b19edf95c92 authored over 1 year ago by Alex Garel <[email protected]>