Anko SQLite, a library to simplify working with SQLite on Android

Re:Anko SQLite, a library to simplify working with SQLite on... by akvadrako on Thursday September 21, 2017 @10:45AM (#15303926)

SQLite does not work smoothly in many languages (like python) in regards to concurrent access. Without a controlling process (or thread) it's synchronisation possibilities are limited, so it can never scale too far.

Nonetheless I think it's a great idea to build your own single-threaded layer over SQLite and scale that, using a message bus or whatever.

But it's _not_ a drop-in replacement for MySQL based apps.

[ Parent | on HN ]

Re:Anko SQLite, a library to simplify working with SQLite on... by hasenj on Thursday September 21, 2017 @08:30PM (#15308460)

Yea my hunch/hypothesis does not apply to slow languages like python. That's why I said a fast language that's compiled to native binaries. For example, D, Swift, or Go.

[ Parent | on HN ]

Re:Anko SQLite, a library to simplify working with SQLite on... by ageofwant on Thursday September 21, 2017 @11:01AM (#15304104)

SQLAlchemy with transactions on SQLite should get you very close, probably close enough.

[ Parent | on HN ]

Re:Anko SQLite, a library to simplify working with SQLite on... by infecto on Thursday September 21, 2017 @11:23AM (#15304352)

Why get very close when I can just spin up a single micro RDS instance of MySQL or Postgres and not have to worry about it?

[ Parent | on HN ]

Re:Anko SQLite, a library to simplify working with SQLite on... by marktangotango on Thursday September 21, 2017 @11:55AM (#15304726)

Whoa! That's nearly $20 a month, if you're past the free tier, which you will be if you're not already. Edit that's t1.micro, t2 is $13.

[ Parent | on HN ]

Re:Anko SQLite, a library to simplify working with SQLite on... by infecto on Thursday September 21, 2017 @12:52PM (#15305313)

Not sure how other people do it but 1 micro RDS serves many projects for me. Well worth the money for me.

[ Parent | on HN ]