Rezoom.SQL
Statically typechecks a common SQL dialect and translates it to various RDBMS backends
File Explorer
Download Latest Version (.zip)- ci.yml
- setup.scss
- pack-dev.ps1
- pack-parents.ps1
- pack-release.ps1
- regen-doc-nav.ps1
- appsettings.json
- AssemblyInfo.fs
- Common.fs
- DemoSetup.fs
- Domain.fs
- Domain.fsi
- Execution.fs
- FileSystem.fsproj
- packages.config
- Persistence.fs
- Persistence.fsi
- Program.fs
- rzsql.json
- V1.model.sql
- appsettings.json
- Common.cs
- DemoSetup.cs
- Domain.cs
- Entities.cs
- FileSystem.EFVersion.csproj
- FileSystemDbContext.cs
- Persistence.cs
- Program.cs
- QueryCounterInterceptor.cs
- FileSystem.sln
- App.config
- AssemblyInfo.fs
- Domain.fs
- Domain.fsi
- Model.fs
- packages.config
- Persistence.fs
- Persistence.fsi
- rzsql.json
- SQLFiddle.fsproj
- V1.model.sql
- FiddleApiController.cs
- launchSettings.json
- Site.css
- ace.js
- jquery-3.7.1.min.js
- mode-sql.js
- theme-katzenmilch.js
- theme-sqlserver.js
- index.html
- appsettings.json
- Program.cs
- SQLFiddle.Website.csproj
- SQLFiddle.sln
- README.md
- RezoomSQL.md
- RezoomSQLAsynchronous.md
- RezoomSQLMigrations.md
- RezoomSQLPlans.md
- RezoomSQLSynchronous.md
- Configuration.md
- Json.md
- MigrationTree1.gv
- MigrationTree1.gv.svg
- MigrationTree2.gv
- MigrationTree2.gv.svg
- MigrationTree3.gv
- MigrationTree3.gv.svg
- MigrationTree4.gv
- MigrationTree4.gv.svg
- MigrationTreeComplex.gv
- MigrationTreeComplex.gv.svg
- MigrationTrees.md
- README.md
- AlterTable.svg
- ColumnConstraint.svg
- ColumnDef.svg
- ColumnName.svg
- CommonTableExpression.svg
- CompoundExpr.svg
- CreateTable.svg
- CreateView.svg
- DeleteStmt.svg
- DeleteStmtSimple.svg
- DropStmt.svg
- Expr.svg
- ForeignKeyClause.svg
- generate_diagrams.py
- InsertStmt.svg
- Literal.svg
- Name.svg
- ObjectName.svg
- railroad_diagrams.py
- RailroadDemo.svg
- SelectCore.svg
- SelectProperty.svg
- SelectStmt.svg
- TableConstraint.svg
- TableExpr.svg
- TypeName.svg
- UpdateStmt.svg
- UpdateStmtSimple.svg
- WhitespaceOrComment.svg
- PostgresFunctions.md
- README.md
- SQLiteFunctions.md
- TSQLFunctions.md
- PostgresQuirks.md
- README.md
- SQLiteQuirks.md
- TSQLQuirks.md
- AlterTableStmt.md
- CommonTableExpression.md
- CreateTableStmt.md
- CreateViewStmt.md
- DataTypes.md
- DeleteStmt.md
- DropStmt.md
- DynamicSQL.md
- Expr.md
- InsertStmt.md
- Literal.md
- MissingFeatures.md
- Name.md
- NavigationProperties.md
- README.md
- SelectStmt.md
- TypeHierarchy.gv
- TypeHierarchy.gv.svg
- UpdateStmt.md
- VendorStatements.md
- ConcurrentExecution.gv
- ConcurrentExecution.gv.png
- GroupByError.png
- ModelChange.gif
- NoTableError.png
- Queries.gif
- SequentialExecution.gv
- SequentialExecution.gv.png
- TypeMismatch.png
- README.md
- AddingMigrations.md
- Async.md
- LoadingNestedObjects.md
- README.md
- SwitchBackends.md
- AdvancedMapping.md
- AttributesReference.md
- FieldLengthsAndStorage.md
- Pitfalls.md
- README.md
- SolutionLayout.gv
- SolutionLayout.gv.svg
- RawBackendSQLTypeAttribute.cs
- README.md
- Rezoom.SQL.Annotations.csproj
- SQLParameterDbTypeAttribute.cs
- SQLTypeLengthAttribute.cs
- AggregateChecker.fs
- AssemblyInfo.fs
- AST.fs
- ASTMapping.fs
- Backend.fs
- BackendUtilities.fs
- CommandEffect.fs
- ComplexModelOps.fs
- Config.fs
- CoreParser.fs
- DefaultBackend.fs
- DefaultExprTranslator.fs
- DefaultFunctions.fs
- DefaultLiteralTranslator.fs
- DefaultStatementTranslator.fs
- Error.fs
- ExprInfo.fs
- ExprTypeChecker.fs
- FunctionDeclarations.fs
- InferredTypes.fs
- Model.fs
- ModelChange.fs
- ModelOps.fs
- Name.fs
- Parser.fs
- Postgres.fs
- Postgres.Functions.fs
- Postgres.MigrationBackend.fs
- README.md
- ReadWriteReferences.fs
- Rezoom.SQL.Compiler.fsproj
- SourceTypes.fs
- SQLite.fs
- SQLite.Functions.fs
- Translators.fs
- TSQL.Expression.fs
- TSQL.fs
- TSQL.Functions.fs
- TSQL.MigrationBackend.fs
- TSQL.Statement.fs
- TypeChecker.fs
- TypeInferenceContext.fs
- TypeNameForCLRType.fs
- TypeSystem.fs
- UserModel.fs
- UserTypeResolutionPass.fs
- Utilities.fs
- AssemblyInfo.fs
- Asynchronous.fs
- Asynchronous.fsi
- Backend.fs
- Blueprint.fs
- BlueprintAttributes.fs
- BlueprintModule.fs
- CILHelpers.fs
- CollectionConverters.fs
- ColumnMap.fs
- Command.fs
- CommandBatch.fs
- CommandParts.fs
- CompositeColumnGenerator.fs
- ConfigurationConnectionProvider.fs
- ConnectionContext.fs
- ConnectionProvider.fs
- Converters.fs
- DataReader.fs
- EntityReader.fs
- EntityReaderColumnGenerator.fs
- FreezeDry.fs
- IScalar.fs
- Levenshtein.fs
- ManyColumnGenerator.fs
- ManyEntityColumnGenerator.fs
- Migrations.fs
- Plans.fs
- Plans.fsi
- PrimitiveColumnGenerator.fs
- PrimitiveConverters.fs
- Raw.fs
- README.md
- README_DEV.md
- Rezoom.SQL.Mapping.fsproj
- Row.fs
- RuntimeUserConvert.fs
- StaticEntityReaderTemplate.fs
- Synchronous.fs
- Synchronous.fsi
- UserTypeAnnotations.fs
- UserTypeLibrary.fs
- UserTypeLibraryLoader.fs
- AssemblyInfo.fs
- CompileTimeColumnMap.fs
- DocStrings.fs
- InterfaceImpls.fs
- ProvidedTypes-LICENSE.md
- ProvidedTypes.fs
- ProvidedTypes.fsi
- Provider.fs
- README.md
- Rezoom.SQL.Provider.fsproj
- TypeGeneration.fs
- UserModelCache.fs
- Watcher.fs
- README.md
- Rezoom.SQL.Provider.Postgres.csproj
- README.md
- Rezoom.SQL.Provider.SQLite.csproj
- rzsql.json
- V1.init.sql
- rzsql.json
- V1.init.sql
- AttributesTests.cs
- BasicTests.cs
- ErrorTests.cs
- InterfaceTests.cs
- ProviderHarness.cs
- Rezoom.SQL.Provider.Test.csproj
- README.md
- Rezoom.SQL.Provider.TSQL.csproj
- rzsql.json
- V1.initial.sql
- V2.view.sql
- rzsql.json
- V1.initial-employer.sql
- V1.initial-groups.sql
- V1.initial.sql
- V2.companygroups.sql
- README.md
- V1.initial-drop.sql
- V1.initial.sql
- README.md
- V1.initial.sql
- V2.bad.sql
- V1.comments-time.sql
- V1.foos-bars.sql
- V1.groups-foos.sql
- V1.model-comments.sql
- V1.model-groups.sql
- V1.model.sql
- V2.next-baz.sql
- V2.next-qux.sql
- V2.next.sql
- README.md
- V1.model-a.sql
- V1.model-b.sql
- V1.model.sql
- V1.a-b.sql
- V1.model-a.sql
- V1.model.sql
- rzsql.json
- V1.initial.sql
- V2.view.sql
- Environment.fs
- Program.fs
- Rezoom.SQL.Test.fsproj
- TestAggregateErrors.fs
- TestAlterTable.fs
- TestBlueprints.fs
- TestCompositeReaders.fs
- TestCTEs.fs
- TestIdempotence.fs
- TestLevenshtein.fs
- TestManyPrimitives.fs
- TestMigrations.fs
- TestModel.fs
- TestModelErrors.fs
- TestNavProperties.fs
- TestNullInference.fs
- TestParserErrors.fs
- TestPostgres.fs
- TestPostgresSmoke.fs
- TestPrimitiveReaders.fs
- TestQueryParents.fs
- TestReadWriteReferences.fs
- TestRoundTrip.fs
- TestRowTypesDeclarations.fs
- TestSQLite.fs
- TestStaticRowCount.fs
- TestTQLSmoke.fs
- TestTSQL.fs
- TestTypeErrors.fs
- TestTypeInference.fs
- TestUserPrimitives.fs
- TestUserPrimitivesCompiler.fs
- TestUserTypeAnnotations.fs
- TestVendorStatements.fs
- Rezoom.SQL.Test.UserTypes.fsproj
- UserInterfaces.fs
- UserPrimitives.fs
- Library.fs
- TypeProviderUser.BclOnlyTypes.fsproj
- appsettings.json
- AssemblyInfo.fs
- Program.fs
- rzsql.json
- Shared.fs
- TestMigrateConnectionString.fs
- TestSelects.fs
- TestUserPrimitivePoint.fs
- TestUserPrimitiveSystemObject.fs
- TypeProviderUser.Postgres.fsproj
- V1.model.sql
- Library.fs
- TypeProviderUser.Postgres.UserTypes.fsproj
- appsettings.json
- AssemblyInfo.fs
- Program.fs
- rzsql.json
- Shared.fs
- TestMigrateConnectionString.fs
- TestPickles.fs
- TestRowTypeInterfaces.fs
- TestSelects.fs
- TestUserPrimitiveByteArray.fs
- TestUserPrimitiveEnum.fs
- TestUserTypeAnnotations.fs
- TypeProviderUser.SQLite.fsproj
- V1.model.sql
- appsettings.json
- AssemblyInfo.fs
- Program.fs
- rzsql.json
- Shared.fs
- TestMigrateConnectionString.fs
- TestSelects.fs
- TestUserPrimitiveGeography.fs
- TestUserPrimitiveJson.fs
- TypeProviderUser.TSQL.fsproj
- V1.model.sql
- Library.fs
- TypeProviderUser.TSQL.UserTypes.fsproj
- Library.fs
- TypeProviderUser.UserTypes.fsproj
- test-tp-users.ps1
- test-vs-build.ps1
- TypeProviderUsers.sln
- Rezoom.SQL.sln
- .deployment
- .gitattributes
- .gitignore
- _config.yml
- AGENTS.md
- CHANGELOG.md
- DEVELOPER_README.md
- Directory.Build.props
- Gemfile
- LICENSE.txt
- README.md
- SUMMARY.md
- version.props
# Installation Guide
1. Get the code
git clone https://github.com/fsprojects/Rezoom.SQL
Downloads the entire project code from GitHub to your computer.
cd Rezoom.SQL
Moves into the project folder you just downloaded.
2. .NET
Medium RecommendedPrerequisites
β οΈ This is a large repository, so this method may point to an internal sub-package rather than the actual core product. Check the full README as well.
cd src/Rezoom.SQL.Annotations
This project's files live in a subfolder, so move into it first.
dotnet restore
Downloads the packages the project depends on.
dotnet run
Builds the project and runs it immediately.
After dotnet run, check the message or address shown in the terminal.
3. Ruby
EasyPrerequisites
bundle install
Installs the Ruby libraries listed in the Gemfile.
If bundle install finishes without errors, continue with the run command from the README (e.g. rails server).
// repository documentation
Was this content helpful?
(0 ratings)
