Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Postgresql-backed store #258

Open
gordom6 opened this issue Oct 14, 2020 · 5 comments
Open

Postgresql-backed store #258

gordom6 opened this issue Oct 14, 2020 · 5 comments
Assignees
@123joshuawu

Comments

@gordom6
Copy link
Contributor

gordom6 commented Oct 14, 2020

See this set of .sql for inspiration on how to use fulltext:
https://github.com/minorg/thingsworth/tree/develop/java/lib/src/main/resources/db/migration
@gordom6
Copy link
Contributor Author

gordom6 commented Oct 14, 2020

Also see the manual page:
https://www.postgresql.org/docs/9.5/textsearch.html

@gordom6
Copy link
Contributor Author

gordom6 commented Oct 14, 2020

As an aside, we could probably get away with NOT having full-text on a first pass, per #257.

@gordom6
Copy link
Contributor Author

gordom6 commented Oct 14, 2020

The migrations in the directory linked in the description are for Flyway. There's a Play plugin for Flyway.

@gordom6
Copy link
Contributor Author

gordom6 commented Oct 15, 2020 •
edited
Loading

On the Scala/Java side I've used jOOQ, which is a Java library but has a good Scala interface.

Slick is the more typical Scala library, and has good Play integration.

@123joshuawu
Copy link
Member

Am going through the Slick documentation, looks very neat

123joshuawu added a commit that referenced this issue Nov 25, 2020
@123joshuawu
Merge branch 'master' into #258
5377bb7
gordom6 added a commit that referenced this issue Nov 27, 2020
@gordom6
Merge pull request #263 from tetherless-world/#258
4f06961 
PostgreSQL store implementation
123joshuawu added a commit that referenced this issue Dec 18, 2020
@123joshuawu
Merge pull request #273 from tetherless-world/#258
740a319 
Add page rank for nodes and node labels
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@123joshuawu 123joshuawu

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@123joshuawu @gordom6