I have a simple database in django with SQLite and now I want to improve it with a better search capability (I will create a new project with new models). I would like to ask about how to plan and go about this project. The existing database has these fields
first, initial, last, school, yearGraduated
I am using django admin to sort by last name and then filter by year graduated to find lawyers who graduated from same school the same year.
It works like this:
Enter last name and search.
Search results reveal all lawyers who went to same school
Sort by last name searched
Find year graduated
Go to year graduated filter and click on the year graduated to get his classmates.
Example:
Search for "connelly"
Results for 58 names who went to Georgetown University Law Center
Sort by last name to see that connelly graduated in 1973
Click on 1973 in year graduated filter
This pulls 3 more lawyers "eliot", "frederick" and "alan" who graduated from Georgetown in 1973
Instead of this I would like to enter "connelly" in the search box and get the names of "eliot", "frederic" and "alan".
I am planning to use Postgres with these filds:
url (of the bio page of lawyer); firm; firstName; lastName; school; yearGraduated
How do I achieve this result? Thanks for your advice and help.