Dec. 20th, 2011

A researcher into political behavior of the several psychological types people are classified as and he takes some drug that leaves him wheelchair bound to investigate a neighborhood and finds himself in danger because the entire neighborhood, has been made to be composed of one particular type.

It may have been anthologized in either World's Best Science Fiction: 1965 or Vonnegut's Welcome to the Money House.

It is prophetic both of The Big Sort and of Roger Ailes' career. Perhaps it inspired Ailes.
I have large CSVs I need to analyze. Some have over 100,000 lines, some have over 100 columns. So a spreadsheet is not going to cut it. The first rows are always column titles. I need to choose a database back-end and preferably good GUI front end (unless they come together, which I'm now very doubtful of.) I'd spend $40 for something that gets the job done. I'd spend $80 for something that has everything I want with a good, intuitive UI and documentation. But free is better if it's not too much of a hassle.

I'm running a Windows laptop with 4GB of memory. I don't need client-server, multiple users, optimization for read only access, or anything that web developers choose a database for. But I do need to crunch a lot of data without using more memory than I have. So it seems SQLite > PostgreSQL > MySQL. But I also need a facility to import the CSVs and with those 100+ columns, I want a wizard that will create the table and use the column names in the first row. It seems there are only two SQLite tools that do that, except one has that particular functionality currently broken and the other is very clunky and costs more than I want to pay for clunky.

LibreOffice Base's documentation (at least) regarding importing CSVs is also on the fritz and near as I can tell, the functionality is also totally missing after a reorganization of the UI. But OpenOffice/LibreOffice (if it works) is a 4th option for the back end, I suppose.

Profile

Dvd Avins

March 2020

S M T W T F S
123 4567
891011121314
15161718192021
22232425262728
293031    

Style Credit

Expand Cut Tags

No cut tags
Page generated Mar. 17th, 2026 01:07 am
Powered by Dreamwidth Studios