Specific examples are shown on the following individual pages, organized by classes and functions provided by SQLAlchemy, that are typically used when building your own applications.
The following open source projects can serve as example code for you as you build your own applications with SQLAlchemy.
databases (project homepage and PyPI page provides asyncio support with an SQLALchemy Core interface for common relational databases such as MySQL, PostgreSQL and SQLite. This is handy for integrating with asynchronous I/O web frameworks like Sanic. The project is open sourced under the BSD 3-Clause "New" or "Revised" License.
CTFd
(homepage) is a
capture the flag (CTF) hacking web app
built with SQLAlchemy and Flask.
The application can be used as-is to run CTF events, or the code can be
modified for custom rules on hacking scenarios. CTFd is open sourced under the
Apache License 2.0.
indico (project website, documentation and sandbox demo) is a Flask-based web app for event management that is powered by SQLAlchemy on the backend. The code for this project is open sourced under the MIT license.
sandman2 (project documentation and PyPI package information) is a code library for automatically generating RESTful APIs from existing database schemas. This approach is handy for solving straightforward situations where you want to put an abstraction layer between one or more applications and your relational database to prevent or reduce direct database access.
The sandman2 project is provided under the Apache License 2.0.
SQLAlchemy Example Projects and Code
SQLAlchemy Extensions, Plug-ins and Related Libraries
Flask Example Projects and Code
Flask Extensions, Plug-ins and Related Libraries
Django Example Projects and Code
Django Extensions, Plug-ins and Related Libraries
sqlalchemy.util.langhelpers symbol Example Code
sqlalchemy.util.langhelpers public_factory Example Code
sqlalchemy.util topological Example Code
sqlalchemy.util symbol Example Code
sqlalchemy.util set_creation_order Example Code
sqlalchemy.util OrderedSet Example Code
sqlalchemy.util OrderedDict Example Code
sqlalchemy.types to_instance Example Code
sqlalchemy.types UserDefinedType Example Code
sqlalchemy.types TypeEngine Example Code
sqlalchemy.types Time Example Code
sqlalchemy.types Text Example Code
sqlalchemy.types String Example Code
sqlalchemy.types NULLTYPE Example Code
sqlalchemy.types Interval Example Code
sqlalchemy.types Integer Example Code
sqlalchemy.types Float Example Code
sqlalchemy.types Enum Example Code
sqlalchemy.types DateTime Example Code
sqlalchemy.types Date Example Code
sqlalchemy.types Boolean Example Code
sqlalchemy.sql.visitors traverse Example Code
sqlalchemy.sql.util ClauseAdapter Example Code
sqlalchemy.sql.sqltypes NullType Example Code
sqlalchemy.sql.schema SchemaItem Example Code
sqlalchemy.sql.schema Column Example Code
sqlalchemy.sql.naming conv Example Code
sqlalchemy.sql.functions GenericFunction Example Code
sqlalchemy.sql.functions FunctionElement Example Code
sqlalchemy.sql.expression UnaryExpression Example Code
sqlalchemy.sql.expression FunctionElement Example Code
sqlalchemy.sql.expression Executable Example Code
sqlalchemy.sql.expression ColumnElement Example Code
sqlalchemy.sql.expression ColumnClause Example Code
sqlalchemy.sql.expression ClauseElement Example Code
sqlalchemy.sql.elements Label Example Code
sqlalchemy.sql.elements ColumnElement Example Code
sqlalchemy.sql.compiler SQLCompiler Example Code
sqlalchemy.sql table Example Code
sqlalchemy.sql sqltypes Example Code
sqlalchemy.sql schema Example Code
sqlalchemy.sql operators Example Code
sqlalchemy.sql functions Example Code
sqlalchemy.sql extract Example Code
sqlalchemy.sql expression Example Code
sqlalchemy.sql column Example Code
sqlalchemy.sql select Example Code
sqlalchemy.sql ClauseElement Example Code
sqlalchemy.schema Table Example Code
sqlalchemy.schema PrimaryKeyConstraint Example Code
sqlalchemy.schema Index Example Code
sqlalchemy.schema ForeignKeyConstraint Example Code
sqlalchemy.schema ForeignKey Example Code
sqlalchemy.schema DDLElement Example Code
sqlalchemy.schema CreateTable Example Code
sqlalchemy.schema CreateIndex Example Code
sqlalchemy.schema Column Example Code
sqlalchemy.schema CheckConstraint Example Code
sqlalchemy.pool StaticPool Example Code
sqlalchemy.pool NullPool Example Code
sqlalchemy.orm.util identity_key Example Code
sqlalchemy.orm.util AliasedInsp Example Code
sqlalchemy.orm.util AliasedClass Example Code
sqlalchemy.orm.session object_session Example Code
sqlalchemy.orm.session Session Example Code
sqlalchemy.orm.relationships RelationshipProperty Example Code
sqlalchemy.orm.query QueryContext Example Code
sqlalchemy.orm.query Query Example Code
sqlalchemy.orm.properties RelationshipProperty Example Code
sqlalchemy.orm.properties ColumnProperty Example Code
sqlalchemy.orm.mapper Mapper Example Code
sqlalchemy.orm.interfaces PropComparator Example Code
sqlalchemy.orm.interfaces MapperProperty Example Code
sqlalchemy.orm.exc UnmappedInstanceError Example Code
sqlalchemy.orm.exc UnmappedClassError Example Code
sqlalchemy.orm.exc NoResultFound Example Code
sqlalchemy.orm.collections InstrumentedList Example Code
sqlalchemy.orm.attributes flag_modified Example Code
sqlalchemy.orm.attributes QueryableAttribute Example Code
sqlalchemy.orm.attributes InstrumentedAttribute Example Code
sqlalchemy.orm strategies Example Code
sqlalchemy.orm sessionmaker Example Code
sqlalchemy.orm relationship Example Code
sqlalchemy.orm object_session Example Code
sqlalchemy.orm object_mapper Example Code
sqlalchemy.orm mapperlib Example Code
sqlalchemy.orm interfaces Example Code
sqlalchemy.orm composite Example Code
sqlalchemy.orm column_property Example Code
sqlalchemy.orm class_mapper Example Code
sqlalchemy.orm backref Example Code
sqlalchemy.orm attributes Example Code
sqlalchemy.orm aliased Example Code
sqlalchemy.orm SynonymProperty Example Code
sqlalchemy.orm session Example Code
sqlalchemy.orm RelationshipProperty Example Code
sqlalchemy.orm Query Example Code
sqlalchemy.orm mapper Example Code
sqlalchemy.orm Load Example Code
sqlalchemy.orm CompositeProperty Example Code
sqlalchemy.orm ColumnProperty Example Code
sqlalchemy.inspection inspect Example Code
sqlalchemy.ext.mutable Mutable Example Code
sqlalchemy.ext.hybrid hybrid_property Example Code
sqlalchemy.ext.hybrid hybrid_method Example Code
sqlalchemy.ext.declarative declarative_base Example Code
sqlalchemy.ext.declarative DeclarativeMeta Example Code
sqlalchemy.ext.compiler compiles Example Code
sqlalchemy.ext.automap automap_base Example Code
sqlalchemy.ext.associationproxy AssociationProxy Example Code
sqlalchemy.ext compiler Example Code
sqlalchemy.exc UnsupportedCompilationError Example Code
sqlalchemy.exc ProgrammingError Example Code
sqlalchemy.exc OperationalError Example Code
sqlalchemy.exc NoSuchTableError Example Code
sqlalchemy.exc NoInspectionAvailable Example Code
sqlalchemy.exc InvalidRequestError Example Code
sqlalchemy.exc IntegrityError Example Code
sqlalchemy.exc DatabaseError Example Code
sqlalchemy.exc DataError Example Code
sqlalchemy.exc ArgumentError Example Code
sqlalchemy.events SchemaEventTarget Example Code
sqlalchemy.engine.url make_url Example Code
sqlalchemy.engine.strategies MockEngineStrategy Example Code
sqlalchemy.engine.strategies EngineStrategy Example Code
sqlalchemy.engine.result RowProxy Example Code
sqlalchemy.engine.result ResultMetaData Example Code
sqlalchemy.engine.interfaces ExecutionContext Example Code
sqlalchemy.engine.default DefaultDialect Example Code
sqlalchemy.engine url Example Code
sqlalchemy.engine default Example Code
sqlalchemy.engine create_engine Example Code
sqlalchemy.engine Engine Example Code
sqlalchemy.engine Connection Example Code
sqlalchemy.dialects.sqlite pysqlite Example Code
sqlalchemy.dialects.postgresql.psycopg2 PGDialect_psycopg2 Example Code
sqlalchemy.dialects.postgresql.base PGTypeCompiler Example Code
sqlalchemy.dialects.postgresql.base PGIdentifierPreparer Example Code
sqlalchemy.dialects.postgresql.base PGCompiler Example Code
sqlalchemy.dialects.postgresql pypostgresql Example Code
sqlalchemy.dialects.postgresql TSVECTOR Example Code
sqlalchemy.dialects.postgresql JSON Example Code
sqlalchemy.dialects.postgresql INTEGER Example Code
sqlalchemy.dialects.postgresql ExcludeConstraint Example Code
sqlalchemy.dialects.postgresql DOUBLE_PRECISION Example Code
sqlalchemy.dialects.postgresql BIT Example Code
sqlalchemy.dialects.postgresql BIGINT Example Code
sqlalchemy.dialects.postgresql ARRAY Example Code
sqlalchemy.dialects.mysql pymysql Example Code
sqlalchemy.dialects sqlite Example Code
sqlalchemy.dialects postgresql Example Code
sqlalchemy.dialects oracle Example Code
sqlalchemy.dialects mysql Example Code
sqlalchemy.dialects mssql Example Code
sqlalchemy.databases mysql Example Code
flask.views http_method_funcs Example Code
flask.views MethodView Example Code
flask.templating render_template_string Example Code
flask.templating render_template Example Code
flask.signals got_request_exception Example Code
flask.signals Namespace Example Code
flask.sessions SessionMixin Example Code
flask.sessions SessionInterface Example Code
flask.sessions BadSignature Example Code
flask.json jsonify Example Code
flask.json JSONEncoder Example Code
flask.helpers url_for Example Code
flask.helpers send_file Example Code
flask.helpers safe_join Example Code
flask.helpers make_response Example Code
flask.helpers get_root_path Example Code
flask.helpers flash Example Code
flask.globals session Example Code
flask.globals request Example Code
flask.globals current_app Example Code
flask.ctx has_request_context Example Code
flask.ctx has_app_context Example Code
flask.ctx after_this_request Example Code
flask.cli with_appcontext Example Code
flask.cli pass_script_info Example Code
flask.cli ScriptInfo Example Code
flask.cli FlaskGroup Example Code
flask.cli DispatchingApp Example Code
flask.cli AppGroup Example Code
flask.blueprints Blueprint Example Code
flask.app ImmutableDict Example Code
flask.app Headers Example Code
flask.app BadRequest Example Code
django.views.static was_modified_since Example Code
django.views.static serve Example Code
django.views.i18n JavaScriptCatalog Example Code
django.views.generic.list MultipleObjectMixin Example Code
django.views.generic.list ListView Example Code
django.views.generic.edit FormView Example Code
django.views.generic.edit FormMixin Example Code
django.views.generic.edit DeletionMixin Example Code
django.views.generic.edit DeleteView Example Code
django.views.generic.edit CreateView Example Code
django.views.generic.detail SingleObjectMixin Example Code
django.views.generic.base View Example Code
django.views.generic.base TemplateView Example Code
django.views.generic.base TemplateResponseMixin Example Code
django.views.generic.base RedirectView Example Code
django.views.generic View Example Code
django.views.generic UpdateView Example Code
django.views.generic TemplateView Example Code
django.views.generic RedirectView Example Code
django.views.generic ListView Example Code
django.views.generic FormView Example Code
django.views.generic DetailView Example Code
django.views.generic DeleteView Example Code
django.views.generic CreateView Example Code
django.views.decorators.http require_POST Example Code
django.views.decorators.http require_GET Example Code
django.views.decorators.debug sensitive_post_parameters Example Code
django.views.decorators.csrf csrf_exempt Example Code
django.views.debug get_default_exception_reporter_filter Example Code
django.views csrf Example Code
django.utils.version get_complete_version Example Code
django.utils.translation ungettext_lazy Example Code
django.utils.translation ungettext Example Code
django.utils.translation ugettext_lazy Example Code
django.utils.translation ugettext Example Code
django.utils.translation pgettext_lazy Example Code
django.utils.translation pgettext Example Code
django.utils.translation override Example Code
django.utils.translation ngettext Example Code
django.utils.translation gettext_lazy Example Code
django.utils.translation gettext Example Code
django.utils.translation get_language_from_request Example Code
django.utils.translation get_language Example Code
django.utils.translation deactivate_all Example Code
django.utils.translation activate Example Code
django.utils.translation LANGUAGE_SESSION_KEY Example Code
django.utils.timezone timedelta Example Code
django.utils.timezone now Example Code
django.utils.timezone make_aware Example Code
django.utils.timezone get_current_timezone Example Code
django.utils.text slugify Example Code
django.utils.text get_valid_filename Example Code
django.utils.text get_text_list Example Code
django.utils.text format_lazy Example Code
django.utils.text capfirst Example Code
django.utils.text Truncator Example Code
django.utils.termcolors colorize Example Code
django.utils.safestring mark_safe Example Code
django.utils.safestring SafeText Example Code
django.utils.safestring SafeData Example Code
django.utils.numberformat format Example Code
django.utils.module_loading module_has_submodule Example Code
django.utils.module_loading import_string Example Code
django.utils.module_loading autodiscover_modules Example Code
django.utils.itercompat is_iterable Example Code
django.utils.ipv6 clean_ipv6_address Example Code
django.utils.http urlunquote Example Code
django.utils.http urlquote Example Code
django.utils.http urlencode Example Code
django.utils.http url_has_allowed_host_and_scheme Example Code
django.utils.http unquote Example Code
django.utils.http is_safe_url Example Code
django.utils.http int_to_base36 Example Code
django.utils.http http_date Example Code
django.utils.http base36_to_int Example Code
django.utils.html strip_tags Example Code
django.utils.html smart_urlquote Example Code
django.utils.html mark_safe Example Code
django.utils.html format_html_join Example Code
django.utils.html format_html Example Code
django.utils.html escapejs Example Code
django.utils.html escape Example Code
django.utils.html conditional_escape Example Code
django.utils.functional wraps Example Code
django.utils.functional total_ordering Example Code
django.utils.functional lazy Example Code
django.utils.functional keep_lazy Example Code
django.utils.functional SimpleLazyObject Example Code
django.utils.functional Promise Example Code
django.utils.functional LazyObject Example Code
django.utils.formats sanitize_separators Example Code
django.utils.formats localize_input Example Code
django.utils.formats get_format Example Code
django.utils.encoding uri_to_iri Example Code
django.utils.encoding smart_text Example Code
django.utils.encoding smart_str Example Code
django.utils.encoding smart_bytes Example Code
django.utils.encoding is_protected_type Example Code
django.utils.encoding iri_to_uri Example Code
django.utils.encoding force_text Example Code
django.utils.encoding force_str Example Code
django.utils.encoding force_bytes Example Code
django.utils.encoding filepath_to_uri Example Code
django.utils.encoding DjangoUnicodeDecodeError Example Code
django.utils.duration duration_string Example Code
django.utils.deprecation RenameMethodsBase Example Code
django.utils.deprecation MiddlewareMixin Example Code
django.utils.decorators method_decorator Example Code
django.utils.datetime_safe datetime Example Code
django.utils.dates MONTHS Example Code
django.utils.dateparse parse_duration Example Code
django.utils.dateparse parse_datetime Example Code
django.utils.datastructures MultiValueDict Example Code
django.utils.crypto get_random_string Example Code
django.utils.crypto constant_time_compare Example Code
django.utils.cache patch_vary_headers Example Code
django.utils.cache patch_response_headers Example Code
django.utils.cache patch_cache_control Example Code
django.utils.cache cc_delim_re Example Code
django.utils.cache add_never_cache_headers Example Code
django.utils tree Example Code
django.utils translation Example Code
django.utils.timezone Example Code
django.utils termcolors Example Code
django.utils module_loading Example Code
django.utils formats Example Code
django.utils datetime_safe Example Code
django.utils dateparse Example Code
django.utils dateformat Example Code
django.urls.exceptions Resolver404 Django Code Examples
django.urls.exceptions NoReverseMatch Python Code Examples
django.urls.reverse_lazy Example Code
django.urls reverse Example Code
django.urls resolve Example Code
django.urls register_converter Example Code
django.urls re_path Example Code
django.urls include Example Code
django.urls get_script_prefix Example Code
django.urls get_resolver Example Code
django.urls get_callable Example Code
django.urls clear_url_caches Example Code
django.urls URLResolver Example Code
django.urls URLPattern Example Code
django.template.response TemplateResponse Example Code
django.template.response SimpleTemplateResponse Example Code
django.template.base token_kwargs Example Code
django.template.base VariableNode Example Code
django.template.base VariableDoesNotExist Example Code
django.template.base TokenType Example Code
django.template.base Token Example Code
django.template.base TextNode Example Code
django.template.base TemplateSyntaxError Example Code
django.template.base Template Example Code
django.template.base Parser Example Code
django.template.base NodeList Example Code
django.template.base Node Example Code
django.template.base FilterExpression Example Code
django.template.base Context Example Code
django.shortcuts resolve_url Example Code
django.shortcuts render Example Code
django.shortcuts redirect Example Code
django.shortcuts get_object_or_404 Example Code
django.shortcuts get_list_or_404 Example Code
django.http HttpResponseRedirect Python Code Examples
django.http HttpResponsePermanentRedirect Python Code Examples
django.http Http404 Python Code Examples
django.http HttpResponseNotModified Python Code Examples
django.http HttpResponseForbidden Python Code Examples
django.http HttpResponseBadRequest Python Code Examples
django.http HttpResponse Python Code Examples
django.forms ValidationError Example Code
django.forms TypedChoiceField Python Code Examples
django.forms SelectMultiple Example Code
django.forms Select Example Code
django.forms MultipleChoiceField Example Code
django.forms ModelMultipleChoiceField Example Code
django.forms ModelForm Example Code
django.forms ModelChoiceField Example Code
django.forms MediaDefiningClass Example Code
django.forms Media Example Code
django.forms IntegerField Python Code Examples
django.forms ImageField Example Code
django.forms HiddenInput Example Code
django.forms Form Example Code
django.forms FilePathField Example Code
django.forms FileInput Example Code
django.forms Field Example Code
django.forms EmailField Python Code Examples
django.forms DateTimeField Code Examples
django.forms DateInput Example Code
django.forms DateField Python Code Examples
django.forms ChoiceField Python Code Examples
django.forms CheckboxSelectMultiple Example Code
django.forms CheckboxInput Example Code
django.forms CharField Python Code Examples
django.forms BooleanField Python Code Examples
django.forms BaseForm Example Code
django.dispatch Signal Example Code
django.db.models.signals pre_save Example Code
django.db.models.signals pre_delete Example Code
django.db.models.signals post_save Example Code
django.db.models.signals post_delete Example Code
django.db.models.query_utils Q Example Code
django.db.models.query_utils PathInfo Example Code
django.db.models.query_utils DeferredAttribute Example Code
django.db.models.query prefetch_related_objects Example Code
django.db.models.query QuerySet Example Code
django.db.models.query Q Example Code
django.db.models.query Prefetch Example Code
django.db.models.query ModelIterable Example Code
django.db.models.query EmptyQuerySet Example Code
django.db.models.query BaseIterable Example Code
django.db.models TextField Python Example Code
django.db.models SmallIntegerField Code Examples
django.db.models SlugField Example Code
django.db.models signal Example Code
django.db.models PositiveSmallIntegerField Python Code Examples
django.db.models PositiveIntegerField Example Code
django.db.models Model Example Code
django.db.models IntegerField Example Code
django.db.models ImageField Python Code Examples
django.db.models GenericIPAddressField Python Code Examples
django.db.models ForeignKey Python Code Examples
django.db.models FileField Example Code
django.db.models DateTimeField Example Code
django.db.models DateField Example Code
django.db.models CharField Example Code
django.db.models BooleanField Example Code
django.db.models AutoField Example Code
django.db.migrations.state ProjectState Example Code
django.db.migrations.operations.base Operation Example Code
django.db.migrations.loader MigrationLoader Example Code
django.db.migrations.loader MIGRATIONS_MODULE_NAME Example Code
django.db.migrations.executor MigrationExecutor Example Code
django.db.migrations.exceptions IrreversibleError Example Code
django.db.migrations.autodetector MigrationAutodetector Example Code
django.db.migrations RunPython Example Code
django.db.backends utils Example Code
django.db transaction Example Code
django.db migrations Example Code
django.db connections Example Code
django.db connection Example Code
django.db ProgrammingError Example Code
django.db OperationalError Example Code
django.db IntegrityError Example Code
django.db DatabaseError Example Code
django.db DataError Example Code
django.db DEFAULT_DB_ALIAS Example Code
django.core.exceptions ValidationError Example Code
django.core.exceptions SuspiciousMultipartForm Example Code
django.core.exceptions SuspiciousFileOperation Example Code
django.core.exceptions PermissionDenied Example Code
django.core.exceptions ObjectDoesNotExist Example Code
django.core.exceptions NON_FIELD_ERRORS Example Code
django.core.exceptions MiddlewareNotUsed Example Code
django.core.exceptions ImproperlyConfigured Example Code
django.core.exceptions FieldError Example Code
django.core.exceptions FieldDoesNotExist Example Code
django.core.exceptions DisallowedRedirect Example Code
django.core validators code examples
django.core signing code examples
django.core signals code examples
django.core serializers code examples
django.core.management.base BaseCommand Example Code
django.core management code examples
django.core.mail.messages EmailMessage Example Code
django.core.mail.send_mail Example Code
django.core mail code examples
django.core exceptions code examples
django.core checks code examples
django.core cache code examples
django.contrib.staticfiles.utils matches_patterns Example Code
django.contrib.staticfiles.storage staticfiles_storage Example Code
django.contrib.staticfiles.storage StaticFilesStorage Example Code
django.contrib.staticfiles.storage ManifestStaticFilesStorage Example Code
django.contrib.staticfiles.storage HashedFilesMixin Example Code
django.contrib.staticfiles.storage CachedStaticFilesStorage Example Code
django.contrib.staticfiles storage Example Code
django.contrib.staticfiles.handlers StaticFilesHandler Example Code
django.contrib.staticfiles.finders get_finders Example Code
django.contrib.staticfiles.finders find Example Code
django.contrib.staticfiles.finders BaseStorageFinder Example Code
django.contrib.staticfiles.finders BaseFinder Example Code
django.contrib.staticfiles finders Example Code
django.contrib.auth.hashers make_password Python Code Examples
django.contrib.auth.decorators login_required Example Python Code
django.contrib.auth get_user_model Example Code
django.contrib.admin.sites site code examples
django.contrib.admin.sites register Example Code
django.contrib.admin.sites NotRegistered code examples
django.contrib.admin.options csrf_protect_m code examples
django.contrib.admin.options ModelAdmin code examples
django.contrib.admin.options IncorrectLookupParameters code examples
django.contrib.admin.options IS_POPUP_VAR code examples
django.contrib.admin.helpers AdminForm Example Code
django.contrib.admin.helpers ActionForm Example Code
django.contrib.admin helpers Example Code
django.contrib.admin.filters SimpleListFilter Example Code
django.contrib.admin Example Code
django.conf.urls.url Example Code