[Unimportant] Old Python 2.7 Users: Anyway to shrink the local .rdbms / reduce it's size?

[Kaan Soral]

Hi Old Python 2.7 App Engine users,

I have an unimportant question, maybe one of you figured it out

My db.rdbms on one project is 200mb's, on another 600mb's, they both spin up instantly locally, so it doesn't matter too much, but I decided to delete unimportant entries, reduce the db size, however it seems to never reduce in size (Deleted every entry in 2 large tables, before 215.1MB's, after 215.1MB's :/)

Any insight?

[vioqueojeda]

Hi, Could you please elaborate further on which GCP database system are you using?

[Kaan Soral]

Whatever system the old dev_appserver.py is using, I forgot the technology

[Alex Martelli]

On Mon, Jun 22, 2020 at 9:08 AM Kaan Soral <kaan...@gmail.com> wrote:

Whatever system the old dev_appserver.py is using, I forgot the technology

I think it's sqlite, in which case you may want to try (on a copy of your files) "vacuum". per https://stackoverflow.com/questions/7682503/how-to-shrink-sqlite-database , with an sqlite CLI like per https://sqlite.org/cli.html .

Alex 

--
You received this message because you are subscribed to the Google Groups "Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-appengi...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/dd2c8fa3-784f-4cad-a46b-05b68b0c3abbo%40googlegroups.com.

[Kaan Soral]

Thank you so much Alex, dropped from 215 to 10 :)

[Alex Martelli]

Always glad to help!

Alex

On Mon, Jun 29, 2020 at 7:29 AM Kaan Soral <kaan...@gmail.com> wrote:

Thank you so much Alex, dropped from 215 to 10 :)

--

You received this message because you are subscribed to the Google Groups "Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-appengi...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/d9995509-fffb-41ad-a685-a770902bca6bo%40googlegroups.com.