The Wayback Machine - https://web.archive.org/web/20201024135925/https://github.com/kriasoft/nodejs-api-starter/issues/36
Skip to content

/ nodejs-api-starter Template

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.

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

Create an index on user.emails column in the database #36

Closed
koistya opened this issue Jun 3, 2017 · 4 comments
Closed

Create an index on user.emails column in the database #36

koistya opened this issue Jun 3, 2017 · 4 comments
Labels
good first bug help wanted

Comments

@koistya
Copy link
Member

@koistya koistya commented Jun 3, 2017 •
edited

File to edit migrations/201612010000_initial.js

References

https://www.postgresql.org/docs/current/static/datatype-json.html#JSON-INDEXING
http://knexjs.org/#Schema-index

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.
@rajpatel507
Copy link

@rajpatel507 rajpatel507 commented Jun 5, 2017

Can i work on this?
@koistya
Copy link
Member Author

@koistya koistya commented Jun 5, 2017

@rajpatel507 sure, that would be awesome!
@rajpatel507
Copy link

@rajpatel507 rajpatel507 commented Jun 19, 2017 •
edited

@koistya I am new to knexjs and postgresql but what i understand from my limited knowledge that

table.jsonb('emails').notNullable().defaultTo('[]').index();

will work right?
@koistya
Copy link
Member Author

@koistya koistya commented Feb 3, 2020

@rajpatel507 I just removed plural emails field in favor of a single email field in order to simplify things a little.
@koistya koistya closed this Feb 3, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
good first bug help wanted
2 participants
@koistya @rajpatel507
You can’t perform that action at this time.