records

Records is a minimalist Python library that allows sending raw SQL queries to relational databases. It allows you to query, cache, and export data in different formats using the SQLAlchemy and Tablib infrastructure. RedShift supports Postgres, MySQL, SQLite, Oracle, and MS-SQL database systems.

RE

kennethreitz · ORM & Database Tooling

STARS7.2K
FORKS569
COMMITS0
CONTRIBUTORS0
VERSIONv0.6.0
UPDATED8 mo ago
PythonSQLDatabaseTablibISC
What can it do?
  • You can send raw SQL queries to the database and list the results in rows.
  • You can export query results to CSV, JSON, YAML, Excel or Pandas DataFrame format.
  • You can perform batch query operations with secure parameterization and transaction support.
User reviews
  • • NeutralHacker News

    Launch HN: 70MillionJobs (YC S17) – Job board for people with criminal records

    “"Many American citizens have a criminal record for the crime of being an American citizen." It's better to have the tone of people owning up to their actions and then moving forward rather than saying the US is just giving out criminal records like candy and it's not anybody's…”

  • • NeutralGitHub Issue

    use Postgres.py under the hood

    “Over in Gratipay-land we've got a library called [Postgres.py]( that has a very similar scope to Records-the-library (it has no CLI). It's been in production for three or four years, and as you [say]( it's "much more robust" than Records from an API point of view. I know you're…”

My note

More in: ORM & Database Tooling