we have not had a plane blow up into buildings since, so something must be working. yes, it's also inconvenient.

That's specious reasoning. I have a rock that keeps tiger away. How does it work? It doesn't, it's just a stupid rock. But I don't see any tigers around here, do you?

Yea they added flight deck doors that you can’t get through and a policy that the doors stay closed through a flight. The TSA did nothing to help, the planes are a hard target now.

Or the threat has subsided. Not saying get rid of security, but I think it’s okay to allow water bottles again.

> we have not had a plane blow up into buildings since, so something must be working

Yeah, 10 minutes after the event every person on earth now knows the best strategy is to rush the cockpit, not sit calmly and wait for the hijackers to ask for a ransom, which was the previous norm.

Between that and reinforced concrete doors flying planes into buildings is no longer a viable strategy.

Reinforced cockpit doors have backfired in pilot murder suicides on Germanwings 9525, LAM470, MH370, CES5735. It’s not the silver bullet..

Can someone tell me how this is collected in SQLite

I wrote a blog post a while back about reading these dumps: https://search.feep.dev/blog/post/2021-09-04-stackexchange

Presumably they have a script that does something similar to that process, and then writes the resulting data into a predefined table structure.

Nice post!

Yep, my process is similar. It goes...

  - decompress (users|posts)  
  - split into batches of 10,000  
  - xsltproc the batch into sql statements  
  - pipe the batches of statements into sqlite in parallel using flocks for coordination

On my M1 Max it takes about 40 minutes for the whole network. Then I compress each database with brotli which takes about 5 hours.

use google takeout.

I'd guess that the emphasis in OP's reply was on 'actually work'.

In case it's useful, here's the solution that worked for me the last time I tried it:

1. Takeout to Google Drive :grimace:

2. rclone from Google Drive

But I do this around once a year, and the last few times there are new roadblocks every time.

I made the same bet with cloudways which is now owned by digitalocean. they filled a gap for me, and I was ok if they decided to close shop; I am glad it didn't go that direction, and they are part of a bigger company that also was once a small company, but they are now publicly traded. you make your bets...

haha, that was questionable for me as well. It's ok for Grammarly to read your stuff, but crash metadata is a no no.

Welcome to security in 2023 :)

Easy for sec to identify affiliation to Splunk for this call.

What's the chance the sec will go after this? I guess they don't have the capacity to go after all these cases, even the clear cut ones

I think the SEC loves cut and dry cases like this. You see enforcement actions all the time about similar situations. Usually some VP of one of the two companies is behind it and they amateurishly try to cover their trails by getting their brother to do the trade, or using their mother-in-law's account, etc.

IMO though it could easily be just some WSB bro that gambled and got lucky. Robinhood and other platforms make it easy to trade short dated options these days and people love to gamble on them.

The SEC is 100% on the case right now. They catch people all the time doing much smaller version of this.

They'll investigate this. It's an easy target.

> What's the chance the sec will go after this?

100%

I learned alot today. #win

yea worked for me till I hit 40

sounds good. put me back into the office with far less meetings then jumping from zoom meeting to another...

I wish retool had two things, more granular permissions for users on team plan. right now this is reserved for enterprise. I can not simply share only specific apps to certain users.

I wish to be able to pay yearly. We are on a hosted solution.

(Retool employee here.) Based on how we see companies using the different plans, we have a couple of delineations between the monthly and yearly plans. Happy to chat with you about your specific use case and discuss pricing/plan options! I’m tommy@retool.com