[MAUI 專案實戰] 筆記App（二）：資料庫設計

林晓lx發表於2024-07-19

Sqlite配置
建立實體
- 筆記實體類
- 筆記分組實體
- 筆記片段實體
- 筆記片段負載實體
- 筆記片段倉庫實體
- 筆記模板（場景）實體
- 筆記片段模板實體
- 筆記片段模板負載實體
配置EF
建立對映
遷移和種子資料
專案地址

Sqlite配置

應用程式裡使用Sqlite作為資料庫，使用EntityFramworkCore作為ORM，使用CodeFirst方式用EFCore初始化Sqlite資料庫檔案：mato.db

在MatoProductivity.Core專案的appsettings.json中新增本地sqlite連線字串

  "ConnectionStrings": {
    "Default": "Data Source=file:{0};"
  },
  ...

這裡檔案是一個佔位符，透過程式碼hardcode到配置檔案

在MatoProductivityCoreModule.cs中，重寫PreInitialize並設定Configuration.DefaultNameOrConnectionString：

public override void PreInitialize()
{
    LocalizationConfigurer.Configure(Configuration.Localization);

    Configuration.Settings.Providers.Add<CommonSettingProvider>();

    string documentsPath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), MatoProductivityConsts.LocalizationSourceName);

    var configuration = AppConfigurations.Get(documentsPath, development);
    var connectionString = configuration.GetConnectionString(MatoProductivityConsts.ConnectionStringName);

    var dbName = "mato.db";
    string dbPath = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), MatoProductivityConsts.LocalizationSourceName, dbName);

    Configuration.DefaultNameOrConnectionString = String.Format(connectionString, dbPath);
    base.PreInitialize();
}

建立實體

接下來定義實體類

筆記實體類

筆記用於儲存實體，在筆記列表中，每個筆記都有標題和內容，建立時間等內容。

定義於\MatoProductivity.Core\Models\Entities\Note.cs


public class Note : FullAuditedEntity<long>
{
    public Note()
    {

    }
    public Note(string name, bool isHidden, bool isRemovable)
    {
        Title = name;
        IsHidden = isHidden;
        IsRemovable = isRemovable;
    }


    [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public override long Id { get; set; }

    public ICollection<NoteSegment> NoteSegments { get; set; }

    public string Title { get; set; }
    public string Type { get; set; }
    public string Status { get; set; }
    public string Desc { get; set; }
    public string Icon { get; set; }
    public string Color { get; set; }
    public string BackgroundColor { get; set; }
    public string BackgroundImage { get; set; }

    public string PreViewContent { get; set; }

    public bool IsEditable { get; set; }

    public bool IsHidden { get; set; }

    public bool IsRemovable { get; set; }
    public bool CanSimplified { get; set; }

}

筆記分組實體

定義於\MatoProductivity.Core\Models\Entities\NoteGroup.cs

public class NoteGroup : FullAuditedEntity<long>
{
    public NoteGroup()
    {

    }
    public NoteGroup(string name, bool isHidden, bool isRemovable)
    {
        Title = name;
        IsHidden = isHidden;
        IsRemovable = isRemovable;
    }

    [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public override long Id { get; set; }
    public string Title { get; set; }

    public bool IsHidden { get; set; }

    public bool IsRemovable { get; set; }

    public ICollection<Note> Notes { get; set; }
}

筆記片段實體

定義於\MatoProductivity.Core\Models\Entities\NoteSegment.cs

public class NoteSegment : FullAuditedEntity<long>, INoteSegment
{
    public NoteSegment()
    {

    }



    [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public override long Id { get; set; }

    [ForeignKey(nameof(NoteId))]
    public Note Note { get; set; }

    public ICollection<NoteSegmentPayload> NoteSegmentPayloads { get; set; }

    public long NoteId { get; set; }

    public string Title { get; set; }
    public string Type { get; set; }
    public string Status { get; set; }
    public string Desc { get; set; }
    public string Icon { get; set; }
    public string Color { get; set; }
    public int Rank { get; set; }

    public bool IsHidden { get; set; }

    public bool IsRemovable { get; set; }


    public INoteSegmentPayload GetNoteSegmentPayload(string key)
    {
        if (NoteSegmentPayloads != null)
        {
            return NoteSegmentPayloads.FirstOrDefault(c => c.Key == key);
        }
        return default;
    }




    public void SetNoteSegmentPayload(INoteSegmentPayload noteSegmentPayload)
    {
        if (NoteSegmentPayloads != null)
        {
            var currentPayload = NoteSegmentPayloads.FirstOrDefault(c => c.Key == noteSegmentPayload.Key);
            if (currentPayload != null)
            {
                NoteSegmentPayloads.Remove(currentPayload);
            }
            if (!this.IsTransient())
            {
                (noteSegmentPayload as NoteSegmentPayload).NoteSegmentId = this.Id;
            }
            NoteSegmentPayloads.Add((noteSegmentPayload as NoteSegmentPayload));
        }
    }

    public INoteSegmentPayload GetOrSetNoteSegmentPayload(string key, INoteSegmentPayload noteSegmentPayload)
    {
        if (NoteSegmentPayloads != null)
        {
            var currentPayload = NoteSegmentPayloads.FirstOrDefault(c => c.Key == key);
            if (currentPayload != null)
            {
                return currentPayload;
            }
            if (noteSegmentPayload != null)
            {
                if (!this.IsTransient())
                {
                    (noteSegmentPayload as NoteSegmentPayload).NoteSegmentId = this.Id;
                }
                NoteSegmentPayloads.Add((noteSegmentPayload as NoteSegmentPayload));
            }
            return noteSegmentPayload;
        }
        return noteSegmentPayload;
    }

}

筆記片段負載實體

筆記片段負載與筆記片段實體為一對多的關係，用於儲存筆記片段的詳細內容。

定義於\MatoProductivity.Core\Models\Entities\NoteSegmentPayload.cs

public class NoteSegmentPayload : FullAuditedEntity<long>, INoteSegmentPayload
{
    public NoteSegmentPayload()
    {

    }


    public NoteSegmentPayload(string key, object value, string valuetype = null)
    {
        if (value is string)
        {
            this.SetStringValue((value as string).ToString());
        }
        else if (value is byte[])
        {
            this.Value = value as byte[];
        }
        else if (value is DateTime)
        {
            this.SetStringValue(((DateTime)value).ToString("yyyy-MM-dd HH:mm:ss"));
        }
        else
        {
            this.SetStringValue(value.ToString());
        }
        this.Key = key;
        this.ValueType = valuetype;

    }




    [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public override long Id { get; set; }

    [ForeignKey(nameof(NoteSegmentId))]
    public NoteSegment NoteSegment { get; set; }

    public long NoteSegmentId { get; set; }

    public string Key { get; set; }

    public byte[] Value { get; set; }

    public string ValueType { get; set; }

    [NotMapped]
    public string StringValue => GetStringValue();

    public T GetConcreteValue<T>() where T : struct
    {
        var value = Encoding.UTF8.GetString(Value);
        T result = value.To<T>();
        return result;
    }

    public string GetStringValue()
    {
        var value = Encoding.UTF8.GetString(Value);
        return value;
    }

    public void SetStringValue(string value)
    {
        this.Value = Encoding.UTF8.GetBytes(value);
    }
}

筆記片段倉庫實體

用於在編輯筆記頁面的新增片段選單中，載入所有可用的片段

定義於\MatoProductivity.Core\Models\Entities\NoteSegmentStore.cs

public class NoteSegmentStore : Entity<long>
{
    
    [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public override long Id { get; set; }
    public string Title { get; set; }
    public string Type { get; set; }
    public string Category { get; set; }
    public string Status { get; set; }
    public string Desc { get; set; }
    public string Icon { get; set; }
    public string Color { get; set; }
    public bool IsHidden { get; set; }

    public bool IsRemovable { get; set; }


}

筆記模板（場景）實體

定義於\MatoProductivity.Core\Models\Entities\NoteTemplate.cs

public class NoteTemplate : FullAuditedEntity<long>
{
    public NoteTemplate()
    {

    }
    public NoteTemplate(string name, bool isHidden, bool isRemovable)
    {
        Title = name;
        IsHidden = isHidden;
        IsRemovable = isRemovable;
    }
    
    [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public override long Id { get; set; }

    public ICollection<NoteSegmentTemplate> NoteSegmentTemplates { get; set; }

    public string Title { get; set; }
    public string Type { get; set; }
    public string Status { get; set; }
    public string Desc { get; set; }
    public string Icon { get; set; }
    public string Color { get; set; }
    public string BackgroundColor { get; set; }
    public string BackgroundImage { get; set; }

    public string PreViewContent { get; set; }

    public bool IsEditable { get; set; }

    public bool IsHidden { get; set; }

    public bool IsRemovable { get; set; }

    public bool CanSimplified { get; set; }


}

筆記片段模板實體

定義於\MatoProductivity.Core\Models\Entities\NoteSegmentTemplate.cs

public class NoteSegmentTemplate : FullAuditedEntity<long>, INoteSegment
{
    public NoteSegmentTemplate()
    {

    }



    [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public override long Id { get; set; }

    [ForeignKey(nameof(NoteTemplateId))]
    public NoteTemplate NoteTemplate { get; set; }

    public ICollection<NoteSegmentTemplatePayload> NoteSegmentTemplatePayloads { get; set; }

    public long NoteTemplateId { get; set; }

    public string Title { get; set; }
    public string Type { get; set; }
    public string Status { get; set; }
    public string Desc { get; set; }
    public string Icon { get; set; }
    public string Color { get; set; }
    public int Rank { get; set; }

    public bool IsHidden { get; set; }

    public bool IsRemovable { get; set; }


    public INoteSegmentPayload GetNoteSegmentPayload(string key)
    {
        if (NoteSegmentTemplatePayloads != null)
        {
            return NoteSegmentTemplatePayloads.FirstOrDefault(c => c.Key == key);
        }
        return default;
    }

    public void SetNoteSegmentPayload(INoteSegmentPayload noteSegmentPayload)
    {
        if (NoteSegmentTemplatePayloads != null)
        {
            var currentPayload = NoteSegmentTemplatePayloads.FirstOrDefault(c => c.Key == noteSegmentPayload.Key);
            if (currentPayload != null)
            {
                NoteSegmentTemplatePayloads.Remove(currentPayload);
            }
            if (!this.IsTransient())
            {
                (noteSegmentPayload as NoteSegmentTemplatePayload).NoteSegmentTemplateId = this.Id;
            }
            NoteSegmentTemplatePayloads.Add((noteSegmentPayload as NoteSegmentTemplatePayload));
        }
    }

    public INoteSegmentPayload GetOrSetNoteSegmentPayload(string key, INoteSegmentPayload noteSegmentPayload)
    {
        if (NoteSegmentTemplatePayloads != null)
        {
            var currentPayload = NoteSegmentTemplatePayloads.FirstOrDefault(c => c.Key == key);
            if (currentPayload != null)
            {
                return currentPayload;
            }
            if (noteSegmentPayload != null)
            {
                if (!this.IsTransient())
                {
                    (noteSegmentPayload as NoteSegmentTemplatePayload).NoteSegmentTemplateId = this.Id;
                }
                NoteSegmentTemplatePayloads.Add((noteSegmentPayload as NoteSegmentTemplatePayload));
            }
            return noteSegmentPayload;
        }
        return noteSegmentPayload;
    }

}

筆記片段模板負載實體

定義於\MatoProductivity.Core\Models\Entities\NoteSegmentTemplatePayload.cs

public class NoteSegmentTemplatePayload : FullAuditedEntity<long>, INoteSegmentPayload
{
    public NoteSegmentTemplatePayload()
    {

    }



    public NoteSegmentTemplatePayload(string key, object value, string valuetype = null)
    {
        if (value is string)
        {
            this.SetStringValue((value as string).ToString());
        }
        else if (value is byte[])
        {
            this.Value = value as byte[];
        }
        else if (value is DateTime)
        {
            this.SetStringValue(((DateTime)value).ToString("yyyy-MM-dd HH:mm:ss"));
        }
        else
        {
            this.SetStringValue(value.ToString());
        }
        this.Key = key;
        this.ValueType = valuetype;

    }



    [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public override long Id { get; set; }

    [ForeignKey(nameof(NoteSegmentTemplateId))]
    public NoteSegmentTemplate NoteSegmentTemplate { get; set; }

    public long NoteSegmentTemplateId { get; set; }

    public string Key { get; set; }

    public byte[] Value { get; set; }

    public string ValueType { get; set; }

    [NotMapped]
    public string StringValue => GetStringValue();

    public T GetConcreteValue<T>() where T : struct
    {
        var value = Encoding.UTF8.GetString(Value);
        T result = value.To<T>();
        return result;
    }

    public string GetStringValue()
    {
        var value = Encoding.UTF8.GetString(Value);
        return value;
    }

    public void SetStringValue(string value)
    {
        this.Value = Encoding.UTF8.GetBytes(value);
    }
}

配置EF

資料庫上下文物件MatoProductivityDbContext定義如下

    public class MatoProductivityDbContext : AbpDbContext
    {
        //Add DbSet properties for your entities...

        public DbSet<Note> Note { get; set; }
        public DbSet<NoteGroup> NoteGroup { get; set; }
        public DbSet<NoteSegment> NoteSegment { get; set; }
        public DbSet<NoteSegmentStore> NoteSegmentStore { get; set; }
        public DbSet<NoteSegmentPayload> NoteSegmentPayload { get; set; }
        public DbSet<NoteTemplate> NoteTemplate { get; set; }
        public DbSet<NoteSegmentTemplate> NoteSegmentTemplate { get; set; }
        public DbSet<NoteSegmentTemplatePayload> NoteSegmentTemplatePayload { get; set; }
        public DbSet<Theme> Theme { get; set; }
        public DbSet<Setting> Setting { get; set; }
        public MatoProductivityDbContext(DbContextOptions<MatoProductivityDbContext> options) 
            : base(options)
        {

        }
    }

MatoProductivity.EntityFrameworkCore是應用程式資料庫的維護和管理專案，依賴於Abp.EntityFrameworkCore。
在MatoProductivity.EntityFrameworkCore專案中csproj檔案中，引用下列包

<PackageReference Include="Abp.EntityFrameworkCore" Version="7.4.0" />
<PackageReference Include="Microsoft.EntityFrameworkCore" Version="7.0.0" />
<PackageReference Include="Microsoft.EntityFrameworkCore.Sqlite" Version="7.0.0" />
<PackageReference Include="Microsoft.EntityFrameworkCore.Sqlite.Design" Version="1.1.6" />
<PackageReference Include="Microsoft.EntityFrameworkCore.Tools" Version="7.0.0">

在該專案MatoProductivityEntityFrameworkCoreModule.cs 中，將註冊上下文物件，並在程式初始化執行遷移，此時將在裝置上生成mato.db檔案

public override void PostInitialize()
{
    Helper.WithDbContextHelper.WithDbContext<MatoProductivityDbContext>(IocManager, RunMigrate);
    if (!SkipDbSeed)
    {
        SeedHelper.SeedHostDb(IocManager);
    }
}

public static void RunMigrate(MatoProductivityDbContext dbContext)
{
    dbContext.Database.Migrate();
}

建立對映

從場景到筆記，或者說從模板到例項，我們需要對映，例如從筆記片段選單中選擇一個片段新增，那麼需要從筆記片段倉庫實體（NoteSegmentStore）對映到筆記片段實體（NoteSegment）或者，在編輯場景中，對映到筆記片段模板實體（NoteSegmentTemplate）。

[AutoMapTo(typeof(NoteSegment), typeof(NoteSegmentTemplate))]

public class NoteSegmentStore : Entity<long>
{
    ...
}

使用時：

var note = ObjectMapper.Map<NoteSegment>(noteSegmentStore);

ABP框架預設使用AutoMapper進行對映，所以需要配置對映關係。

Configuration.Modules.AbpAutoMapper().Configurators.Add(config =>
{
    IgnoreAbpProperties(config.CreateMap<NoteTemplate, Note>()
    .ForMember(
        c => c.NoteSegments,
        options => options.MapFrom(input => input.NoteSegmentTemplates))
      .ForMember(
        c => c.Id,
        options => options.Ignore()));


    IgnoreAbpProperties(config.CreateMap<Note, NoteTemplate>()
       .ForMember(
           c => c.NoteSegmentTemplates,
           options => options.MapFrom(input => input.NoteSegments))
      .ForMember(
        c => c.Id,
        options => options.Ignore()));


    IgnoreAbpProperties(config.CreateMap<NoteSegmentTemplate, NoteSegment>()
    .ForMember(
        c => c.Note,
        options => options.MapFrom(input => input.NoteTemplate))
    .ForMember(
        c => c.NoteSegmentPayloads,
        options => options.MapFrom(input => input.NoteSegmentTemplatePayloads))
     .ForMember(
        c => c.NoteId,
        options => options.Ignore())
      .ForMember(
        c => c.Id,
        options => options.Ignore()));

    IgnoreAbpProperties(config.CreateMap<NoteSegmentStore, NoteSegment>()
     .ForMember(
       c => c.Id,
       options => options.Ignore()));

    IgnoreAbpProperties(config.CreateMap<NoteSegment, NoteSegmentTemplate>()
       .ForMember(
        c => c.NoteTemplate,
        options => options.MapFrom(input => input.Note))
       .ForMember(
        c => c.NoteTemplateId,
        options => options.Ignore())
       .ForMember(
           c => c.NoteSegmentTemplatePayloads,
           options => options.MapFrom(input => input.NoteSegmentPayloads))
      .ForMember(
        c => c.Id,
        options => options.Ignore()));

    IgnoreAbpProperties(config.CreateMap<NoteSegmentTemplatePayload, NoteSegmentPayload>()
       .ForMember(
           c => c.NoteSegment,
           options => options.MapFrom(input => input.NoteSegmentTemplate))
       .ForMember(
        c => c.NoteSegmentId,
        options => options.Ignore())

      .ForMember(
        c => c.Id,
        options => options.Ignore()));

    IgnoreAbpProperties(
    config.CreateMap<NoteSegmentPayload, NoteSegmentTemplatePayload>()
       .ForMember(
           c => c.NoteSegmentTemplate,
           options => options.MapFrom(input => input.NoteSegment))
       .ForMember(
        c => c.NoteSegmentTemplateId,
        options => options.Ignore()));



});

遷移和種子資料

MatoProductivity.EntityFrameworkCore.Seed.SeedHelper可在程式啟動時，訪問資料庫，並初始化種子資料。

public override void PostInitialize()
{
    Helper.WithDbContextHelper.WithDbContext<MatoProductivityDbContext>(IocManager, RunMigrate);
    if (!SkipDbSeed)
    {
        SeedHelper.SeedHostDb(IocManager);
    }
}

它透過SkipDbSeed來決定是否跳過執行種子資料初始化。我們需要在安裝完成App後第一次執行才執行種子資料初始化。

MAUI中提供了VersionTracking.Default.IsFirstLaunchEver方式獲取是否是第一次在此裝置上啟動應用，請檢視官方文件

public override async void Initialize()
{
    IocManager.RegisterAssemblyByConvention(typeof(MatoProductivityModule).GetAssembly());
    if (VersionTracking.Default.IsFirstLaunchEver)
    {
        MatoProductivityEntityFrameworkCoreModule.SkipDbSeed = false;
    }
    else
    {
        MatoProductivityEntityFrameworkCoreModule.SkipDbSeed = true;

    }
}

在InitialDbBuilder中我們定義了大多數的業務初始資料，具體的實現方式請查閱原始碼。

internal void Create()
{

    CreateSetting("Theme", "Light");
    CreateSetting("DetailPageMode", "PreviewPage");


    CreateNoteSegmentStore("時間戳", "時間/提醒", "DateTimeSegment", "記錄一個瞬時時間", FaIcons.IconClockO, "#D8292B");
    CreateNoteSegmentStore("計時器", "時間/提醒", "TimerSegment", "建立一個計時器，當它結束時會通知您", FaIcons.IconBell, "#D8292B");
    CreateNoteSegmentStore("筆記", "文字", "TextSegment", "隨時用文字記錄您的想法", FaIcons.IconStickyNoteO, "#E1A08B");
    CreateNoteSegmentStore("Todo", "文字", "TodoSegment", "記錄一個Todo專案", FaIcons.IconCheckSquareO, "#E1A08B");
    CreateNoteSegmentStore("數值", "文字", "KeyValueSegment", "記錄數值，以便統計資料", FaIcons.IconLineChart, "#E1A08B");
    CreateNoteSegmentStore("手繪", "檔案", "ScriptSegment", "建立一個手繪", FaIcons.IconPaintBrush, "#AD9CC2");
    CreateNoteSegmentStore("照片/影片", "檔案", "MediaSegment", "拍照或攝像", FaIcons.IconCamera, "#AD9CC2");
    CreateNoteSegmentStore("文件", "檔案", "DocumentSegment", "從您裝置中選取一個文件", FaIcons.IconFile, "#AD9CC2");
    CreateNoteSegmentStore("錄音", "檔案", "VoiceSegment", "記錄一段聲音", FaIcons.IconMicrophone, "#AD9CC2");
    CreateNoteSegmentStore("地點", "其它", "LocationSegment", "獲取當前地點，或者從地圖上選取一個地點", FaIcons.IconMapMarker, "#6D987C");
    CreateNoteSegmentStore("天氣", "其它", "WeatherSegment", "獲取當前天氣資訊", FaIcons.IconCloud, "#6D987C");
    CreateNoteSegmentStore("聯絡人", "其它", "ContactSegment", "從您裝置的通訊錄中選擇一個聯絡人", FaIcons.IconUser, "#6D987C");
}

專案地址

GitHub:MatoProductivity

[MAUI 專案實戰] 筆記App（一）：介紹與程式設計
2024-07-18
UI筆記APP程式設計
專案資料庫表設計與建立模型
2019-04-04
資料庫模型
客快物流大資料專案(五十一)：資料庫表分析物流專案資料庫表設計
2024-03-29
大資料資料庫
打造全網最全電商實戰專案系列教程[商品功能模組資料庫設計]
2021-06-07
資料庫
入門Python資料分析最好的實戰專案（二）
2019-02-16
Python
20分鐘資料庫索引設計實戰
2019-02-16
資料庫索引
手把手0基礎專案實戰（二）——微服務架構下的資料庫分庫分表實戰
2019-03-01
微服務架構資料庫
Vue + Spring Boot 專案實戰（四）：資料庫的引入
2019-04-14
VueSpring Boot資料庫
orientDB學習筆記（三）資料庫構架設計
2022-01-13
筆記資料庫
[Triton課程筆記] 1.2.1 程式設計實戰-準備模型倉庫
2024-06-26
筆記程式設計模型
IDEA匯入專案筆記二
2020-09-28
Idea筆記
資料分析視覺化專案（二）--谷歌App store
2020-11-27
視覺化谷歌APP
Spring 學習筆記（6）Spring和資料庫程式設計
2022-01-26
Spring筆記資料庫程式設計
推薦 Go 實戰專案—高效能 kv 資料庫 LotusDB
2022-01-24
Go資料庫
App專案實戰之路(三):原型篇
2019-03-04
APP原型
Python資料分析與挖掘實戰筆記
2020-10-04
Python筆記
Python學習筆記——爬蟲之Scrapy專案實戰
2018-09-03
Python筆記爬蟲
資料庫實驗五：資料庫程式設計
2024-06-16
資料庫程式設計
資料庫實驗八資料庫程式設計
2020-12-24
資料庫程式設計
【資料庫設計】資料庫的設計
2018-06-21
資料庫
[XXX商城專案-筆記] 設計介面基本思路
2020-12-13
筆記
大資料爬蟲專案實戰教程
2018-11-14
大資料爬蟲
[MAUI 專案實戰] 手勢控制音樂播放器（三）：動畫
2023-04-09
UI播放器動畫
＜數字IC設計＞實戰專案之GPIO埠設計 3
2020-10-08
學習筆記(30):Python資料清洗實戰-Excel檔案讀寫
2020-02-21
筆記PythonExcel
架構設計（二）：資料庫複製
2022-12-14
架構資料庫
Vue2.x實戰餓了麼專案筆記（一）
2018-11-08
Vue筆記
記某專案的二顧茅廬5K實戰
2024-08-28
【筆記】-《Redis實戰》- 01 Redis資料結構
2018-12-13
筆記Redis資料結構
Mysql百萬級資料遷移實戰筆記
2018-06-30
MySql筆記
《Redis設計與實現》筆記 -- 資料結構與物件
2019-04-01
Redis筆記資料結構物件
【設計模式筆記】（二）- Builder模式
2018-03-15
設計模式筆記UI
Rust程式設計與專案實戰-結構體
2024-11-08
Rust程式設計結構體
iOS – RxSwift 專案實戰記錄
2019-03-04
iOSSwift
手把手和你一起實現一個Web框架實戰——EzWeb框架(二)[Go語言筆記]Go專案實戰
2021-08-17
Web框架Go筆記
GO web 開發實戰二，資料庫相關
2023-01-29
GoWeb資料庫
資料庫課程作業筆記 - 編寫資料庫遷移檔案
2019-04-24
資料庫筆記
打造全網最全電商實戰專案系列教程[資料庫概括篇]
2021-05-31
資料庫