Dating database example

I came up with the idea for the idea, project, code, and everything in this folder by myself.I'm working on the next version of a local online dating site, PHP & My SQL based and I want to do things right.Below is part of a slightly edited great dating profile example written by a woman.I found this profile to stand out from most others, making the writer sound interesting and attractive as a person, rather than ordinary and cliche, like the vast majority of dating profiles seem to appear.Effectively you are looking for nodes within the same proximity in a N-dimensional space, unfortunately most relational databases aren't really setup for this kind of operation (I believe Postgre SQL has support for this).So most people would probably start with something like: $current_user AND candidate.id=candidate_attrs.user_id AND candidate_attrs.attr_type=current_user.attr_type AND candidate_attrs.attr_value=current_user.attr_value GROUP BY ORDER BY COUNT(*) DESC; $current_user AND candidate.id=candidate_attrs.user_id AND candidate_attrs.attr_type=current_user.attr_type AND candidate_attrs.attr_value BETWEEN current_user.attr_value $tolerance AND current_user.attr_value-$tolerance GROUP BY ORDER BY COUNT(*) DESC; SELECT candidate.id, SUM(1/1 ((candidate_attrs.attr_value - current_user.attr_value) *(candidate_attrs.attr_value - current_user.attr_value)) ) as match_score FROM users candidate, attributes candidate_attrs, attributes current_user_attrs WHERE current_user_attrs.user_id=$current_user AND candidate.user_id$current_user AND candidate.id=candidate_attrs.user_id AND candidate_attrs.attr_type=current_user.attr_type AND candidate_attrs.attr_value BETWEEN current_user.attr_value $tolerance AND current_user.attr_value-$tolerance GROUP BY ORDER BY COUNT(*) DESC; SELECT candidate.id, SUM(1/1 ((candidate_attrs.attr_value - current_user.attr_value) *(candidate_attrs.attr_value - current_user.attr_value)) ) as match_score FROM users candidate, attributes candidate_attrs, attributes current_user_attrs, attribute_subsets s WHERE current_user_attrs.user_id=$current_user AND candidate.user_id$current_user AND candidate.id=candidate_attrs.user_id AND candidate_attrs.attr_type=current_user.attr_type AND candidate_attrs.attr_value AND s.subset_name=$required_subset AND s.attr_type=current_user.attr_type BETWEEN current_user.attr_value $tolerance AND current_user.attr_value-$tolerance GROUP BY ORDER BY COUNT(*) DESC; Obviously this does not accomodate non-ordinal data (e.g. Without knowing a lot more about te structure of the existing data, its rather hard to say exactly how effective this will be.Profile related information can go in its own table.This will be an infinitely expandable table with a key = val nature.

dating database example-52dating database example-86dating database example-32

1) Table: user This will contain the "core" fixed information about a user such as firstname, lastname, email, username, role_id, registration_date and things of that nature.

2) Table: user_profile Fields: user_id, option, value user_id: 1 option: profile_image value: /uploads/12/and user_id: 1 option: questions_answered value: 24 Hope this helps, Paul.

In general, you shouldn't sacrifice database integrity for performance.

As you can imagine I'm a little wary to make a table with 200k rows and 100 columns. one with the most used and searched columns and one with the rest (and bulk) of the columns.

But this lead to big synchronization problems between the two tables.

Leave a Reply

  1. recommended dating website 31-Mar-2020 05:58

    There’s Tinder, of course, and a spate of other apps like Bumble, Hinge, and Ok Cupid, as well as members-only platforms like Raya and the League.

  2. Register free sex chatting 21-Nov-2019 02:26

    Anyway, we were pretty good friends before that (I was one of the few people she talked about certain things to) but for the past couple of months, I can only remember one time where our conversations have been longer than four consecutive sentences.

  3. liquidating dividend taxability 31-May-2020 08:04

    We believe that our women’s forum and its numerous info pages will help you to get an idea of different dating agencies.