#dev | Logs for 2017-04-23

« return
[11:56:03] <Bytram> TheMightyBuzzard: got some good news on the BC front & subscriptions... remember that json structure you sent me?
[11:56:37] <Bytram> scrool down a bit and I see:
[11:56:38] <Bytram> "type": "bitcoin",
[11:57:18] <Bytram> (located about 15-20 lines from the bottom)
[11:58:12] <TheMightyBuzzard> yeah, knew it told you it was bitcoin.
[11:59:14] <TheMightyBuzzard> i just really don't wanna hafta write in new logic and change the db. mostly change the db.
[12:04:17] <Bytram> aww, c'mon... you *knew* I'd figure it out... eventually!
[12:04:19] <Bytram> =)
[12:04:59] * TheMightyBuzzard grumbles about Bytram creating more work without putting it on the issue tracker where it can be happily ignored
[12:05:18] <Bytram> aww, c'mon... you *knew* I'd figure that out, TOO... eventually!
[12:05:46] * Bytram remembers someone commenting about someone else being able to break an anvil in about 10 minutes
[12:06:42] <TheMightyBuzzard> mostly that grumble is cause i wanted this to be able to go out tomorrow. now feature creep is gonna push it back a couple more days.
[12:07:51] <Bytram> understood. would rather have consistent stuff in the DB for the long term; is easier to do that from the outset than to go back in after the fact... 'cause that often is not actually done after the fact.
[12:08:01] <Bytram> if you do it up front, then you know it IS in there.
[12:09:08] <TheMightyBuzzard> oh, we are no way in hell keeping a table of changing fee rates calculations for stripe. i'll go ahead and put their current fee algorithm in but if it changes i'm just removing it.
[12:09:52] <TheMightyBuzzard> they can bloody well start putting net in their json
[12:10:41] <Bytram> don't NEED to add that part... that would be a "Wouldn't it be nice if" (WIBNI)... at this point, and we could backfeed data in the futurte if we needed to, but it is *mandatory* that we know whether or not it was BC as there is a *different* overhead calc for it.
[12:11:06] <Bytram> one more column, "payment_type" == BC | CC would suffice
[12:11:18] <TheMightyBuzzard> it's not mandatory at all. subs page was never meant for bookkeeping.
[12:11:25] <Bytram> not ideal, but necessary to be able to back calculate stuff later.
[12:12:15] <Bytram> so we should preclude the ability to use it as such?
[12:12:21] <Bytram> I've been doing that for about a half year now
[12:12:34] <TheMightyBuzzard> you're doing the job of the treasurer right now but the treasurer should have access to the proper accounting sources.
[12:13:11] <Bytram> agreed that they should
[12:13:51] <Bytram> having the info on our side acts as a check against their calculations, too.
[12:13:55] <Bytram> independent verifications
[12:13:57] <TheMightyBuzzard> help me talk Deucalion into getting you read-only stripe access then and it's as easy as pie.
[12:14:19] <TheMightyBuzzard> anyway, getting informed it's smoke break time.
[12:14:39] <Bytram> 1) don't want access to real money
[12:15:29] <Bytram> 2) I can pose query atm using the UI and calc totals WITHOUT HAVING TO KEEP track of previous activity
[12:15:42] <Bytram> I look now and see $76.37
[12:15:51] <Bytram> how much came in this year, so far?
[12:15:56] <Bytram> depends on how much pulled before
[12:16:08] <Bytram> atm, I can pull down a couple pages and KNOW what it was
[12:16:20] <Bytram> with NO prior knowledge
[12:20:00] <Bytram> also, I would then have to check BOTH stripe AND paypal atm, to find total subs; right now it is all in one place.
[12:20:26] <Bytram> and, if we add another pmt method down the line, then would need to check over there, too. along with keeping track of their prior balance amounts, too.
[12:22:21] <TheMightyBuzzard> yes but we can NOT have access to the API on either PP or Stripe to pull that information in or we have to regularly get our setup inspected for data security purposes.
[12:22:58] <Bytram> oh... I see a miscommunication here. my bad
[12:23:42] <Bytram> I'm thinknig *strictly* of how to keep the community advised as to how the site is doing on meeting its funding needs...
[12:23:55] <Bytram> though I calc it to the penny, it is NOT intended to be authoritative -- IOW don't do our finances, taxes, etc. based on it.
[12:23:57] <TheMightyBuzzard> so we either have to get them to send us the simple information we're allowed to have without being inspected or we have to calculate it ourselves and hope they don't change it.
[12:24:42] <Bytram> yes, ideally, in the future, they should send us the NET amount... but we do not have that now.
[12:25:36] * Bytram needs more coffee
[12:25:38] <Bytram> back soon
[12:25:54] <TheMightyBuzzard> and if they do end up supplying it at a future date it means hours of work to write it then much cussing and an hour of work to undo it.
[12:50:23] <Bytram> sorry, got called away from kbd
[12:50:45] * Bytram does not understand... too many "it"s for this early in the AM.
[12:54:05] <Bytram> I think part of the problem is that I probably do not understand how much work is involved in adding a column? I'm sure it's been done many times before on the site; can do it one-time, manually, to make it active; update install script like has been done in past; default value "CC"; set to "BC" if payment type is "bitcoin".
[12:54:18] <Bytram> so, I am obviously missing something.
[12:55:02] <Bytram> as we have had NO BC transactions so far this year, that will suffice.
[13:32:38] <TheMightyBuzzard> adding a column is a few minutes work but i dislike altering the db so that we can misuse the subs page as an accurate data source.
[13:33:33] <TheMightyBuzzard> what's returned to us by the payment processors aside from paid or not paid is not something i trust.
[13:37:28] <Bytram> I DO NOT want to use it as an accurate payment source, either.
[13:37:37] <Bytram> As I see it, we need funds to run the site
[13:37:55] <Bytram> we would rather not have to post STORIES begging for funds
[13:38:21] <Bytram> the beg-o-meter gives our community an idea of where we stand; what we need vs what we've received.
[13:38:39] <Bytram> In no way doex the begometer claim to be "accountant certified"
[13:38:47] <Bytram> s/doex/does/
[13:38:47] <sedctl> <Bytram> In no way does the begometer claim to be "accountant certified"
[13:39:04] <Bytram> updating the begometer can be time-consuming
[13:39:26] <Bytram> scraping the subs page can be easily autmoated and get a number that can be plugged into the begometer
[13:39:50] <Bytram> the idea of adding BC support is to encourage people to send us money
[13:40:12] <Bytram> it is helpful to give the community an idea of how much money we need
[13:40:34] <Bytram> I seem to be the only one who has been updating the begometer since mrcool has been on hiatus
[13:41:06] <Bytram> I'm open to another means that can keep the begometer up-to-date that is simple and straightforward and not time consuming.
[13:41:37] <TheMightyBuzzard> that you can script, there isn't one.
[13:41:56] <Bytram> my ssh connection to the servers is problematic and often drops with no notice
[13:41:57] <TheMightyBuzzard> not without having to be audited regularly
[13:42:12] <Bytram> the begometer IS NOT OFFICIAL
[13:42:35] <Bytram> the treasurer gets the actual numbers from the stripe/paypal account page
[13:42:56] <Bytram> this is intended as a guide to the community that we need them to give us more moeny, cause this is about where we currently stand
[13:43:27] <TheMightyBuzzard> yes, i get this. but you're essentially asking for accurate net numbers.
[13:43:35] <Bytram> nope.
[13:43:51] <Bytram> amount we net is VERY different between BC and CC transactions
[13:43:59] <Bytram> just a BC/CC flag is all I need
[13:44:13] * TheMightyBuzzard shurgs
[13:44:34] <TheMightyBuzzard> aight, fine. it'll be a pain in the ass but i'll work it up.
[13:44:43] <Bytram> you da best!
[13:44:59] <TheMightyBuzzard> might as well flag paypal as PP or CC while i'm at it.
[13:45:12] <TheMightyBuzzard> no sense having an unused db column
[13:45:33] * Bytram has never used PP -- aren't they CC only?
[13:45:45] <Bytram> at least in how we recieve the funds, that is
[13:46:27] <TheMightyBuzzard> no, you can have money in an account with them and spend it that way or they can pull directly off a bank account or any number of methods.
[13:47:02] <Bytram> okaaay
[13:47:11] * TheMightyBuzzard swears and kicks the shit out of HandBrakeCLI
[13:47:28] * Bytram holds it down so TMB can get a better swing at it
[13:47:47] <TheMightyBuzzard> piece of shit won't accept audio bitrate supplied on the command line but the gui version works just fine.
[13:48:12] <Bytram> sense. no. makes.
[13:48:22] <Bytram> that is just plain dumb!
[13:48:27] <TheMightyBuzzard> but i goddamned well do not want to reencode a whole season of a tv show episode by episode in a gui
[13:49:02] * TheMightyBuzzard despises bugs
[13:49:26] <TheMightyBuzzard> oh, mysql is working on dev again
[13:49:34] <TheMightyBuzzard> the client i mean
[13:49:42] <Bytram> !woop
[13:49:42] <Bender> woop woop woop (\/) (;,,;) (\/)
[13:51:04] <TheMightyBuzzard> paulej72, plugin-removal/bitcoin patch pushed back for a bit to make things pretty for Bytram =P
[13:51:15] <Bytram> ~blame
[13:51:21] <TheMightyBuzzard> 404
[13:51:53] <TheMightyBuzzard> awe, he took me off the you can boss the bot around list
[13:53:07] <TheMightyBuzzard> *raw privmsg exec :~join #dev
[13:53:17] <TheMightyBuzzard> nope, won't listen to talos either
[13:54:25] <Bytram> Use the source, luke!^ TMB =)
[13:55:07] <Bytram> wrt handbrake, looks like there are plenty of audio options, including --ab (audio bitrate); see: https://handbrake.fr
[13:55:28] <Bytram> or, is this one of those cases where it accepts the parameter, but does not use it [correctly]?
[13:56:34] <Bytram> alternatively, it looks to me like you would be able to set up some *presets* in the GUI, export them, and then load em with the CLI
[13:57:14] <Bytram> brb, laundry
[13:57:51] <TheMightyBuzzard> ya, i'm well versed with how to pass the option it's just not accepting either -B or --ab.
[13:58:10] <TheMightyBuzzard> it simply ignores it and sets the output bitrate to 96k
[13:58:15] <Bytram> OH, previously had "payment_gross" on the subs page, pls keep it that way... no need to change THAT now.
[13:58:21] <Bytram> oh, ugh.
[13:58:42] <Bytram> and if you set it in a preset, does that get ignored, too?
[13:59:10] * TheMightyBuzzard shurgs
[13:59:43] <TheMightyBuzzard> using presets from the command line is kinda wizardry. i have yet to figure out which presets file it's reading from. there are three.
[14:01:57] <Bytram> if some complications are good, then more are better, eh?
[14:02:21] <Bytram> here's something you can throw at 'em. From their documentation: https://handbrake.fr
[14:02:38] <Bytram> >>
[14:02:38] <Bytram> For now, think about less complex stuff:
[14:02:38] <Bytram> HandBrakeCLI -i VIDEO_TS -o movie.mp4 -e x264 -q 20 -B 160
[14:02:38] <Bytram> That will encode a source video located at the path VIDEO_TS to an output file called movie.mp4. It will use x264 with a CRF (Constant Quality) of 20 to encode the video, and encode the audio as 160 Kbps AAC.
[14:02:38] <Bytram> <<
[14:03:41] <Bytram> afk, biab
[14:05:37] <TheMightyBuzzard> yarp.
[14:06:15] * TheMightyBuzzard starts preliminary work on adding submethod to subs page
[14:13:02] <Bytram> so, to make sure we are on the same "page", subs page would be same as it originally was EXCEPT, there will be a new column "sub_method" having values "CC" | "BC" ?? (Oh, and <a style="pmt_gross>$pmt_amount</td> would be nice)
[14:14:29] * Bytram is looking at what is on prod for guidance: https://soylentnews.org
[14:21:31] <TheMightyBuzzard> no, if i'm going to bother with it i'm going to go ahead and make a guess at the net.
[14:24:10] <Bytram> oh, nice!
[14:27:10] <Bytram> hmmm, looks like I may have had a calculation error in MY code. brb
[14:31:00] <Bytram> ahh, I misremembered? looks like overhead is 2.9% + $0.30; I had remembered 1.9% + $0.30
[14:31:12] * Bytram goes to check stripe docs
[14:31:54] <Bytram> https://stripe.com
[14:32:17] <Bytram> >> 2.9% + $0.30 per successful card charge
[14:33:47] <Bytram> "Credit & debit cards
[14:33:48] <Bytram> We charge a percentage-based fee each time you accept a credit or debit card payment. The price is the same for all major cards. There’s no additional fee for international cards, failed charges, or refunds. "
[14:34:17] <Bytram> also...
[14:34:18] <Bytram> Bitcoin logo
[14:34:18] <Bytram> ACH and Bitcoin payments
[14:34:18] <Bytram> ACH and Bitcoin fees are capped at $5—payments above $625 cost $5. We also provide tools to verify customers’ bank accounts at no additional cost. We charge $4 for failed ACH payments.
[14:35:35] <TheMightyBuzzard> Bytram, where'd you find that bitcoin fee rate again?
[14:36:06] <TheMightyBuzzard> nm, found it
[14:36:21] <Bytram> scroll back just a bit =) and here: https://stripe.com
[14:36:27] <Bytram> np, hth
[14:36:43] <TheMightyBuzzard> stoopid conditional math.
[14:36:52] <Bytram> lol, nod nod
[16:40:38] <Bytram> TheMightyBuzzard: btw, while you are in there, there is a bug with the "Prev Sub Payments >>" payments. :/
[16:40:56] <Bytram> go to the subs page: https://dev.soylentnews.org
[16:41:10] <Bytram> click on the "Prev Sub Payments>>" button
[16:41:15] <Bytram> seer previous page of subs displayed
[16:41:40] <Bytram> on THAT page, click on the "Prev Sub Payments>>" button, get same page redisplayed.
[17:11:47] -!- FatPhil has quit [Ping timeout: 276 seconds]
[17:12:44] -!- FatPhil [FatPhil!phil@azdr.ee] has joined #dev
[17:13:43] FatPhil is now known as SoyGuest62274
[18:44:52] <TheMightyBuzzard> Bytram, never monkeyed with days calculations. i'll have a look at it after a nap possibly.
[18:46:31] <Bytram> much obliged! enjoy you WELL-DESERVED nap!
[18:46:38] <Bytram> and... that sounds like a really good idea, too.
[18:47:08] * Bytram decides to prepare his lunch, and then take a nap, too.
[18:47:16] <Bytram> afk
[20:53:59] <Bytram> testing results for subscriptions can be found in #qa
[20:54:18] <Bytram> thanks a bunch for all your hard work this sunday am!
[20:54:22] * Bytram heads off for a nap