Encrypt/Decrypt MySQL database using PHPmyAdmin

I'm wondering if you can help me out. I've been working on a project that stores information about volunteers at my church. It is all managed through a control panel which is fine because username, passwords and permissions can be setup to give certa...
more »

2017-05-21 22:05 (1) Answers

What does fetching mean in computer science?

In some contexts I think it means "transferring data from one place to another". For example, using the python's sqlalchemy package the data from the sql database is "fetched" in order to be used by python. Are there other meanings and contexts? ...
more »

2017-05-21 16:05 (1) Answers

In memory SQLite3 shared database python

I am trying to make the best out of an aws server and had the idea to use an in memory database across multiple threads(using SQLite 3 in python) I found this command online: conn = sqlite3.connect('file::memory:?cache=shared') but then I get ...
more »

2017-05-20 21:05 (1) Answers

Problems assigning variables to SQLite Tuples

First off, I apologize if this seems elementary, I am fairly new to python and very new to SQlite. I also apologize for the wall of text, but I have gotten so much help from this site, that maybe someone else can learn from this issue as well. I hav...
more »

2017-05-19 23:05 (2) Answers

Android Room: How to model relationships?

I have just started working with Room and although everything seems to be pretty intuitive I currently don't really understand how exactly I could handle relationships. Because SQLite is a relational database, you can specify relationships betwee...
more »

2017-05-19 14:05 (0) Answers

Update MySQL database with Python 3

I'm trying to insert data from python into a MySQL database I made with phpmyadmin. I'm using Python 3. This doesn't seem to update my database - what's happening here? import MySQLdb db = MySQLdb.connect("localhost", "uname", "password", "HORSERAC...
more »

2017-05-19 14:05 (1) Answers

Android Room Persistences library and Kotlin

I am trying to write a simple app using Kotlin and Room Persistance Library. I followed the tutorial in the Android Persistance codelab. Here is my AppDatabase class in Kotlin: @Database(entities = arrayOf(User::class), version = 1) abstract class...
more »

2017-05-19 10:05 (3) Answers

Why indexes don't speed up this query?

I have two tables users and posts with 500k records each. I want to find users who had written between 100 and 200 posts. My query is: SELECT u.accountid, COUNT(*) FROM users u JOIN posts p ON u.accountid = p.owneruserid GROUP BY u.accountid HAVIN...
more »

2017-05-18 13:05 (2) Answers

Setting alias for each derived table in mysql

Since I got the same error type explained in some many other stackoverflow questions: MySQLSyntaxErrorException: Every derived table must have its own alias After carefully reading it including every single duplicate question (like this one for...
more »

2017-05-18 13:05 (1) Answers

Coalesce vs Sargability

The company that I work for uses a third party software, and we don't have any exposure to the application code, so I cannot change much the DB objects. I'm trying to do some work around in a view that is not Sarg, there is a coalesce to replace null...
more »

2017-05-17 13:05 (1) Answers