4 ms·

/export?userId=x (make sure to validate they are logged in) gather data: select * from every table that has userId pack it into understandable format: every

/export?userId=x (make sure to validate they are logged in) gather data: select * from every table that has userId pack it into understandable format: every language i have used makes json, xml, csv pretty darn easy delete: delete from.... backups: i am surprised your hobby project takes backups. perhaps have a table with userIds that were deleted, and when you make your new backup, remove all their data?

jimktrains2 8y ago
> delete: delete from.... Ah yes, and then all of my data has holes in it that I need to deal with. "Hmm, we only have 5 orders for this, but we're missing 6". "hmmm, we charged this credit card, but there's no order for it and I'm not sure if we ever shipped anything?" "hmmm, how do I delete this tracking number from the postal systems' records?"
- esarbe 8y ago
  Then you have a legitimate reason for keeping some of the data (book keeping, shipping) and not for others. Delete the data you can, keep what you must.
  - jimktrains2 8y ago
    > Then you have a legitimate reason for keeping some of the data (book keeping, shipping) and not for others. Delete the data you can, keep what you must. Will regulators agree with what I "must" keep?
- ahartman00 8y ago
  I thought we were talking about hobby projects here? If you are shipping things, collecting payment info, you should be taking things seriously.
  - Karunamon 8y ago
    Since when does selling things exclude something from being a hobby?
    - nfoz 8y ago
      hmmm.. if we're going to draw a line between "hobby" and "profession", then that's perhaps the most obvious way to do it.
    - dwheeler 8y ago
      Etsy https://www.etsy.com/ https://www.etsy.com/ is full of shops of people who create things as a hobby, but do try to sell things. There are many hobbyist creators who make a few things and try to sell some of them, at least to recoup costs and maybe even earn a little money. In many cases I suspect they earn about $0.001/hour. As a business, it's terrible; as a hobby, many enjoy it. I think "earning a competitive wage" is a reasonable cutoff for at least being on the road to a "real" business.

jimktrains2 8y ago

> delete: delete from.... Ah yes, and then all of my data has holes in it that I need to deal with. "Hmm, we only have 5 orders for this, but we're missing 6". "hmmm, we charged this credit card, but there's no order for it and I'm not sure if we ever shipped anything?" "hmmm, how do I delete this tracking number from the postal systems' records?"

esarbe 8y ago
Then you have a legitimate reason for keeping some of the data (book keeping, shipping) and not for others. Delete the data you can, keep what you must.
- jimktrains2 8y ago
  > Then you have a legitimate reason for keeping some of the data (book keeping, shipping) and not for others. Delete the data you can, keep what you must. Will regulators agree with what I "must" keep?
ahartman00 8y ago
I thought we were talking about hobby projects here? If you are shipping things, collecting payment info, you should be taking things seriously.
- Karunamon 8y ago
  Since when does selling things exclude something from being a hobby?
  - nfoz 8y ago
    hmmm.. if we're going to draw a line between "hobby" and "profession", then that's perhaps the most obvious way to do it.
  - dwheeler 8y ago
    Etsy https://www.etsy.com/ https://www.etsy.com/ is full of shops of people who create things as a hobby, but do try to sell things. There are many hobbyist creators who make a few things and try to sell some of them, at least to recoup costs and maybe even earn a little money. In many cases I suspect they earn about $0.001/hour. As a business, it's terrible; as a hobby, many enjoy it. I think "earning a competitive wage" is a reasonable cutoff for at least being on the road to a "real" business.