http://simonwillison.net/2024-10-09T15:22:04+00:00Simon Willison2024-10-09T15:22:04+00:002024-10-09T15:22:04+00:00https://simonwillison.net/2024/Oct/9/otterwiki/#atom-tag

<p><strong><a href="https://github.com/redimp/otterwiki">otterwiki</a></strong></p> It's been a while since I've seen a new-ish Wiki implementation, and this one by Ralph Thesen is really nice. It's written in Python (Flask + SQLAlchemy + <a href="https://github.com/lepture/mistune">mistune</a> for Markdown + <a href="https://github.com/gitpython-developers/GitPython">GitPython</a>) and keeps all of the actual wiki content as Markdown files in a local Git repository.</p> <p>The <a href="https://otterwiki.com/Installation">installation instructions</a> are a little in-depth as they assume a production installation with Docker or systemd - I figured out <a href="https://github.com/redimp/otterwiki/issues/146">this recipe</a> for trying it locally using <code>uv</code>:</p> <pre><code>git clone https://github.com/redimp/otterwiki.git cd otterwiki mkdir -p app-data/repository git init app-data/repository echo "REPOSITORY='${PWD}/app-data/repository'" &gt;&gt; settings.cfg echo "SQLALCHEMY_DATABASE_URI='sqlite:///${PWD}/app-data/db.sqlite'" &gt;&gt; settings.cfg echo "SECRET_KEY='$(echo $RANDOM | md5sum | head -c 16)'" &gt;&gt; settings.cfg export OTTERWIKI_SETTINGS=$PWD/settings.cfg uv run --with gunicorn gunicorn --bind 127.0.0.1:8080 otterwiki.server:app </code></pre> <p><small></small>Via <a href="https://news.ycombinator.com/item?id=41749680">Hacker News</a></small></p> <p>Tags: <a href="https://simonwillison.net/tags/flask">flask</a>, <a href="https://simonwillison.net/tags/git">git</a>, <a href="https://simonwillison.net/tags/python">python</a>, <a href="https://simonwillison.net/tags/sqlalchemy">sqlalchemy</a>, <a href="https://simonwillison.net/tags/sqlite">sqlite</a>, <a href="https://simonwillison.net/tags/markdown">markdown</a>, <a href="https://simonwillison.net/tags/wikis">wikis</a>, <a href="https://simonwillison.net/tags/uv">uv</a></p>

2021-08-24T23:16:42+00:002021-08-24T23:16:42+00:00https://simonwillison.net/2021/Aug/24/sqlmodel/#atom-tag

<p><strong><a href="https://github.com/tiangolo/sqlmodel">SQLModel</a></strong></p> A new project by FastAPI creator Sebastián Ramírez: SQLModel builds on top of both SQLAlchemy and Sebastián’s Pydantic validation library to provide a new ORM that’s designed around Python 3’s optional typing. The real brilliance here is that a SQLModel subclass is simultaneously a valid SQLAlchemy ORM model AND a valid Pydantic validation model, saving on duplicate code by allowing the same class to be used both for form/API validation and for interacting with the database. <p>Tags: <a href="https://simonwillison.net/tags/orm">orm</a>, <a href="https://simonwillison.net/tags/python">python</a>, <a href="https://simonwillison.net/tags/sql">sql</a>, <a href="https://simonwillison.net/tags/sqlalchemy">sqlalchemy</a>, <a href="https://simonwillison.net/tags/pydantic">pydantic</a></p>

2010-08-26T10:52:00+00:002010-08-26T10:52:00+00:00https://simonwillison.net/2010/Aug/26/does-sqlalchemy-depend-on/#atom-tag

<p><em>My answer to <a href="https://www.quora.com/Does-SQLAlchemy-depend-on-MySQLdb/answer/Simon-Willison">Does SQLAlchemy depend on MySQLdb?</a> on Quora</em></p> <p>No. SQLAlchemy can talk to all sorts of different DB-API compliant backends, including MySQL Connector/J (Jython only), MySQL Connector/Python, mysql-python (the MySQLdb module) and OurSQL - plus backends for many other databases. See the full list here:</p> <span><a href="http://www.sqlalchemy.org/docs/dbengine.html#supported-dbapis">http://www.sqlalchemy.org/docs/d...</a></span> <p>Tags: <a href="https://simonwillison.net/tags/python">python</a>, <a href="https://simonwillison.net/tags/sqlalchemy">sqlalchemy</a>, <a href="https://simonwillison.net/tags/quora">quora</a></p>

2007-10-09T02:30:29+00:002007-10-09T02:30:29+00:00https://simonwillison.net/2007/Oct/9/tranquil/#atom-tag

<p><strong><a href="http://code.google.com/p/tranquil/">tranquil</a></strong></p> Inspired take on the Django ORM to SQLAlchemy problem: lets you define your models with the Django ORM but use SQLAlchemy to run queries against them. <p>Tags: <a href="https://simonwillison.net/tags/django">django</a>, <a href="https://simonwillison.net/tags/djangoorm">djangoorm</a>, <a href="https://simonwillison.net/tags/models">models</a>, <a href="https://simonwillison.net/tags/orm">orm</a>, <a href="https://simonwillison.net/tags/python">python</a>, <a href="https://simonwillison.net/tags/sqlalchemy">sqlalchemy</a>, <a href="https://simonwillison.net/tags/tranquil">tranquil</a></p>

2007-02-12T22:28:05+00:002007-02-12T22:28:05+00:00https://simonwillison.net/2007/Feb/12/elixir/#atom-tag

<p><strong><a href="http://cleverdevil.org/computing/51/say-hello-to-elixir-for-sqlalchemy">Say Hello to Elixir for SQLAlchemy</a></strong></p> New ActiveRecord style layer over SQLAlchemy; a collaboration that includes the authors of ActiveMapper and TurboEntity. <p>Tags: <a href="https://simonwillison.net/tags/elixir">elixir</a>, <a href="https://simonwillison.net/tags/python">python</a>, <a href="https://simonwillison.net/tags/sqlalchemy">sqlalchemy</a></p>

2007-01-23T13:43:19+00:002007-01-23T13:43:19+00:00https://simonwillison.net/2007/Jan/23/pickles/#atom-tag

<p><strong><a href="http://wiki.list.org/display/COM/2006/12/29/Pickles Begone">Pickles Begone</a></strong></p> Barry Warsaw’s notes on adding SQLAlchemy persistence to Mailman. <p>Tags: <a href="https://simonwillison.net/tags/barry-warsaw">barry-warsaw</a>, <a href="https://simonwillison.net/tags/mailman">mailman</a>, <a href="https://simonwillison.net/tags/python">python</a>, <a href="https://simonwillison.net/tags/sqlalchemy">sqlalchemy</a></p>