Axtell

Pavel

12:03 AM

@Mego Cool!

Anonymous

Only had to fight with PyCharm for about 15 minutes to get everything set up

Anonymous

Small victories

Pavel

@Mego PyCharm has a template for flask tho, also you didn't add .idea/* to .gitignore

Anonymous

1:00 AM

I'll set that up in a little bit

Pavel

4:25 AM

@Mego could I have push access to the repository? You can keep master protected, just just that branching is easier than forking.

Anonymous

Sure

Anonymous

pavelbraginskiy, right?

Anonymous

Also Flask templates are only in the professional edition of PyCharm

Anonymous

Which apparently I can use because open source

ATaco

Sadly, I can't write python. :(

Anonymous

4:31 AM

@ATaco No time like the present to learn!

Anonymous

Also we'll (eventually) need web design

ATaco

I can't design, but I can build.

(Anything that looks slightly good on a-ta.co is DownGoat's design)

Pavel

@Mego Yeah. If you look at the pull request you closed theres a link to my account

(Sorry I was busy leveling up Ayren)

@Mego If you don't actually have that license yet, I can initialize a Flask template and then copy the files over

Anonymous

4:47 AM

I have the license, but I just hadn't installed Pro yet

Pavel

@Mego Alright, I won't do that then. Mine's updating, anyway.

Anonymous

master should be set up properly now

Pavel

@Mego Ok. You know, when I tested this earlier, I could have sworn that the template had a lot more files.

Anonymous

Idk

Anonymous

Time to install MySQL so I can make a DB

Pavel

4:51 AM

Same I suppose

._. why does it launch on port 5000 by default

Anonymous

Flask?

Pavel

@Mego Yeah

Anonymous

Probably because it's not a commonly-used port

Pavel

I guess

I expected it to be 80 tbh

@Mego seconds away from making a pull request, my dad failed to replace a power outlet and cut off power in our house entirely.

(it's fixed now)

(all work was lost)

(Project corrupted hopelessly)

Anonymous

5:18 AM

RIP

Anonymous

So here's what I have so far for the DB: gist.github.com/Mego/a403da6eae7050b95914877113e5e883

4

Anonymous

MySQL Workbench is the only thing that made that not incredibly painful

Pavel

So as it turns out that there's a .idea/PPCG-v2.iml that shouldn't be .gitignored, because it has information about where the templates are and what template language is used, and pycharm cares about that.

Everything else in there is personal afaik

I'll fix that myself

Anonymous

Ok

Anonymous

This is my first time actually using PyCharm

Pavel

5:24 AM

Huh

It's pretty great

Anonymous

It seems nice so far

Pavel

There's a SQL IDE called DataGrip

Also by JetBrains

Anonymous

MySQL Workbench is nice, and I'm experienced with it

Pavel

I'll look at it

@Mego write access would be nice right about now

Anonymous

I sent you the invite

Pavel

5:29 AM

Oh right GitHub only does invites through email

I always expect to see a notification on the website itself

._. MySql is telling me it wants specifically python 3.4

Anonymous

Grab the platform-independent version

Pavel

Is Connector/Python required?

Anonymous

Yep

Anonymous

With the platform-independent version, it's just python3 setup.py install

Pavel

Where can I find this platform-independent version?

Anonymous

5:35 AM

Choose it from the OS dropdown on the mysql website

Pavel

Doesn't seem to exist

imgur.com/a/gCRk1

Anonymous

dev.mysql.com/downloads/file/?id=472643

Pavel

thanks

Ok that worked

Anonymous

The regular installers are terrible - setup.py never fails

Pavel

Not actually sure where it got installed to though.

Anonymous

5:41 AM

<python lib dir>/site-packages/mysql

Pavel

Awesome

Sherlock9

Should remember that trick about setup.py, as pip always screws up my numpy installs

Pavel

I think I'm going to sleep now. Cya tommorow!

Anonymous

See ya

Sherlock9

5:57 AM

So we have the API, and the basic database. Now we need the rest of the site design, a way to migrate rep, and am I missing anything else on the to-do list?

Anonymous

Ooh, I need to include rep in the users table

Sherlock9

I'll look in El'endia Starman's TNBDE for more fields

Ah wait, I forgot that's for chat.

The posts and the answers should have score fields as well

Pavel

@Sherlock9 We don't have the API at all yet, the web server only says Hello World

Sherlock9

Noted. We have the design for the API

Do we want to have comments on posts and answers as well?

Pavel

A really bare-bones version of the API

Without things like comments or meta or sandbox

We haven't gotten very far

Sherlock9

6:03 AM

Fair enough. Sorry for bringing up everything at once then

Anonymous

It's fine

Anonymous

We need to keep those things in mind

Anonymous

For example, I completely forgot about votes in the DB design

Anonymous

Updated the gist with the current schema design

Sherlock9

Do the tags need a description field?

Anonymous

6:13 AM

Eventually, yeah

Anonymous

They'll also need a wiki field

Sherlock9

Well, besides that, I don't currently recall any other fields that are needed in the database

Anonymous

Well, if we want to replicate the vote timeout feature, we'll need a datetime field on votes

Anonymous

Also datetime info about posts/answers

Anonymous

And then comments...

Anonymous

6:17 AM

Users will want profile text, avatars, GitHub account links, SE account links, etc.

Anonymous

Also answer metadata like language, language link, TIO link, etc.

Anonymous

But for now, I'm going for bare-bones SE-like experience

Sherlock9

Fair enough

Anonymous

MVP first

Anonymous

Then features

Sherlock9

6:24 AM

Had to Google that, but yes

Is there any reason for the following from the gist?

KEY `tag2_idx` (`tag1`),
KEY `tag2_idx1` (`tag2`),

Anonymous

Probably a typo

Anonymous

Yep, I typo'd the tag field names, and the indices didn't get renamed when I fixed it

Mr. Xcoder

If you login via SE accounts, would those registered with Facebook/Google have access?

Anonymous

They should

Mr. Xcoder

Cool project, we really need an optimised place for golfing :D

Transcript for