sqlite   10905

« earlier    

SchemaCrawler - Free database schema discovery and comprehension tool
SchemaCrawler is a free database schema discovery and comprehension tool. SchemaCrawler has a good mix of useful features for data governance. You can search for database schema objects using regular expressions, and output the schema and data in a readable text format. The output serves for database documentation, and is designed to be diff-ed against other database schemas. SchemaCrawler also generates schema diagrams. You can execute scripts in any standard scripting language against your database. You can find potential schema design issues with lint.

SchemaCrawler supports almost any database that has a JDBC driver, but for convenience is bundled with drivers for some commonly used RDBMS systems. SchemaCrawler works with any operating system that supports Java SE 8, Compact Profile 2 or better.
schema  database  visualization  sqlite  data  databases  diagramm  graphviz  201903  via:ramses0 
yesterday by jakoubek
DB Browser for SQLite
Pretty good app actually. Use it to open sqlite .db or .sqlite files. Works on MacOS High Sierra as of March 20, 2019. You can even run SQL queries on it.
sqlite  sqlite3  browser  app  macos  client  database  program  macosx 
2 days ago by racl101
dbcli/litecli: CLI for SQLite Databases with auto-completion and syntax highlighting
A command-line client for SQLite databases that has auto-completion and syntax highlighting.
database  sqlite  tools 
3 days ago by bouvin
How to Organize Your Messy Albums on Photos.app on macOS with Some SQL and Image Processing
Conclusion
While the SQL is cool enough, it does not allow you to have write access to iCloud. The current PhotoKit on MacOS only allows read-only access. I hope there was an API, so I could do some of the stuff programatically, especially removing the bad quality Photos automatically. My long-term plan is to learn some iOS programming and do these kind of analysis in the app by requesting metadata and thumbnails and, maybe even work with some MLKit magic to cluster my photos.
MacOS  photos.app  sqlite  OpenCV  sql  sysadmin 
5 days ago by euler
VisiData
This looks absolutely bonkers... and hugely lightweightly powerful: #ddj /via @simonw (I w…
data  tool  terminal  utility  sqlite  datasette  ddj 
5 days ago by psychemedia
SQLite / Excel
Excel addin/VBA to let you use sqlite from within Excel.
excel  addin  vba  sqlite 
6 days ago by ktr
JoshuaWise/better-sqlite3: The fastest and simplest library for SQLite3 in Node.js.
The fastest and simplest library for SQLite3 in Node.js. - JoshuaWise/better-sqlite3
sqlite  sqlLite 
6 days ago by ElliotPsyIT

« earlier    

related tags

2013  201902  201903  addin  admin  administration  android  api  app  application  apt-get  apt  architecture  artisan  askubuntu  automation  backup  blog  blogthis  browser  build-your-own  business  c++  c  cheap  citrix  cli  client  command-line  commandline  computer-science  connect  crash  crossplatform  cryptography  csv  cte  data  data2sql  dataanalysis  database  databases  dataengineering  datascience  datasette  db  dba  dbcli  ddj  dev  development  devops  diagramm  dietpi  difference  documentation  driver  eloquent  emacs  environment  error  example  excel  exception  explanation  explore  extension  extract  extraction  file  fileformat  fileformats  firebird  fix  flask  format  forumthread  foss  free  germany  github  go  golang  graph  graphviz  gui  guide  hardware  hardwaresupport  howto  ide  imessage  ios  iphone  issue  java  json  keyvalue  kobo.reader.app  kobo.reader  laravel  laravel5  learning  library  linux  litecli  logging  mac  macos  macosx  matplotlib  message  messages  mobilereading  mosquitto  mqtt-broker  mqtt  mysql  node-red-dashboard  node-red  open-source  opencv  opendata  opensource  oracle  orm  osx  pandas  path  photos.app  photos  php  phpliteadmin  postgres  postgresql  process  program  programming  project  publicata  python  qt  query  raspberry_pi  recursive  redis  reference  scale  scargill_peter  schema  shell  smart_home  sms  software  softwaredev  sourcecode  sql  sqlalchemy  sqlite3  sqlite_admin  sqllite  sqlserver  stackexchange  stackoverflow  swift  sysadmin  terminal  text  texts  tips  tolearn  tool  toolkit  tools  toread  tounderstand  tr-2019-02  tr-2019-03  troubleshoot  tutorial  ubuntu  ubuntu16.04  unix  utility  vba  video  view  visualization  web  webapplication  webdev  webdevelopment  workaround  xls  zero_w 

Copy this bookmark:



description:


tags: