Add some tables to it, or don’t-it doesn’t matter. Create a new SQLite database using sqlite3 in Terminal (or even easier, use a GUI program). There are official instructions for doing this on Linux and Windows, but there’s nothing about doing it in OS X. The solutionįortunately there’s a way to use an SQLite database as the backend for LibreOffice Base using an ODBC driver, giving the best of both worlds: an open, universal, Java-free database behind a customizable form-based GUI. LibreOffice Base has excellent support for database-backed forms, but under the hood, LibreOffice uses the Java-based HSQLDB, which does not have native R and Python support and requires older Java runtime environments. I could use Python to program my own GUI (or even get fancy and learn Swift and make a native Cocoa app), but that seems like an excessive amount of work. There are plenty of SQLite viewers, but I haven’t found any that let you create Access-like forms. The only thing it lacks is a nice form-based GUI front end. SQLite is the best format, given that it’s the most widely deployed and used database engine and is open source and has native support in both R 1 and Python. However, finding the right combination of programs and formats has been slightly more difficult.
The format should be portable and not require an underlying server (sorry MongoDB and MySQL)-this way I can save the file in an encrypted file container for IRB data protection purposes.As I conduct interviews for my dissertation research, I’ve been trying to figure out an open source database for storing interview notes and keeping track of the people and organizations I’m talking to.
0 kommentar(er)
