Commit Graph

36 Commits

Author SHA1 Message Date
Ted Unangst 386dc6f798 fix slow public queries with a special index just for you 2023-09-11 21:34:05 -04:00
Ted Unangst a08e0d0cb8 create a plain column and use that for search 2023-07-31 19:46:55 -04:00
Ted Unangst 497c9c15e7 prepare to save id for follow requests 2020-08-10 15:15:11 -04:00
Ted Unangst a48f58fbec save donks for chonks 2020-05-14 23:51:42 -04:00
Ted Unangst 74b55fec6f Boing boom tschak chonky chatter 2020-05-13 17:15:29 -04:00
Ted Unangst fc21e23207 add notes to honkers as well 2019-12-02 18:26:29 -05:00
Ted Unangst c9aba7ecba save timestamp for xonker additions 2019-11-25 15:50:17 -05:00
Ted Unangst 797685377d initial steps towards fetch tracking 2019-11-08 14:50:57 -05:00
Ted Unangst f502872a48 tighten up some of the new honker handling 2019-10-26 19:13:27 -04:00
Ted Unangst 3f67140c76 rework delivery and key loading to use userid 2019-10-25 18:46:27 -04:00
Ted Unangst 77de84d5a0 forgot to add expiry column 2019-10-20 17:03:46 -04:00
Ted Unangst de36230cec enough of the honk filtering and censoring system (hfcs) to get going. 2019-10-04 16:30:33 -04:00
Ted Unangst 1595e1f9de save honkmeta in a generic table since it seems we're gonna have plenty of it 2019-10-02 17:10:01 -04:00
Ted Unangst dbe8a3c55c split media into separate database. keeps main db nice and tidy. 2019-09-29 21:40:37 -04:00
Ted Unangst 0d0a5677a0 add url to places 2019-09-29 16:07:35 -04:00
Ted Unangst 2cfa3a71e2 location checkins! waaahahaha 2019-09-28 00:12:50 -04:00
Ted Unangst 69a235a3d1 don't store exploded onts in honks 2019-09-22 17:00:14 -04:00
Ted Unangst b8df8a9b93 beta/prototype of Update 2019-09-16 18:00:13 -04:00
Ted Unangst ead0b2995e i think this is enough for image descriptions 2019-09-09 09:55:04 -04:00
Ted Unangst f74b91e15b we're starting to get there with hashtags 2019-08-24 23:03:05 -04:00
Ted Unangst 840224e3b9 schema change to add flags to honks 2019-08-16 15:13:33 -04:00
Ted Unangst 9c20a5c321 more queries, more indices. index oonker 2019-07-09 23:45:50 -04:00
Ted Unangst 5e59b3ecef allow for custom user options in the database 2019-06-27 22:15:59 -04:00
Ted Unangst 1af6a3a70b pubkey no longer stored in honkers table 2019-06-13 22:34:05 -04:00
Ted Unangst f29f31d32c less awkard use of xonkers table 2019-06-03 00:15:06 -04:00
Ted Unangst dcc055ace1 cleanup images after 30 days if we don't need them 2019-05-25 13:34:41 -04:00
Ted Unangst 90c7001e15 rework honk schema to store more information.
add original honker for bonks.
add separate precis field for summary.
add format to prepare for changing how html is saved.
2019-05-15 16:27:50 -04:00
Ted Unangst cf9a144a6c add combos for the micromanagement of friends 2019-04-22 17:03:55 -04:00
Ted Unangst 770e57797e @me page just for me 2019-04-20 11:17:00 -04:00
Ted Unangst 0e78b38ea0 oops, only need to create idx once, from qbit 2019-04-19 22:49:56 -04:00
Ted Unangst b2b21b9ba6 going to need userid in zonkers table too 2019-04-19 22:34:39 -04:00
Ted Unangst b5249fd53d schema updates for future changes. xonkers, zonkers, and convoys, oh my. 2019-04-19 11:08:22 -04:00
Ted Unangst c7c5001e53 lower case all the sql 2019-04-19 10:41:21 -04:00
Ted Unangst bf323bd0e5 the spice must flow. redeliverate with extreme prejudice. 2019-04-14 21:35:42 -04:00
Ted Unangst babd61874d audience missing from schema. from mastodon.social/@a13x 2019-04-10 04:30:38 -04:00
Ted Unangst 7420c88f84 maybe 0.1 2019-04-09 07:59:33 -04:00